Hey please Use Mysql and do it in .sql format. Provide comments for each part. Thanks in advance QUESTIONS1. Create BANK database.2.Create two table which attributes are given as below:(a) CUSTOMER: customer id integer, name varchar, lastname varchar,registrationdate date(b) BRANCH: branch id integer, branch name varchar, cash hold float,foundation_date date3.Create LOAN table that stores the loans acquired by the cus-tomers from the particular branch of the bank. Determine the attributesof the table. Justify your answer with comments.4.Choose primary and foreign keys depending on the relationsin BANK database design. If there is no need for foreign key explain why.Justify your answer with comments.5.Populate each table with at least 5 different record.6.Show IDs of all customers who loaned from the second branchof the BANK.7.Add score attribute to CUSTOMER table. Add liabilityattribute to BRANCH table.8.Write a SQL command that automatically assigns all cus-tomers' score depends on their registration_date. Each year passedfrom the registration date, the customer gains 10 point. For example, thecustomer who is registered at '2011-09-19' owns 100 points.((2021 – 2011) 10 = 100)9.Write a SQL command that automatically assigns all branchs'liability depends on the formulaage of branchcash holdliability = 100 *Note: Ensure that your programs are fully documented, using com-ments.

Given :- 1. Create BANK database.2.Create two table which attributes are given as below: (a)…

1. Create BANK database. Create two table 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 3. Create LOAN table that stores the loans acquired by the cus- tomers from the particular branch of the bank. Determine the attributes of the table. Justify your answer with comments. 2.

1. Create BANK database. Create two table 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 3. Create LOAN table that stores the loans acquired by the cus- tomers from the particular branch of the bank. Determine the attributes of the table. Justify your answer with comments. 2.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

USING SQL QUERY, Based on the following table, please display the staff and their corresponding manager in the same store. Please display staff’s full name in one column, manager’s full name in another column, and store_id.
Need help writing SQL queries for sample data base
Please provide a correct, clear answer for this SQL question 11)
in SQL Code: Explain the difference between number and binary integer and how it is used? Please provide a code example
Using SQL: List the title_name and book type of books that have the lowest royalty rate.
When would you use embedded SQL instead of SQL or a general-purpose programming language?
Create the SQL code that will calculate the total number of hours worked and the total amount of money charged by all employees.
List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) Order the output by category. From MT SQL 10th Edition
How would you retrieve data from SQL lite table?
What are the eight base data types in SQL and provide an example of when you will use each?
Select four SQL datatypes. Explain what they are and when you would use them.
7. List the shipping city and state for the order that had the longest shipping delay. SQL commands