SCHEDULE.md

Schedule

Module I - Database Usage

Week 1 - 9/2/15

duration (mins)	usage	topic
70	Lecture	Introduction to this Course
10	Break
70	Lecture	Introduction to Databases within the context of Information Systems

Assignment(s):

• Questionnaire (given and due)
• Meetups (given)

Week 2 - 9/9/15

duration (mins)	usage	topic
70	Lecture	Database Management
10	Break
70	Lab	Database Management Software (DBMS), including in-class assignment

Assignment(s):

• Database Management Software (given and due)

Week 3 - 9/16/15

duration (mins)	usage	topic
70	Lecture	Single-table SQL
10	Break
70	Lecture	Single-table Aggregate SQL

Assignment(s):

• Group Project Midterm Pitch (given)
• Data Analysis (given)

Week 4 - 9/23/15

duration (mins)	usage	topic
65	Lecture	Multi-table SQL
5	Lecture	Multi-database SQL
10	Break
70	Lecture	Physical Database Design

Assignment(s):

• Data Analysis (due)
• Relational Data Analysis (given)

Week 5 - 9/30/15

duration (mins)	usage	topic
40	Lab	Data Analysis Exercises
40	Lab	Physical Design Exercises
10	Break
60	Support	Group Project Business Identification and Analysis

Assignment(s):

• Relational Data Analysis (due)

Suggested Group Project Progress:

• Business Operations and Process Descriptions
• Information System Requirements

Week 6 - 10/7/15

duration (mins)	usage	topic
150	Presentations	Midterm Project Pitches

Assignment(s):

• Group Project Midterm Pitch (due)
• Group Project Final Documentation (given)
• Group Project Final Implementation (given)
• Group Project Final Presentation (given)

Week 7 - 10/14/15

duration (mins)	usage	topic
150	Exam	Midterm Exam

Module II - Database Design

Week 8 - 10/21/15

duration (mins)	usage	topic
20	Announcements	Mid-semester Assignment and Exam Recap
20	Guest Lecture	GW New Venture Competition Resources
60	Lecture	Midterm Exam Review
30	Lecture	Conceptual Database Design
20	Lab	Entity and Relationship Identification Exercises

Assignment(s):

• Entity and Relationship Identification (given)

Week 9 - 10/28/15

duration (mins)	usage	topic
30	Lecture	Entity Relationship Diagramming
10	Break
70	Lecture	Logical Database Design
40	Lab	Form-based Database Design Exercise

Assignment(s):

• Entity and Relationship Identification (due)
• Entity Relationship Diagramming (given)

Week 10 - 11/4/15

duration (mins)	usage	topic
40	Lab	Form-based Database Design Exercise, continued
70	Lecture	Information Inputs and APIs
10	Break
20	Support	Assignment Support

Assignment(s):

• Entity Relationship Diagrams (due)
• Database Design (given)

Additional Practice:

• API-based Normalization Exercise (eligible for ungraded instructor feedback)
• API-based Database Design Exercise (eligible for ungraded instructor feedback)

Module III - Database Applications

Week 11 - 11/11/15

duration (mins)	usage	topic
10	Lecture	System Scope
10	Lecture	MS Access Applications
10	Lecture	Web Dashboards
70	Support	Group Project Database Design Inspection
10	Break
40	Lab	Tableau Dashboards

Assignments:

• Database Design (due)
• Data Visualization (given)

Suggested Group Project Progress:

• Completed ERD

Week 12 - 11/18/15

duration (mins)	usage	topic
40	Lab	Normalization Practice (for Final Exam)
20	Lab	Web Applications
10	Break
80	Support	Group Project Database Application Support (MS Access or Web)

Assignments:

• Data Visualization (due on Friday at midnight)
• Normalization Practice (given and optionally due)

Suggested Group Project Progress:

• Populated Database

Week 13 - 11/25/15

No Class - Thanksgiving

Suggested Group Project Progress:

• Progress towards Database Application Functionality

Week 14 - 12/2/15

duration (mins)	usage	topic
110	Lab	More Normalization Practice (for Final Exam)
10	Break
30	Support	Group Project Implementation

Assignments:

• Normalization Practice (deadline extended to midnight concluding Friday 12/4)

Suggested Group Project Progress:

• Deliverable
• Database Application Functionality

Week 15 - 12/9/15

duration (mins)	usage	topic
120-150	Presentations	Final Group Project Presentations

Assignment(s):

• Group Project Final Documentation (due)
• Group Project Final Implementation (due)
• Group Project Final Presentation (due)
• Meetups (due)

Finals Week - 12/16/15

The final exam will be held from 5:20pm-7:20pm in Duques 351.

duration (mins)	usage	topic
90-120	Exam	Final Exam