Database Answers Red Thread River House Book Cover

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Tracking Inventory for Restaurants   

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
About Us Contact Us