Tentative Schedule (Fall 2014)

Thursdays 1:00 - 3:50pm, Rm. 3-22, Rutherford South

September 4

• Introduction
• Readings: Chapter 1

September 11

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

September 18

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

September 25

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

October 2

• The relational model; Develop relational models from ERDs
  
• Readings: Chapters 4 & 17 (skip step 2.2)
• Assignment due: ER modeling

October 9

• Defining and querying relational databases with MS Access
• Readings:
  
• Chapter 18
• 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

October 16

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

October 23

• MS Access - ctd.; Manipulating database content using SQL
  
• Readings:
• Chapter 6
• Lab: MS Access queries and forms

October 30

• Manipulating database content using SQL - ctd.
• Readings:
• Learning SQL at W3 Schools - optional
• Assignment due: MS Access

November 6

• Manipulating database content using SQL - ctd.
• Readings:
• Chapter 7 (focus on 7.3 & 7.4; skim the rest)
• Help session on term project
• Assignment due: SQL (by 11pm on November 8)

November 13

• Understanding normalization
• Readings:
• Chapter 14
• Chapter 17 (focus on step 2.2)
• Chapter 15 - optional
• Assignment due: Term project Parts 1 & 2
  

November 20

• Understanding normalization - ctd.; Web and DBMSs
• Readings:
• Chapter 30
• Help session on term project
• Assignment due: Normalization (by 11pm on Nov. 21)

November 27

• XML and relational databases; Issues and trends
• Readings:
• Chapter 31
• 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
• Help session on term project

December 3

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