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. a) CLASS(CourseNo, SectionNo) b) CLASS(CourseNo, SectionNo, Room) c) CLASS(CourseNo, SectionNo, Room, Capacity) [FD: Room —> Capacity] d) CLASS(CourseNo, SectionNo, CourseName, Room, Capacity) [FD:  CourseNo –> CourseName; FD: Room è Capacity] 2.  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 a)      Convert this table to a relation (named PART SUPPLIER) in first normal form.  Illustrate the relation with the sample data in the table b)    List the functional dependencies in PART SUPPLIER and identify a candidate key. c)     For the relation PART SUPPLIER, identify each of the following: an insert anomaly, a delete anomaly, and a modification anomaly. d)    Draw a relational schema for PART SUPPLIER and show the functional dependencies. e)     In what normal form is this relation? f)     Develop a set of 3NF relations from PART SUPPLIER. All of this is also attached!

Looking for solution of this Assignment?

WHY CHOOSE US?

We deliver quality original papers

Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay