SBE_8 - (circle one:) None 1NF 2NF 3NF Explanation: Skill...

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

View Full Document Right Arrow Icon
Skill Building Exercise #8 Part A. Identify and Explain Which Normal Form, using Functional Dependency Principles 1. CUSTOMER relation: Customer No. Customer Name Sales Region Region Sales 1073043 Jones West 670,000 1076443 Smith South 735,000 1034875 Allen East 723,400 1098744 Carpenter West 670,000 Using functional dependency principles, assess the normal form of CUSTOMER. (circle one:) None 1NF 2NF 3NF Explanation: 2. Using functional dependency principles, assess the normal form of STUDENT. STUDENT relation: STUDENT (Student ID , Student Name, Major, Advisor) [Assume that each major has exactly one advisor.] (circle one:) None 1NF 2NF 3NF Explanation: 3. Using functional dependency principles, assess the normal form of MOVIE. MOVIE relation: MOVIE(Movie ID , Copy No , Movie Name, Movie Type, Status)
Background image of page 1

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

View Full DocumentRight Arrow Icon
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: (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.

Page1 / 3

SBE_8 - (circle one:) None 1NF 2NF 3NF Explanation: Skill...

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