Data Model

Society of the transportation
The Society S works currently with ten carriers and dessert three hundred destinations . when a customer place an order Mr. T., responsible of the expeditions is assigned to record it and to search for the carrier most capable to route this order . the choice of the carrier can make itself according two criteria: the speed of delivery ( in this case , it is the distance between the carrier and the customer that is taken in consideration). Or the cost of delivery ( in this case , the tariffs of every carrier enter in competition ). To note, that the distance considered here is calculated from city to an other city .
To win of the time in an activity in full development Mr. T. convinced his director of the interest of an information system permitting to manage quickly and efficiently the orders that the society , his carriers, and his customers honor

1- Build an Entity –Relationship Diagram model the best this application this should including and specifying cardinalities .
2- From the Diagram designed above , produce the corresponding relationship Schema Cheek that the obtained Schema is in the third normal form
ارجوا من الاخوة الزملاء أن يقترحوا علينا حلول لعمل الموديل Data Mode