Tentative Schedule (Fall 2016)

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

September 7

• Introduction
• Reading: Chapter 1 Introduction to Databases
  

September 14

• The Relational Model
  
• Reading: Chapter 4 The Relational Model
  

September 21

• Manipulating database content using SQL 
• Readings:
  
• Chapter 6 SQL: Data Manipulation
  
• Chapter 7 SQL: Data Definition (optional)

September 28

• SQL - ctd.
• Reading: Learning SQL at W3 Schools - optional

October 5

• Defining and querying relational databases with MS Access
• Reading: MS Access tutorial - tables & relationships (e.g. Richard Holowczak’s tutorial, 1 – 5)
• Lab: MS Access tables and relationships
• Assignment due: SQL
  

October 12

• MS Access - ctd.
• Reading: MS Access tutorial – queries, forms and reports (e.g. Richard Holowczak’s tutorial, 6-12)
• Lab: MS Access queries and forms

October 19

• Database system development lifecycle; Database analysis
  
• Readings:
• Chapter 10 Database System Development Lifecycle
• Chapter 11 Database Analysis and the DreamHome Case Study
  
• Appendix B: Examples of user requirement specification (optional)
• Assignment due: MS Access

October 26

• Entity-Relationship Modeling
• Reading: Chapter 12 Entity-Relationship Modeling

November 2

• ER modeling - ctd.; Conceptual database design
  
• Readings:
  
• Chapter 13 Enhanced Entity-Relationship Modeling
• Chapter 16 Methodology - Conceptual database design
• Assignment due: Term project topic approval
  

November 9

• No class - Fall Term Reading Week

November 16

• Develop relational models from ERDs; Logical database design
  
• Reading: Chapter 17 Methodology - Logical database design for the Relational Model
  
• Assignment due: ER modeling

November 23

• Understanding normalization
• Reading: Chapter 14 Normalization
• Assignment due: Relational model 

November 30

• Web and DBMSs; XML and relational databases
• Optional readings:
  
• Chapter 29 Web Technology and DBMSs
  
• Chapter 30 Semistructured Data and XML
• 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

• Issues and trends
• Readings:
  
• Chapter 20 Security and Administration
• Chapter 21 Professional, Legal, and Ethical Issues in Data Management
  

• Assignment due: Term project