What defines a transitive dependency in a database table?   A. One non-key attribute is functionally dependent on another. B. One non-key attribute is in first normal form. C. One key attribute is in first normal form. D. One key attribute is functionally dependent on another.

The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)   CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice)   When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols  s, P, etc., or the words’ PROJECT’, ‘RESTRICT’ etc. as you prefer.  You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition.   List the dates on which Homer Griffin made purchases. List the first and last names of customers who have bought “Back Scratcher” or “Hair Remover” List the first…

The following is the relation notation of a database table in 1NF ORDER(CustNum, CustFN, CustLN, OrderNum, OrderDate, ProdNum, ProdDesc, Qty, UnitPrice) The functional dependencies are given below: CustNum → CustFN, CustLN OrderNum - OrderDate, CustNum, CustFN, CustLN ProdNum → ProdDesc OrderNum, ProdNum -> UnitPrice, Qty Use the functional dependencies above to answer the following questions. Don't not make additional assumptions and functional dependencies. A. List all partial dependencies in the relation only (if any) using the dependency numbers. Don't write the dependencies in X->Y format, just indicate their numbers (which are listed on the left side, i.e., 1, 2, 3, 4). Indicate only the dependencies that you think are partial. B. Identify and show the 2NF. Show primary keys and foreign keys references. Use relational notation (show references). Write down all relations and their references below. C. List all transitive dependency in your answer to question b (if any)…

The dependency diagram indicates that authors are paid royalty for each book they write for a publisher.The amount of royalty can vary by author,by book ,and by edition of the book. a.Based on the dependency diagram,create a database whose tables are atleast in 2NF showing the dependency diagram for each table. b.Create a database whose tables are atleast in 3NF,showing the dependency diagram for each table.