This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Spring 2010: ISAM 5331.01 / ACCT 5333.01 Homework Assignment 02 1. Define a relationship, and what three types of relationships exist?- Relationships are associations among entities.- There are 3 types of relationship: One-to-one One-to-many Many-to-many 2. Provide an example of each of the three types of relationships.- One-to-one relationship: Husband Wife- One-to-many relationship: Student takes classes- Many-to-many relationship: Customers and products 3. What is a relational diagram? Provide an example of a relational diagram.- Relational diagram is the diagram to describe the relationship between entities.- Entity relationship diagram is an example of relational diagram. 4. What is logical and physical independence?- Data independence has two types: physical Independence and logical Independence. With knowledge about the three-scheme architecture the term data independence can be explained as follows: Each...
View Full Document
- Spring '10