Exercises


1:

Normalize the following schema into third normal form:

Orders(customerID, customerName, customerAddress, orderID, orderDate, itemID, itemName, itemQuantity)

2:

Try to design a schema that is in 3NF but not in BCNF.




MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net