Draw an E-R diagram for the case below
Document Sample


Draw an E-R diagram for the case below.
J&J is a toyshop located in Central which is maintained by ten staff there. Customers may
come to the shop making enquiries about toys information. There are mainly three types of
toys, infant toys, TV games and educational toys. Customers may order toys from the toyshop
for a variety of toys. The toys in the J&J are supplied by a number of suppliers. After a
Customer placing an order, he/she will receive an invoice with the toy(s).
Additional Information:
Customers can place as many orders as they wish.
Customers can make enquiries about toys sold in J&J.
Each order can contain any number of toys.
Each order results in one invoice.
A supplier may supply many different toys.
A single toy can be supplied by many suppliers.
Related docs
Get documents about "