This chapter is from the book
Normalize the following schema into third normal form:
Orders(customerID, customerName, customerAddress, orderID, orderDate, itemID, itemName, itemQuantity)
Try to design a schema that is in 3NF but not in BCNF.