List the functional dependencies in PART SUPPLIER and identify a candidate key.

3rd Normal Form

  1. For each of the following relations, indicate the normal form for that relation.  If the relation is not in third normal form, decompose it into 3NF relations.  Functional dependencies (other than those implied by the primary key) are shown where appropriate.
  2. a) CLASS(CourseNo, SectionNo)

 

  1. b) CLASS(CourseNo, SectionNo, Room)

 

  1. c) CLASS(CourseNo, SectionNo, Room, Capacity)

 

[FD: Room —> Capacity]

 

  1. d) CLASS(CourseNo, SectionNo, CourseName, Room, Capacity)

 

[FD:  CourseNo –> CourseName; FD: Room è Capacity]

 

  1. The below table contains sample data for parts and for vendors who supply these parts.  In discussing these data with users, we find that part numbers (but not description) uniquely identify parts and vendor names uniquely identify vendors.

 

Link to view table mentioned above at http://i.imgur.com/wBlODnQ.png

 

 

  1. a)      Convert this table to a relation (named PART SUPPLIER) in first normal form.  Illustrate the relation with the sample data in the table

 

  1. b)    List the functional dependencies in PART SUPPLIER and identify a candidate key.

 

  1. c)     For the relation PART SUPPLIER, identify each of the following: an insert anomaly, a delete anomaly, and a modification anomaly.

 

  1. d)    Draw a relational schema for PART SUPPLIER and show the functional dependencies.

 

Order Now

Last Completed Projects

topic title academic level Writer delivered

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]