Coca-Cola Company Delivery System Database A coca-cola company wishes to maintai

Question

Coca-Cola Company Delivery System Database   

A coca-cola company wishes to maintain a database of its delivery operations over the current year. The company has a number of outlets, with each outlet having one manager. A manager manages only one outlet, although some outlets have no manager for some periods. Every working day, each of a number of Lorries make a number of deliveries to different outlets in its daily run and an outlet gets many deliveries in the year. A lorry may be driven by different drivers on different days with some drivers driving many Lorries over the year. Outlet details include Outlet_Name, Number of tables, and Address. Manager details include manager number, manager name, and salary. Delivery details include delivery number (unique only within a delivery), delivery date, number of miles traveled. Lorry details include lorry number, make, model and date driver drives lorry. Driver details include driver number, driver name and salary.

Design and draw an ER diagram that best captures the information of the "Coca-Cola Company Delivery System" Database   

Map the ERD model to a relational model. Show all Primary keys and Foreign Keys.

Explanation / Answer

mabye i have to see the Q

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.