DOC PREVIEW
Rose-Hulman CSSE 333 - The Relational Data Model and Relational Database Constraints

This preview shows page 1-2-3 out of 10 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 10 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 10 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 10 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 10 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

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

Rose-Hulman CSSE 333 - The Relational Data Model and Relational Database Constraints

Download The Relational Data Model and Relational Database Constraints
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view The Relational Data Model and Relational Database Constraints and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view The Relational Data Model and Relational Database Constraints 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?