Consider the Customer Order database of the ABC company, which keeps data for customers and their orders. A database of only one relation is designed, as shown below: ABC(customerNo, customerName, phone, streetAddr, city, state, postCode, orderNo, productNo, quantity, unitPrice, salesRep)

• A customer has a unique customer number (customerNo) and is also described by name, phone number, street address (streeAddr), city, state, and postCode.
• An order is identified by a unique order number (orderNo).
• A product has a unique product number (productNo) and has a unit price (unitPrice).
• A customer can place several orders and an order is made by only one customer.
• An order can include several products and each has some quantity, and a product can be on several orders.
• An order has one sales representative (salesRep) and one sales representative can be responsible for several orders.

Answer questions:

1. Give all likely FDs.

2. Give the candidate keys for the ABC relation. Explain your answer.

3. Give {CustomerNo}+ and {orderNo, salesRep}+ based on the FDs for Question 1).

Answer rating: 100% (QA)

1 Attributes customerNocustomerNamephonestreetAddrcit... View the full answer