• Web Design & Development(INF2250)
• Intro to Information Technology (INF1030)
• Database Management(INF3560)
• Class Calendar (all classes)

• Angel (submit HW, email class members)
• YU email (i.e. YUMS)
• YU Calendar
• YU Catalog

• Intro to Information Technology (INF1030)
• Systems Analysis & Design (INF2822)

• Excel for Business (INF2150)
• Mgmt Info Systems(INF1020)
• Perl Programming (INF2140)

• Web Design (INF3832)
• Intro to Information Technology (INF1030)
• Database Design (INF3560)

• Intro to Information Technology (INF1030)
• Advanced Visual Basic (INF3835)
• Excel For Business (INF2150)
• *** Books ***

• MIS (INF1020)
• Intro to Information Technology (INF1030)
• Database Design (INF3560)
• Web Design (INF3832)

• MIS (INF1020)
• Intro to Information Technology (INF1030)
• Perl Programming (INF2140)
• Excel for Business (INF2150)

• MIS (INF1020)
• Intro to Information Technology (INF1030)
• DB Design (INF3560)
• Prestatistics for Business (STB0001)

• See Angel

INF3560: Database Design

Fall 2006      Campus: Wilf      Section: 331      CRN: 49370

• Click here to see the Syllabus
• Homework Assignments (modified : August 26 2007 17:29:57)
• Review Questions (modified : August 26 2007 17:29:57)

---

Class Materials

MATERIALS FOR FEHILY BOOK (Weblink) Website for SQL Visual Quickstart Guide by Fehily (Weblink) Click here to get downloads for the book. (Link) New authors table to use in class (WordDocument) ERD and Description of Books database MATERIALS FOR MURACH BOOK (PDF file) Student Workbook for "Murach's SQL for SQL Server" (Powerpoint) DataTypes and Functions (Murach - chap 8) (Powerpoint) Designing a Database (Murach - chap 9) (Powerpoint) Creating Databases and Tables (Murach - chap 10) (Powerpoint) Enterprise Manager (Murach - chap 11) (Powerpoint) Views (Murach - chap 12) (Powerpoint) SQL Server Scripts (Murach - chap 13) (Powerpoint) SQL Server Stored Procedures (Murach - chap 14) (Powerpoint) SQL Server Cursors - (Murach - chap 15) (Powerpoint) Transactions and Locking (Murach - chap 16) (Powerpoint) Database Security (Murach - chap 17)

NOTES FROM CLASS (Powerpoint) Review of SQL Select Statement (Powerpoint) Transactions SQL SERVER DOCUMENTATION (Link) Installing SQL Server 2000 (developer edition) (WebLink) Microsoft SQL Server 2000 Homepage (WebLink) "Transact" SQL Reference (WebLink) SQL Server data types (WebLink) How to copy a SQL Server database to another computer.

Download Software

• You can download a .iso file for SQL Server 2000, Developer edition from the following link.
  
       http://yrosenthal.com/restricted/en_sql_2000_dev.iso.
  
  NOTE THAT YOU WILL NEED A USERID AND PASSWORD TO ACCESS THIS LINK. LOOK FOR A MESSAGE IN YOUR YU EMAIL TO GET THE USERID AND PASSWORD.
  
  To burn a .iso file to a CD sometimes requires a special process depending on your CD writer software. If you don't know how to burn a .iso file to a CD, you can see the following link (Note that I haven't followed these specific instructions myself)
  
       http://www.petri.co.il/how_to_write_iso_files_to_cd.htm
  
  
• Click here for step by step instructions for performing the installation. These instructions were prepared for a different set of installation disks and hence they might not reflect EXACTLY what you see. For example the program to start the installation might be in a different folder. However, I don't think that you will have any problems following these directions. These instructions contain a section on installing service pack 3a from the CD. However, the CD image currently posted on this site does not have the service pack included. You should download and install the latest service packs for SQL Server 2000, Developer edition from the following location:
  
       http://www.microsoft.com/sql/downloads/2000/default.mspx
• For more information about SQL Server, you can see the section above on this page entitled "SQL SERVER DOCUMENTATION"