Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | May 2017 |
Last Sign in: | 306 Weeks Ago |
Questions Answered: | 66690 |
Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Consider the following relations for an order-processing application database in ABC Inc.
ORDER (O#, Odate, Cust#, Total_amount)
ORDER-ITEM( O#,I#, Qty_ordered, Total_price, Discount%)
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, the Total_amount is the amount of the order. If we apply natural join on the relations ORDER-ITEM and ORDER in the above 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 assumptions, if you make any.)
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll