[piston]

Hi if anyone can help that would be great, This is the scenario

A University bookshop deals with bulk order from uni for course textbooks, also deals with orders from customers and back orders for popular books. The way I have it now is

Uni Order
BackOrder
Cust Ordrer

These 3 are related to a bookshop orderline entity the relationship is, orderline may contain these entities, is using 3 order tables correct in this situation?

Thanks

[Thrasymachus]

here the entities I see...

customer
book
order

you can have types of orders and types of customers and types of books but that those things are just attributes of these 3 entities.

3 order tables is not the correct solution as I see it. Good luck with school this semester.