question archive 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.
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.