INF3560: Database Design

Fall 2007 Campuses: Beren,Wilf Sections: QRT,251 CRNs: 12402,10770

Click here to see the Syllabus

Password

NOTE: for some of the links on this page you will need a password to access the information. I will tell you the password in class.

Original yrosenthal.com Powerpoints

(Powerpoint)	Review of SQL Select Statement
(Powerpoint)	Transactions

HW questions

Student files

You should download the files from the following URL to help you do your HW. These files include the sample database.

http://www.murach.com/downloads/sql5.htm

Exercises

The following is a document with HW exercises for each chapter. You are required to do all of the problems for each chapter as we complete the chapters.

http://yrosenthal.com/pub/murachsql2005/Exercises.doc

Solutions

I will post solutions to the HWs as we proceed through the semester.

Chapter 3	Chapter 4	Chapter 5	Chapter 6	Chapter 7
Chapter 8	Chapter 10	Chapter 12	Chapter 13	Chapter 14
Chapter 15	Chapter 16	Chapter 17

Sample Database Design for Movies Database

Click Here

SQL Server Express

Download SQL Server 2005 Express: http://msdn2.microsoft.com/en-us/express/aa718378.aspx.

Powerpoints (warning - these may change as the semester progresses)

ch01	ch02	ch03	ch04	ch05	ch06	ch07	ch08	ch09	ch10
ch11	ch12	ch13	ch14	ch15	ch16	ch17	ch18	ch19	ch20
ch21

USERID	PASSWORD