A written scenario of at least a page and a half describing a hamburguer restaurant that you
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Related Book For
Systems Analysis and Design
ISBN: 978-1305494602
11th Edition
Authors: Scott Tilley, Harry J. Rosenblatt
Posted Date: