n this project, you will use a Database Management System to create and manipulate a very small database system for bank Your task is to improve it to some extent and implement the design as well as some queries against it$.$ In this project, you will use $($Oracle$)$

Project Description: You need to develop a management information system to help users at the administration level of the bank easily viewing$/$tracking various information about branch, customer loans how many customer in bank and information about, account and employees

$($Requirements$)$: We need to store information about bank each bank describe by ban$\_$name,address and unique bank$\_$no$,$each bank has many branches each branch identifying by bank, each branch has name and location $.$each bank manage by one employee and each employees work for one bank $,$employee has SSN $,$name$($first$\_$name and last$\_$name$),$email,phones and salary $.$eah bank has many customer each customer identified by unique cust$\_$no$,$ cust$\_$name and phone $.$each customer has many account each account has ac$\_$no$,$ blanc $.$each customer can takes one loans $.$each loans has loan$\_$id$,$types and amounts

each employee have many dependent $.$ For each dependent, we keep track of their name, sex, birthdate.

Implementation requirement: Considering the following queries, first finalize the schema $($by adding required relations and$/$or changing the above relations$)$ and then implement your relations. Next, populate your relations with appropriate data. Make sure each table in the database has enough number of tuples so that each query gets a meaningful and reasonable size output. For this, you should store at least $3$bank $5$employees.,$5$customer,, $5$branch $,5$dependent $,5$lonas $,5$ type of loans

Finally, implement the following queries in SQL$.$

The queries are as follows.

$1-$ Display all information from bank

$2-$ For each bank find the count number of employee $.$

$3-$ Find the last$\_$name of employee how the third litter of last$\_$name is e

$4-$ For each bank find the bank$\_$no $,$maximum salary, first$\_$name for all employee who the maximum salary greeter than$5000$ sort the result in deciding order by maximum salary $.$

$5-$ Find the cust$\_$name for all customer how the cust$\_$name start by S$.$

$6-$ Find loan$\_$no and loan type

$7-$ Retrieve the ssn $,$ first$\_$name connected with last$\_$name by new label employee info and salary whose salary not in the range of $5000$ to $10000$

$8-$ Find the first$\_$name and bnck$\_$name for all employees.

$9-$ Find the ss$,$ email $,$ and salary for every employee how work in bank equal alrajhi

$10-$ Find the first$\_$name $,$ email and salary of all employees who the salary equal the maximum salary $.$

What you should hand in: You should print and submit a report that includes

$(1)$ The E$/$R model for your database design together with reasonable assumption$($s$)$ made,

$(2)$ List of all schemas and their attributes with appropriate data t e$.$ Also identify the primary key for each schema together with the relationship between different schemas.

$(3)$ The print out of tuples in each table, the SQL queries and the output of your queries against your database.