You still need the Orders table, I hope you did not eliminate it. Orders table has general info about the order - customerID, order date, ship date, paymentID. The OrderDetails would have a record for each book for each order - 5 books for OrderID 218 means 5 records. Each record would have the OrderID and BookID.