{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This 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)
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
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

  • Fall '10
  • HarrisonMcKnight
  • advisor, Database normalization, Normal Form, Normalized relations, functional dependency principles

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern