Database Managment The following report contains sample data for parts and for v
ID: 673040 • Letter: D
Question
Database Managment
The following report contains sample data for parts and for vendors who supply the parts. Given: part numbers (but not descriptions) uniquely identify parts, and vendor names uniquely identify vendors.
Part Number
Description
Vendor Name
City
Unit Cost
1357
Light bulb
General Electric
Austin
5.85
Sylvania
Wellsboro
4.95
2468
Wall switch
General Electric
Austin
7.95
Leviton
Phoenix
8.50
Sylvania
Wellsboro
7.50
1.Convert the report to a table (relation) named PART_SUPPLIER in first normal form. Show all the data, and indicate the primary key.
2. Draw a relational schema and show the functional dependencies. Label the dependencies (partial or transitive), and underline the primary key.
3. In what normal form is this relationship AT THIS POINT?
4. Develop a set of 3rd NF relations from PART_SUPPLIER. Show as a relational schema.
Part Number
Description
Vendor Name
City
Unit Cost
1357
Light bulb
General Electric
Austin
5.85
Sylvania
Wellsboro
4.95
2468
Wall switch
General Electric
Austin
7.95
Leviton
Phoenix
8.50
Sylvania
Wellsboro
7.50
Explanation / Answer
Parts(PartNumber,Description,UnitCost) PartVendor(PartVendorId,partNumber,vendorName,City) Parts table Part Number Description Unit Cost 1357 Light bulb 5.85 4.95 2468 Wall switch 7.95 8.5 7.5 PartsVendor PartVendorID Part Number Vendor Name City 1 1357 General Electric Austin 2 1357 Sylvania Wellsboro 3 2468 General Electric Austin 4 2468 Leviton Phoenix 5 2468 Sylvania Wellsboro
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.