chapter3 part2

chapter3 part2 - Data Dictionary System Catalog Data...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 3 The Relational Database Model Part 2 BUS 173 Winter 2011 Dr. Hamouda 39 Data dictionary Provides detailed accounting of all tables found within the user/designer-created database Contains (at least) all the attribute names and characteristics for each table in the system Contains metadata: data about data System catalog Contains metadata Detailed system data dictionary that describes all objects within the database 40 A Sample Data Dictionary 41 Relationships within the Relational Database 42 The 1:M Relationship Relational database norm/ideal Found in any database environment Should be the norm in any relational database design 43 1:M Relationship Implementation
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
44 The 1:1 Relationship One entity related to only one other entity, and vice versa Sometimes means that entity components were not defined properly Could indicate that two entities actually belong in the same table Should be rare in any relational database design Certain conditions absolutely require their use
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

chapter3 part2 - Data Dictionary System Catalog Data...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online