Homework_04

# Homework_04 - Employment PK Department_ID PK Employee_ID...

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

Spring 2010: ISAM 5331.01 / ACCT 5333.01 Homework Assignment 04 Analyze and review the following table data: 1. Identify and list the entities from the above data: Entities: Departments, Employees, Jobs Bridge Entity: Department_Employee 2. Identify and list any primary and foreign keys: Table Departments: PK: Department_ID, Manager_ID Table Department_Employee: PK: Department_ID, Employee_ID, FK: Department_ID, Employee_ID Table Employees: PK: Employee_ID, FK: Job_ID Table Jobs: PK: Job_ID

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

View Full Document
Spring 2010: ISAM 5331.01 / ACCT 5333.01 3. Convert the table data above into First Normal Form. Use Crow’s Foot Notation to diagram the 1NF:
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Employment PK Department_ID PK Employee_ID Manager_ID Department_Name First_Name Last_Name Phone_Number Hire_Date Job_ID Job_Title Salary 4. Using the First Normal Form, convert to the Second Normal Form. Use Crow’s Foot Notation to diagram the 2NF: Spring 2010: ISAM 5331.01 / ACCT 5333.01 5. Using the Second Normal Form, convert to the Third Normal Form. Use Crow’s Foot Notation to diagram the 3NF:...
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.

### Page1 / 3

Homework_04 - Employment PK Department_ID PK Employee_ID...

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

View Full Document
Ask a homework question - tutors are online