Syllabus and Course Schedule

Fall 2017

Lecture and Labs

Lecture: MW 11am-12pm, 3106 Etcheverry Hall.
Lab: F2-3,3-4, 3107 Etcheverry Hall

Course Schedule

Week DateTopicDue
0 W 23-Aug Lec: Introduction, entrance Exam
F 25-Aug Lab 0: Set up Microsoft Access
1 M 28-Aug Lec: ER Modelling Team Requests
W 30-Aug Lec: EER Models DP Contact Report+DP Team Assignments Announced in Class
2-Sep Lab 1: Intro to Microsoft Access (MSA)
2 M 4-Sep (Academic Holiday)
W 6-Sep Lec: Formal Logic HW 1: ER Model
F 8-Sep Lab 2: MSA Tables Lab Quiz 1
3 M 11-Sep Lec: Contd. DP: Team DP Proposal
W 13-Sep Lec: Contd. HW 2:EER
F 15-Sep DP Review 1 (2pm-4pm) DP Review 1, Quiz 2
4 M 18-Sep Lec: Relational Model
W 20-Sep Lec: Contd. HW 3: Logic
F 22-Sep Lab 3: MSA Relationships
5 M 25-Sep Lec: EER to Relational Design Conversion DP Revised Team Design Project EER Diagrams
W 27-Sep Lec: Contd.
F 29-Sep Lab 4: MSA Forms and Reports Lab Quiz 3
6 M 2-Oct Lec: Relational Algebra and Queries HW 4: Conversion
W 4-Oct Lec: Contd.
W 6-Oct Lab 5: MSA Forms Plus
7 M 9-Oct Lec:Contd.
W 11-Oct Lec: Contd.
F 13-Oct DP Review 2 (2pm-4pm) DP Review2, Lab Quiz 4
8 M 16-Oct Lec: Structured Query Language HW 5: Relational Algebra
W 18-Oct Lec: Contd.
F 20-Oct Lab Extra:SQL+SQLite
9 M 23-Oct Lec: SQL
W 25-Oct Lec: Functional Dependency HW 6: SQL Queries
F 27-Oct Lab 6: MSA Queries-SQL Lab Quiz 5
10 M 30-Oct Lec: Mid-Term Review
W 1-Nov Mid-Term (in class) Mid-Term
F 3-Nov No Lab
11 M 6-Nov Midterm Review
W 8-Nov Lec:Functional Dependencies
F 10-Nov No Lab (Holiday)
12 M 13-Nov Lec: Contd. Due in class: DP Review 3 - Written
W 15-Nov Lec: Normalization
F 17-Nov Lab 7: Macros-Modules-Internet
13 M 20-Nov Lec: Normalization HW 7: Functional Dependencies
W 22-Nov (Thanksgiving)
F 24-Nov No Lab (Thanksgiving)
14 M 27-Nov Lec: Query Optimization
W 29-Nov Lec: Distributed Databases
F 1-Dec DP Final Presentations (2pm-4pm) DP Final Presentations, HW 8: Normalization
15 M 4-Dec Review Day
W 6-Dec Final Exam Review
16 T 12-Dec Final Exam (7pm-10pm) DP Written Report