Copyright 2004 Pearson Education Inc Chapter 5 The Relational Data Model and Relational Database Constraints Copyright 2004 Pearson Education Inc FIGURE 5 1 The attributes and tuples of a relation STUDENT Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 5 3 FIGURE 5 2 The relation STUDENT from Figure 5 1 with a different order of tuples Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 5 4 FIGURE 5 3 Two identical tuples when the order of attributes and values is not part of relation definition Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 5 5 FIGURE 5 4 The CAR relation with two candidate keys LicenseNumber and EngineSerialNumber Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 5 6 FIGURE 5 5 Schema diagram for the COMPANY relational database schema Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 5 7 FIGURE 5 6 One possible database state for the COMPANY database schema Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 5 8 FIGURE 5 7 Referential integrity contstraints displayed on the COMPANY relational database schema Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 5 9 FIGURE 5 8 The AIRLINE relational database schema Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 5 10
View Full Document
Unlocking...