Tentative Schedule (Fall 2017)

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

September 6

• Introduction
• Reading: Chapter 1 Introduction to Databases
  

September 13

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

September 20

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

September 27

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

October 4

• 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 11

• 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 18

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

October 25

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

November 1

• 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 8

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

November 15

• No class - Fall Term Reading Week

November 22

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

November 29

• 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
• XML Tutorial at w3schools.com
• PHP Tutorial at w3schools.com

December 6

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

• Assignment due: Term project