Database Requirements, EER Model, and Data Dictionary

Running head: DATABASE
Database
Name of the Student:
Name of the University:
Author Note

1DATABASE
Table of Contents
Part 1: Requirements........................................................................................................................2
Data Requirements.......................................................................................................................2
Transactions Requirements..........................................................................................................2
Business Rules.............................................................................................................................2
Part 2: EER Model with Data Dictionary........................................................................................3
EER Model..................................................................................................................................3
Data Dictionary............................................................................................................................3
Entities.....................................................................................................................................3
Relationship.............................................................................................................................5
Attributes.................................................................................................................................5
Bibliography..................................................................................................................................10

2DATABASE
Part 1: Requirements
Data Requirements
 The system should be able to store the details of the Items and the data related to it such
as the ingredients and the suppliers.
 The data regarding the employees and the bank details related to the employees should be
stored in the system.
 The customers and orders are required to be stored in the system.
Transactions Requirements
 The system should be able to generated yearly revenue details.
 The details of the stocks should be displayed by the system.
 The payroll details are also required to be stored in the system.
Business Rules
The system should be able to store all the item menu related data. Additionally stock report
should also be a feature of the system.
The customer details and there ordering details are to be recorded automatically in the system.
The employee details and payroll information should be described by the system effecintly.

3DATABASE
Part 2: EER Model with Data Dictionary
EER Model
Data Dictionary
Entities
Entity Name Description Aliases Occurrences
Bank The bank store all the
details of the
employees
The details of many
employees are stored
in the bank
Accounts The accounts field
stores the payment
details of the
employees
One employee would
have a single account.