Tentative Schedule (Fall 2015)

Wednesdays 1:00 - 3:50pm, Rm. 3-01, Rutherford South

September 2

• Introduction
• Readings: Chapter 1

September 9

• Database system development lifecycle; Database analysis
  
• Readings:
• Chapters 10 & 11
• Appendix B: Examples of user requirement specification - optional
  

September 16

• Entity-Relationship (ER) modeling
  
• Readings: Chapter 12 & 16

September 23

• Entity-Relationship (ER) modeling - ctd.
  
• Readings: Chapters 13
  

September 30

• The relational model; Develop relational models from ERDs
  
• Readings: Chapters 4 & 17
  
• Assignment due: ER modeling

October 7

• The relational model; Develop relational models from ERDs - ctd.
  
• Readings: Chapters 4 & 17

October 14

• Defining and querying relational databases with MS Access
• Readings:
  
• Chapter 18 (skim)
  
• Access lab manual on the Companion website for the text
• MS Access tutorial - tables & relationships (e.g. Richard Holowczak’s tutorial, 1 – 5)
• Lab: MS Access tables and relationships
• Assignment due: Relational models
  

October 21

• MS Access - ctd.
• Readings:
• Chapter 9 (of 5th edition)
  
• MS Access tutorial – queries, forms and reports (e.g. Richard Holowczak’s tutorial, 6-12)
• Lab: MS Access queries and forms
• Assignment due: Term project topic must be approved by today.

October 28

• Manipulating database content using SQL
  
• Readings:
• Chapter 6
• Assignment due: MS Access

November 4

• Manipulating database content using SQL - ctd.
• Readings:
• Learning SQL at W3 Schools - optional
• Chapter 7 - optional
  

November 11

• No class - Fall Term Reading Week
• Assignment due: SQL

November 18

• Understanding normalization
• Readings:
• Chapter 14
• Chapter 15 - optional
• Assignment due: Term project Part 1
  

November 25

• Understanding normalization - ctd.; Web and DBMSs
• Readings:
• Chapter 29
  

December 2

• XML and relational databases; Issues and trends
• Readings:
• Chapter 30
• Chapters 20 and 21
• Optional readings:
  
• Bourret, R. (2005). XML and Databases.
• Seligman, L. and Rosenthal, A. (2001). XML's impact on databases and data sharing. Computer, vol. 34, no. 6, pp. 59-67, June, 2001
• Tutorials on XML at w3schools.com
• Tutorials on PHP at w3schools.com

December 7

• Not class day - Last day of Fall term classes
• Assignment due: Term project Parts 2, 3 & 4