Homework_02 - 4. What is logical and physical independence?...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Spring 2010: ISAM 5331.01 / ACCT 5333.01 Copyright © 2010 Richard Meyer. All rights reserved. This material may not be reproduced, displayed, modified or distributed without the express prior written permissions of the copyright holder. Homework Assignment 02 1. Define a relationship, and what three types of relationships exist? 2. Provide an example of each of the three types of relationships. 3. What is a relational diagram? Provide an example of a relational diagram.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4. What is logical and physical independence? 5. Provide an example of connectivity using Chen Notation and Crows Foot Notation. 6. What is the difference between a database and a table? 7. Why are entity integrity and referential integrity important in a database? 8. Define a primary key. 9. Define a foreign key. 10. Provide an example relational diagram detailing primary and foreign keys using two or more entities, and describe the relationships....
View Full Document

Ask a homework question - tutors are online