Module 3: Describe Relational Database Model

Module 3: Describe Relational Database Model

• 1.3.1 A Logical View of Data (pg. 69 - 72) [5 minutes]
• 1.3.2 Keys (pg. 72 - 76) [5 minutes]
• 1.3.3 Integrity Rules (pg. 76 - 77) [5 minutes]
• 1.3.4 Relational Algebra (pg. 78 - 87) [15 minutes]
• 1.3.5 The Data Dictionary and the System Catalog (pg. 87 - 89) [5 minutes]
• 1.3.6 Relationships within the Relational Database [10 minutes]
• 1.3.7 Data Redundancy Revisited (pg. 97 - 99) [5 minutes]
• 1.3.8 Indexes (pg. 99 - 100) [5 minutes]
• 1.3.9 Codd's Relational Database Rules (pg. 100 - 101) [5 minutes]