Hi I hope you can help me. I will rate the answer. Use MYSQL do it in a .sql format. Also please provide comments for each step. Thanks in advance! Create a Bank database. Create two tables which attributes are given as below: (a) Customer: customer id integer, name varchar, lastname varchar, registration date date (b) Branch: branch id integer, branch name varchar, cash hold float, foundation date date Create a Loan table that stores the loans acquired by the customers from the particular branch of the bank. Determine the attributes of the table. Justify your answer with comments. Choose primary and foreign keys depending on the relations in Bank database design. If there is no need for a foreign key explain why. Justify your answer with comments.
Hi I hope you can help me. I will rate the answer. Use MYSQL do it in a .sql format. Also please provide comments for each step. Thanks in advance!
Create a Bank
Create two tables which attributes are given as below:
(a) Customer: customer id integer, name varchar, lastname varchar,
registration date date
(b) Branch: branch id integer, branch name varchar, cash hold float,
foundation date date
Create a Loan table that stores the loans acquired by the customers from the particular branch of the bank. Determine the attributes
of the table. Justify your answer with comments.
Choose primary and foreign keys depending on the relations
in Bank database design. If there is no need for a foreign key explain why.
Justify your answer with comments.
Populate each table with at least 5 different records.
Show IDs of all customers who loaned from the second branch
of the Bank.
Add score attribute to Customer table. Add liability
attribute to Branch table.
Write a SQL command that automatically assigns all customers’ score depends on their registration date. Each year passed
from the registration date, the customer gains 10 point. For example, the
customer who is registered at ’2011-09-19’ owns 100 points.
((2021 − 2011) ∗ 10 = 100)
Write a SQL command that automatically assigns all branchs’
liability depends on the formula
liability = 100 ∗ (age of branch/cash hold)
Step by step
Solved in 2 steps
