Chapter 5Chapter 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 Midterm 1 Sep 13 Modeling Complex Relationships5.1,5.2,5.3Chapter 5Sep 18 Modeling Complex Relationships5.4,5.6,5.7Chapter 5Sep 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 Model6.8Chapter 6Chapter 7Functional Dependency7.2Oct 2 Revision Oct 4 Midterm 2 Oct 9SQL10.1,10.2,10.3Chapter 10Oct 11 SQL and RA11.1, 11.2Chapter 11Oct 16 Functional Dependency7.3Chapter 7Oct 18 Normal Forms8.1Chapter 8Oct 23 Normal Forms8.1,8.2Chapter 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