The following exercises are based on the BlTs database 31hO 1. Using your knowle

Question

The following exercises are based on the BlTs database 31hO 1. Using your knowledge of BITS, determine the functional dependencies that exist in the following table. Alfter determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form: Tasks (TaskID, Description, Category, Price, (OrderNum, ntName, ConsltNum, LastName, FirstName, ScheduledDate, QuotedPrice)) tho fallouing tahle that concern invoicing (an application BITS is considering

Explanation / Answer

To convert to 3NF, we need to ensure that no non-key attribute is transitively dependent on the primary key.

Currently, in Tasks table, only the fields Taskid, Description, Category, Price are directly related to tasks. The fields related to ORDER(OrderDate, OrderNum, ConsltNum, ScheduledDate, QuotedPrice) and CLIENT(ClientNum, ClientName,LastName,FirstName) can be moved to separate tables, while the foreign keys(OrderNum,ClientNum) can be present in TASKS table

Currently, in Invoice table, only the fields InvoiceNum and Date are directly related to Invoice. The fields related to TASKS(TaskID, Description, Category, Price) and CLIENT(ClientNum, LastName,FirstName, Street, City, State, ZipCode) can be moved to separate tables, while the foreign keys(TaskID, ClientNum) can be present in INVOICE table

After converting to 3NF, the tables appear as below(underlined primary key)

TASKS(Taskid, Description, Category, Price, OrderNum, ClientNum)

ORDER(OrderNum, OrderDate, ConsltNum, ScheduledDate, QuotedPrice))

CLIENT(ClientNum, ClientName, LastName, FirstName, Street, City, State, ZipCode)

INVOICE(InvoiceNum, Date, TaskID, ClientNum)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.