Project #2 Description

In this project, you will design and implement a database for a Bank

Enterprise to reflect the following scenario. You will first design an ER/EER

schema diagram for this database application. Then, you will map the EER

schema into a relational database schema and implement it on

ORACLE/MySQL in Omega. Finally, you will load some data into your

database, and create some queries and update transactions.

The bank is organized into branches. Each branch is located in a particular

city and is identified by a unique name. The bank monitors the assets of

each branch,

Part 1 - You will first design ER/EER schema diagram based upon the above Bank

database requirements and create the schema diagram and documentation

report describing your design choices. As part of this assignment, you should

identify any missing or incomplete requirements, and explicitly state them in

your documentation. You should also explicitly state any assumptions you

made that were not part of the requirements listed above.