Homework_04 - Employment PK Department_ID PK Employee_ID...

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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:
Background image of page 2
Background image of page 3
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 Crows 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 Crows Foot Notation to diagram the 3NF:...
View Full Document

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 Right Arrow Icon
Ask a homework question - tutors are online