Assume that each item has a different discount. The Total_price refers to one item, Odate is the date on which the order was placed, and the Total_amount is the amount of the order. If we apply a natural join on the relations Order-Item and Order in this database, what does the resulting relation schema look like? What will be its key? Show the FDs in this resulting relation. Is it in 2NF? Is it in 3NF? Why or why not? (State any assumptions you make.)
Consider the following relations for an order-processing application database at ABC, Inc.
ORDER (O#, Odate, Cust#, Total_amount)
ORDER-ITEM (O#, I#, Qty_ordered, Total_price, Discount%)
```
Given relations
Order(O#, Odate, Cust#, Total_amt)
Order_Item(O#, I#, Qty_ordered, Total_price, Discount%),
the schema of Order * Order_Item looks like
T1(O#,I#,Odate, Cust#, Total_amount, Qty_ordered, Total_price, Discount%)
and its key is O#,I#.
It has functional dependencies
O#I# . Qty_ordered
O#I# .Total_price
O#I# .Discount%
O# . Odate
O# .Cust#
O# .Total_amount
It is not in 2NF, as attributes Odate, Cut#, and Total_amount are only partially dependent on the primary key, O#I#
Nor is it in 3NF, as a 2NF is a requirement for 3NF.
```
You might also like to view...
A ________ reads and executes the control-language statements that define each job as well as helps prepare the system for the next job.
a) boundary register b) batch processor c) single-stream batch processor d) job stream processor
On an entity relationship diagram, you may need to add a(n) ________ if you have a N:M relationship
A) partial dependency B) join table C) natural key D) integrity constraint
Why might you want to print a presentation?
What will be an ideal response?
Determine the following factorial. 
A. 40,320 B. 362,880 C. 45 D. 9,000 E. no solution