Please create an SQL database corresponding to the scenario below.

Suppose there is a bank company Commonwealth that requires a relational database.

The daily duty is to serve their customers managing their saving bank accounts (withdraw, deposit, etc).

Additionally, the company Commonwealth also makes business for the home loan marketing (a customer may have a home loan account).

To set up a home loan account for a customer, there are several information to be collected and recorded:

(1) the customer needs to specify a property address;

(2) a bank staff needs to be assigned to process the home loan application;

(3) the property value should be assessed by using the average of the sold price of the properties located in the same suburb. Note: suppose there are sold properties in every suburbs;

(4) Each customer has their own home loan max limit that is calculated by his/her 10 years annual salary plus 0.65*property value plus customer savings (amount in his accounts): Note: property value is based on avg sold price of that suburb. Note: In general, the bank company used 10 years salary to estimate, e.g., if the customer Kevin has annual income $60,000, then his home loan limit cannot exceed $600,000. For the customers having multiple home loans, their total home load amount cannot exceed the customers home loan limit;

(5) a customer may have more than one home loan because multiple properties can be bought by one customer. Last but not least, your design should reflect the practical requirement as much as possible, i.e., meeting the maximum business rules. For example, some customers may have home loan accounts, but some ones may only have saving accounts. For a customer who need to set up a home loan account, it must create a saving account first. The average sold price for a suburb should be calculated on demand, not saved directly in the database.

(6) A customer may have more than one back account.

(7). A loan may be associated with more than one customer as joint loan

(8) In case of join loan, the database records the loan/joint customer to compute borrowing capacity and total loan of the property.

Schition Entity - Relationship diagram given constrainti 27 shows the visual representation of the entities and their behanan between the entities of the system. eg: Banking system as given account proces(withotraw ABC Accounts Company more than me deposity account customers Primary I key loan limit Honce loan saving Account multiple properties of customer creatorem A property Value more than one loan loan Happlication Joint loan Loan stafft process loan account The above ER diagram shows the functions customer and Bank and their bohouicur the constraints and attributes in the system with Cset of conditions) . The primary key in the is the custormer account, which ER diagram is the links all the other entities and functions. Relational database In the relational database, the relationship between each table is shown and also it shows the primary key which is the important attribute which contributies with the further oporations Primary key! ABC Bank Stoff-ID Blaff-name Customey leustomer account name process withdraw dep Home Loan autoner custance loanlyne loan property Suburbang account name value sold price properties of customer Teustoner customer account suburb sold price property valec name A eastomer Accounts Salary Accounttype Name