 |
Back to the Data Model.
Entities are shown in Bold to provide a start to the design of the Data Model.
The Area being Modelled is :-
Tracking Inventory for Restaurants
Question: Imagine you are designing a system for small restaurant.
The restaurant has had difficulty ensuring that it has enough of the right ingredients
for the most popular menu items.
Your task is to create a database system that tracks the menu items ordered
(including the dates and times of the orders), the price of the menu items, and a
primary ingredient required for each of those items, as well as its cost.
(Note: For the purposes of this assignment, each dish is associated with one primary
ingredient, and two or more dishes can be associated with the same ingredient.)
© DataBase Answers Ltd. 2012
|
|