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
This note was uploaded on 10/09/2010 for the course MIS 5339 taught by Professor Gercek,g during the Spring '10 term at UH Clear Lake.
- Spring '10