Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter13: Views
Section: Chapter Questions
Problem 5MC
See similar textbooks
icon
Related questions
Question
Hey please Use Mysql and do it in .sql format. Provide comments for each part. Thanks in advance
QUESTIONS 1. 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 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. 4. Choose primary and foreign keys depending on the relations in 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 branch of the BANK. 7. Add score attribute to CUSTOMER table. Add liability attribute to BRANCH table. 8. Write a SQL command that automatically assigns all cus- tomers' 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) 9. Write a SQL command that automatically assigns all branchs' liability depends on the formula age of branch cash hold liability = 100 * Note: Ensure that your programs are fully documented, using com- ments.
Transcribed Image Text:QUESTIONS 1. 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 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. 4. Choose primary and foreign keys depending on the relations in 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 branch of the BANK. 7. Add score attribute to CUSTOMER table. Add liability attribute to BRANCH table. 8. Write a SQL command that automatically assigns all cus- tomers' 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) 9. Write a SQL command that automatically assigns all branchs' liability depends on the formula age of branch cash hold liability = 100 * Note: Ensure that your programs are fully documented, using com- ments.
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Database Functions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS