This preview shows pages 1–3. 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: (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
This note was uploaded on 11/17/2011 for the course ITM 311 taught by Professor Harrisonmcknight during the Fall '10 term at Michigan State University.
- Fall '10