استفسار

Case 2 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 d rivers 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