This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: (circle one:) None 1NF 2NF 3NF Explanation: Skill Building Exercise #8 Part B. Converting ER Diagrams into Normalized Relations Convert the following ER Diagram into a set of 3NF normalized relations. Assume each entity type has only the attributes shown inside the boxes below. Your answer should use the notation: TABLE NAME (Primary Key , F or ei gn K ey , Other Attribute) [underline] [dashed line] [no underline] JOB Job# Job_Name ASSIGN-MENT Assn# Assn_Name JOB CLASS-IFICATION JClass# Description EMPLOYEE Emp# EmpName SKILL Skill# SkName Belongs to Provides Requires Is used by Possesses Is possessed by Has Works on Is for Supervises Is supervised by Has...
View Full Document
- Fall '10
- advisor, Database normalization, Normal Form, Normalized relations, functional dependency principles