Chapter 5CS 157ACourse Schedule Aug 23 Introduction And Overview- Key concepts and terminologyChapter 1Aug 28Database System, Data Modeling Foundation Concepts A.1,A.2Chapter 1, 2Appendix AAug 30 ER-diagrams,- Capturing entities, attributes and identifiers- Describing relationships: one-to-one, one-to-many, many-to-many- Optional and mandatory relationships- Resolving many-to-many relationships for implementation3.1Chapter 2Sep 4 ER-Modeling- Guidelines for a well-formed E-R diagram3.2Chapter 3Sep 6 EER Nodeling4.1,4.2Chapter 4Sep 11 Modeling Complex Relationships5.1,5.2,5.3 Chapter 5Sep 13 Modeling Complex Relationships5.4,5.6,5.7Chapter 5Sep 18 Midterm 1Sep 20 Relational Data Model6.1,6.2,6.3, 6.7Chapter 6Sep 25 Relational Data Model6.4, 6.5, 6.6Chapter 6Sep 27 Relational Data Model Chapter 6Chapter 76.8Functional Dependency7.2Oct 2SQL10.1,10.2,10.3 Chapter 10Oct 4 SQL and RA11.1, 11.2Chapter 11 Oct 9 Functional Dependency7.3Chapter 7Oct 11 Midterm 2Oct 16 Normal Forms8.1Chapter 8Oct 18 Normal Forms8.1,8.2Chapter 8Oct 23 Normal Forms8.3,8.4,8.9Chapter 8Oct 25 Normal Forms8.3,8.4,8.9Chapter 8Oct 30 Higher NF9.1,9.2,9.3Chapter 9Nov 1 Higher Normal Form Chapter 9Nov 6Data Mining & Data WarehouseNov 8Data Mining & Data WarehouseNov 13 Data Mining & Data WarehouseNov 15Data Mining & Data WarehouseNov 20 Data Mining & Data WarehouseNov27Midterm 3Nov 29 Data Mining & Data WarehouseDec 4 RevisionDec 6 RevisionDec18 Final Exam: Section 37:15 - 9:30
View Full Document