Draw an E-R diagram for the case below

Document Sample
scope of work template
							 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