Class notes

Notes for the newest edition of the textbook: Elmasri, Navathe: Fundamentals of Database Systems, 5th ed, Addison Wesley are on Joshua\cscommon in the CS460 folder.

Additional notes:

Unit 1 -Databases and Database Users

Unit 2 - Database Systems Concepts and Architecture

Unit 3 - Data Modeling Using E-R Model

Unit 4 - Enhanced E-R Model EER

Unit 5 - UML versus EER Modeling

Unit6 - Conversion E-R and EER into Relations

Unit 7 - Relational Data Model, Relational Constraints and Relational Algebra Operators (Inherited from Set Theory)

Unit 8 Relational algebra Operations

Unit 10 - SQL 3

Unit 11 - SQL 3 Part two

Unit 12 -SQL 3 Part three

Unit 13 - SQL 3 Part four

Unit 14 - Tuple Relational Calculus

Unit 15 - Functional Dependencies and Normalization