L?rebok
Ramez Elmasri and Shamkant B. Navathe
Fundamentals of Database Systems
Global Edition, 7th Edition (2016)
Pearson Education, ISBN 9781292097619
Pensum
Pensum er materialet fra forelesningene samt f?lgende kapitler fra l?reboka:
(Mer n?yaktig angivelse av hvilke deler under de enkelte kapitlene som inng?r, fremg?r av undervisningsplanen)
Kap. 1 Databases and Database Users
Kap. 3 Data Modeling Using the Entity-Relationship (ER) Model
Kap. 5 The Relational Data Model and Relational Database Constraints
Kap. 6 Basic SQL
Kap. 7 More SQL: Complex Queries, Triggers, Views, and Schema Modification
Kap. 8 The Relational Algebra and Relational Calculus
Kap. 9 Relational Database Design by ER- and EER-to-Relational Mapping
Kap. 14 Basics of Functional Dependencies and Normalization for Relational Databases
Kap. 15 Relational Database Design Algorithms and Further Dependencies
Kap. 30 Database Security