Using and Designing Database

1
Using and Designing Database

• ITEC 3220
• Section C
• Fall 2005

2
Course Information

• My Web page
• www.atkinson.yorku.ca/marina
• Class web site
• www.atkinson.yorku.ca/marina/COL3220C05.htm
• Lectures
• R 1900 2200
• Make own notes!

3
Syllabus

• Database Models
• Database Conceptual Design and ER Modeling
• Logical Database Design
• Structured Query Language
• Normalization theory
• Trends in DBMSs

4
Required Material

• Database Systems. Design, Implementation, and
  Management,
• Sixth Edition.
• P. Rob, C. Coronel
• Course Technology, a division of Thompson
  Learning, Inc., 2004.
• ISBN 0-619-21323-X

5
Recommended Reading

• A Guide to SQL, 6/e. Philip J. Pratt Course
  Technology, a division of Thompson Learning,
  Inc., 2003.0-619-15957-X
• Database Systems. A Practical Approach to Design,
  Implementation, and Management, 3/e. T. Connolly,
  C. Begg. Addison Wesley, 2002. ISBN 0-201-70857-4
  
• Database Management Systems, 2/e. Ramakrishnan,
  R., Gehrke, J. McGraw Hill, 2000. ISBN
  0-07-232206-3.

6
Important Dates

• October 30, 2005 Mid-Term Exam
• October 13, 2005 no classes
• October 27, 2005 tutorial
• November 11, 2005 last date to drop the course
  without receiving a grade
• November 11, 2005 - 15 Graded Feedback
  Deadline  
• December 1, 2005 Final Exam review

7
Course Assessment and Grading Scheme

• Item Weight
• Assignment 1 8
• Assignment 2 7
• Assignment 3 8
• Assignment 4 7
• Mid-Term exam                    25
• Final exam                                    45
• If you do better on the final exam than on the
  mid-term exam, your final exam mark will replace
  you mid-term mark

8
Assignments

• Are worth 30 of your final mark
• Are important for Mid-Term and Final Exams
  preparation
• Submission SASIT Assignment drop box 18 , TEL
  Bldg. third floor
• Late policy