A  written scenario of at least a page and a half describing a hamburguer restaurant that you we plan to model and, why that is an important area to work in. Your database should be designed to answer the questions or aid in decisions. So, within your scenario, list at least 8 questions your database is designed to answer.


A data/information dictionary describing each entity you would like to maintain information about. A short definition is required.
A conceptual model that shows the entities and their relations together with their most important features. E.g. for a Person entity, the most important features might be their identifier, gender, date of birth, address. . .
The conceptual model may take the form of an ER diagram (using the notation in your Murach text). ( Also see the online ASU text ( Information Modeling and Relational Databases 2nd edition 2008).
A set of relational tables: From the ER, you will need to map to a set of relational tables. (There must be a minimum of 6 tables - could be more, illustrating the capabilities and features listed below).
Given the relational tables, various SQL commands must be illustrated. (such a list is given below).
 

The following DMLs must be exercised ( these ought to be a consequence of the questions your database is designed to answer).

Joins: inner and outer
Group By
Having
Aggregations (Sum, Max)
SQL Selects illustrating alias and computation
Construct ( and label as such) a table that shows which table(s) illustrate each of the DMLs above.
A minimum set of DataTypes to be included

Timestamp
Decimal
Integer
Varchar
Construct a table (and label as such) that shows one entity you used for each data type.
Minimum Constraints to be illustrated

Binary relation

Ternary relation

Uniqueness, mandatory, and value constraints on all appropriate entities.

Subtype e.g. (Employee: HourlyEmployee, SalariedEmployee)