June 2006
Beginner
456 pages
10h 3m
English
After you add the tables to your database, you establish relationships between them. This helps to ensure the integrity of the data that users enter into the system. In this hour you’ll learn:
• What relationships are and why you would want to use them
• How to work with database diagrams
• How to work with table relationships
• How to designate table and column specifications
• How to add a relationship name and description
• How to determine when foreign key relationships constrain the data entered in a column
• How to designate INSERT and UPDATE specifications
Three types of relationships can exist between tables in a database: one-to-many, one-to-one, and many-to-many. ...
Read now
Unlock full access