Question: Consider the COMMERCE-ROUTE relation shown below. Computer Model Mac air Laptop Mac air Laptop Mac air Laptop iMac Desktop iMac Desktop iMac Desktop iMac Desktop

Consider the COMMERCE-ROUTE relation shown below. Computer Model Mac air Laptop Mac air Laptop Mac air Laptop iMac Desktop iMac Desktop iMac Desktop iMac Desktop iMac Desktop Surface Pro Surface Pro Wholesaler Cost Wholesalers Cost Wholesalers Cost Wholesalers Cost Wholesalers Cost Wholesalers Cost Wholesalers BuxRight BuyRight BuyRight Buy Right Retail Store Comp. USA Microcenter Circuit City Comp USA Microcenter Circuit City Best Buy CostPlus. Best Buy Costplus Suppose the semantic rules (i.e., business rules) for this relation are as follows: . A wholesale company supplies computers to many retail stores. A wholesale company supplies many different computer models. Each retail store only sells computers supplied by a single wholesaler. a. What is (are) the superkey(s) candidate key(s) for the COMMERCE - ROUTE relation? Please show your answer using the following table. Candidate Key Superkey. Computer Model Wholesaler Retail Store (Computer Model, Wholesaler) (Computer Model, Retail Store) (Wholesaler, Retail Store) (Computer Model, Wholesaler, Retail Store) b. What is the primary key of the COMMERCE-ROUTE relation? c. What is the relational normal form of the COMMERCE-ROUTE relation? Please explain why it is not in the next highest normal form unless it is already in Boyce-Codd Normal Form
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
