Course Schedule
| Week | Lecture | Textbook | Tutorial | Project Deliverables | |||
| 1 | Introduction | Ch 1 & 2 | Lab0 - C# Introductory lab | ||||
| 2 | Data Models (ER) | Ch 2 (cont.) / Ch 7 (7.1 - 7.8) | Sheet 01 | Lab1 - DB Introductory lab | |||
| 3 | ER Data Model | Ch 7 (cont.) | Sheet 02 | Lab2 - Introduction to SQL Server 2014 | Project Proposal | ||
| 4 | Relational DB Design | Ch 3 | Sheets 03 | (Lab Practice#1) | Porposal Feedback by mail | ||
| 5 | Mapping ER to Rel | Ch 8 (9) - sec 8.1 & practice on Ch 3,7,8(9) | Sheet 04 | Lab4 - Accessing DB from C# App little requirement on Lab | ER Diagram | ||
| 6 | SQL 1 | Ch 4 | sheet 05 | Lab5 - Accessing DB from C# App - part2 little requirement on Lab | |||
| 7 | SQL 2 | Ch 5 | sheet 06 + Quiz | ER feedback & Lab5 Req Evaluation | Schema | ||
| 8 | Midterm | Office Hours | |||||
| 9 | Functional Dependency | Ch 14(15) | Sheet 07 | Schema feedback | |||
| 10 | Algebra | Ch 6 | Sheet 08 | Lab6 - StoredProcedures & Crystal Reports | |||
| 11 | optimization | Ch 19 | Lab practice #2 | ||||
| 12 | Sheet 09 & 10 | ||||||
| 13 | QUIZ | Project Support | |||||
| 14 | Project Delivery | Project Delivery | Project Delivery | ||||
Last modified: Sunday, 22 September 2019, 12:41 AM