PowerPoint PresentationChapter 5FIGURE 5.1 The attributes and tuples of a relation STUDENT.FIGURE 5.2 The relation STUDENT from Figure 5.1 with a different order of tuples.FIGURE 5.3 Two identical tuples when the order of attributes and values is not part of relation definition.FIGURE 5.4 The CAR relation, with two candidate keys: LicenseNumber and EngineSerialNumber.FIGURE 5.5 Schema diagram for the COMPANY relational database schema.FIGURE 5.6 One possible database state for the COMPANY database schema.FIGURE 5.7 Referential integrity contstraints displayed on the COMPANY relational database schema.FIGURE 5.8 The AIRLINE relational database schema.Copyright © 2004 Pearson Education, Inc.Copyright © 2004 Pearson Education, Inc.Chapter 5The Relational Data Model and Relational Database ConstraintsSlide 5-3Elmasri and Navathe, Fundamentals of Database Systems, Fourth EditionCopyright © 2004 Pearson Education, Inc. FIGURE 5.1The attributes and tuples of a relation STUDENT.Slide 5-4Elmasri and Navathe, Fundamentals of Database Systems, Fourth EditionCopyright © 2004 Pearson Education, Inc. FIGURE 5.2The relation STUDENT from Figure 5.1 with a different order of tuples.Slide 5-5Elmasri and Navathe, Fundamentals of Database Systems, Fourth EditionCopyright © 2004 Pearson Education, Inc. FIGURE 5.3Two identical tuples when the order of attributes and values is not part of relation definition.Slide 5-6Elmasri and Navathe, Fundamentals of Database Systems, Fourth EditionCopyright © 2004 Pearson Education, Inc. FIGURE 5.4The CAR relation, with two candidate keys: LicenseNumber and EngineSerialNumber.Slide 5-7Elmasri and Navathe, Fundamentals of Database Systems, Fourth EditionCopyright © 2004 Pearson Education, Inc. FIGURE 5.5Schema diagram for the COMPANY relational database schema.Slide 5-8Elmasri and Navathe, Fundamentals of Database Systems, Fourth EditionCopyright © 2004 Pearson Education, Inc. FIGURE 5.6One possible database state for the COMPANY database schema.Slide 5-9Elmasri and Navathe, Fundamentals of Database Systems, Fourth EditionCopyright © 2004 Pearson Education, Inc. FIGURE 5.7Referential integrity contstraints displayed on the COMPANY relational database schema.Slide 5-10Elmasri and Navathe, Fundamentals of Database Systems, Fourth EditionCopyright © 2004 Pearson Education, Inc. FIGURE 5.8The AIRLINE relational database
View Full Document