Model ER Consider the following information about the Bank database.
- Each bank has a unique name.
- Each bank can have many branches.
- Each branch has a number, name, address composed by number, street, city, and set of phones.
- Customer includes their name, set of address (city, zip code, country), set of phones, and National or Iqama number.
- Accounts have numbers, types (e.g. saving, checking) and balance. Other branches might use the same designation for accounts. So, to name an account uniquely, we need to give both the branch number to which this account belongs to and the account number.
- Not all bank customers must own accounts and a customer may have at most 5 accounts in the bank.
- An account must have only one customer.
- A customer may have many accounts in different branches.

Part 1: ER Model
Design and draw an ER diagram for the following collection of data. Use only the basic ER model here, i.e., entities relationships and attributes.
Start part one of designing the database by identifying the following.
- Entities: strong and weak; state the type for each entity. For each entity identify the identifiers.
- Attributes: simple or composite
- Associations: 1-1, 1-M, M-M. relations; for each relation identify its cardinality,
- Draw ERD. You can use CREATLY to design digitally the diagram.
- On Word file, put the complete version of ERD.

Part 2: Relational Model
- Convert your ER diagram to a relational schema.
- Underline all key attributes in your relations.
- Specify all functional dependencies for each relation. (Mapping)
-Normalize the database: Decompose the relations appropriately so that each relation in 3NF.
-Add on the Word file, a complete normalized database relational schema

Part 3: Implementation
Start the physical design of your database (implementation) using MS Access according to lab instructions.
You will create the database.
â?¢ Define the Built-in Relational Model Constraints which must include the following:
- Primary keys
- Referential integrity constraints
- Business rules
Note: Your final database must be in a valid state, i.e. no entity integrity or referential integrity violations.
- Populate it with data (meaningful real data).
- Each table must include at least 10 tuples.
- Add a list of all the data of the different tables in the Word file

Part 4: Queries: Design and implement 10 meaningful queries.
Examples of queries
1. List the branches' bank
2. For each branch, list the associated customers. Order them by National/Iqama number.
3. For each customer, list the total of the balances.
4. List VIP customers that shows customers having total balance greater than 2000000 SAR.
5. Report the total balances by branches. Order by city.
6. Add 2 other queries
The queries must be included in the Word file as:
- Query using SQL code
- Screenshot of the result table