question archive  Using your knowledge of TAL Distributors, determine the functional dependencies that exist in the following table

 Using your knowledge of TAL Distributors, determine the functional dependencies that exist in the following table

Subject:Computer SciencePrice:9.82 Bought3

 Using your knowledge of TAL Distributors, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form. ITEM (ITEM NUM, DESCRIPTION, ON HAND, CATEGORY, STOREHOUSE, PRICE, (ORDER NUM, ORDER DATE, CUSTOMER NUM, CUSTOMER NAME, NUM ORDERED, QUOTED PRICE) ) AL 5. Indicate the changes you need to make to the TAL Distributors database to support the fol- KING lowing additional requirement. Each storehouse has a manager who is identified by a man- ager number, a manager last name, and a manager first name.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

4. Functional Dependencies

ItemNum -> Description, on_Hand, StoreHouse, Price

Order_Num -> order_Date

customer_Num -> Customer_Name

item_Num, order_Num -> Num_ordered, Quoted_Price

 

Third Normal form Relational Schema

Item (itemNum, Description, on_Hand, Category, Storehouse, Price)

Customer (customer_Num, customer_Name)

Order (orderNum, order_Date, customer_Num, item_Num, Num_ordered, Quoted_Price)

 

 

5. 

Item (itemNum, Description, on_Hand, Category, StorehouseNum, Price)

Customer (customer_Num, customer_Name)

Order (orderNum, order_Date, customer_Num, item_Num, Num_ordered, Quoted_Price)

storeHouse (storeHouseNum, ManagerNum)

Managers (ManagerNumber, managerLastName, ManagerFirstName)

 

Step-by-step explanation

In the relational schemas, Primary keys are in bold letters while foreign keys are in italics.

 

In order to add the Storehouse and the Managers, we will introduce two tables. that is the storeHouse and the Managers table.

The storehouse table will have the storehouseNum as the Primary key and have a ManagerNum as the foreign key.

The managers table has the ManagerNumber, Manager first and last names.

The Item will include a foreign key called storeHouseNum which references the Store house Primary key.