CIS 4301 (Information & Database Systems I)

Below you will find the "expected" class schedule. Depending on our pace in class there may be some shifts throughout the semester.

Week 1 Chapter 1 - 2.2 Overview of DBMS and relational data model.
Week 2 Chapter 2.2 - 2.4 Relational algebra, basic SQL.
Week 3 Chapter 2.4 - 3.2 Labor day (Monday) Conference trip (Wednesday) Constraints, functional dependencies.
Week 4 Chapter 3.3 Anomalies, BCNF.
Week 5 Chapter 3.4 Decomposition.
Week 6 Chapter 3.4 Decomposition continued.
Week 7 Chapter 3.5 Review and Test 1, 3NF. Homecoming (Friday)
Week 8 Chapter 3.6 Multivalued dependency, 4NF.
Week 9 Chapter 4.1-4.6 E/R Model, design principles, constraints
Week 10 Chapter 4.1-4.6 weak entity sets, E/R to Relational model.
Week 11 Chapter 6.1 - 6.3 review and Test 2, SQL.
Week 12 Chapter 6.4 SQL Veterans day (Friday)
Week 13 Chapter 6.5 - 6.6 SQL modifications, transactions.
Week 14 Chapter 7 Constraints and triggers, Bag model Thanksgiving (Wednesday + Friday)
Week 15 Chapter 5.1 - 5.3 Extended relational algebra, Datalog. Review and Test 3
Week 16 Chapter 5.4 review & wrap up.

Tamer Kahveci