solve it about bank muscat with details and ER$,$EER diagram?

Important Instructions:

The assignment is a group assignment $($Maximum $2)$

Develop your own case scenario based on the topic assigned to your group.

For the case scenario, you must draw the corresponding Entity$-$Relationship diagram $($ERD$).$

After designing the ERD, you must design the corresponding relational data model.

Normalize the relations that you have designed, up to third normal form.

Design the ERD using ERDPLUS or any other ER drawing tool.

You have to submit the following things:

$>$ Case Scenario based on the topic assigned to the group

$>$ ER diagram

$>$ EER diagram

$>$ Relational data model

$>$ Normalized relations $($up to $3NF)$

$>$ SQL Command $[$create table, insert data, update data, select data$]$

The Academic Integrity and Plagiarism Policy:

You should be ready to prove the authenticity of your work. If any form of plagiarism$/$reproduction of answers$/$work discovered, you will be awarded zero mark.

Late submission of the assignment:

Late submission of the assignment$/$project will lead to $10\%-$mark deduction per day from the total mark of the assignment$/$project$.$ Fridays & Saturdays are counted.

You are expected to cover the following outcomes

Explain data modeling$/$ conceptual design phase, types$/$levels of data models, and the concepts of Entity Relationship $($ER$).$

Analyze a case study and design a data model using ER diagram.

Extend your ER Diagram into EER diagram by including super type, sub types, participations and constraints

Illustrate relational data model and its components.

Modify an ER model into a relational database schema.

Apply normalization up to third normal form to improve the database design.

Apply SQL concept such as DML & DDL$.$

You are expected to practice the skills that are related to the following graduate attributes:

Scholastic rigor & practical competence: creative thinking, problem solving, analytical thinking, time management, dexterousness and knowledgeability.

Teamwork: collaboration, tolerance and flexibility, planning, organization and time management.

Lifelong learning: research skills, critical thinking, inquisitiveness, goal setting, commitment and adaptability.

Autonomy and Accountability: work independently, confidence, responsibility, transparency, reliability and authenticity.

Innovation: imagination, aspiration, problem$-$solving, solution$-$integration, visionary and perseverance.