NORMALIZATION The table above displays snippet of the monthly loan application report send by all banking institutions to the Bank Negara. Based on this report, answer the following questions: 1. Identify the functional dependencies (primary, partial, and transitive if any) in the relation above based on the information given to you. Specify whether it is primary, partial, or transitive. 2. Perform normalization process to this relation based on the following steps; 1st Normal Form, 2nd Normal Form and finally the 3rd Normal Form. Your answers are the final relations or tables created after you have performed all three Normal Form. Please indicate the primary keys or/and foreign key(s) for all the relations. 3. Using your findings in Question 2, draw an ERD to reflect the properly decomposed normalized tables. Show all the relationships, attributes, primary key, foreign key, and multiplicities.
NORMALIZATION The table above displays snippet of the monthly loan application report send by all banking institutions to the Bank Negara. Based on this report, answer the following questions: 1. Identify the functional dependencies (primary, partial, and transitive if any) in the relation above based on the information given to you. Specify whether it is primary, partial, or transitive. 2. Perform normalization process to this relation based on the following steps; 1st Normal Form, 2nd Normal Form and finally the 3rd Normal Form. Your answers are the final relations or tables created after you have performed all three Normal Form. Please indicate the primary keys or/and foreign key(s) for all the relations. 3. Using your findings in Question 2, draw an ERD to reflect the properly decomposed normalized tables. Show all the relationships, attributes, primary key, foreign key, and multiplicities.
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
Related questions
Question
NORMALIZATION
The table above displays snippet of the monthly loan application report send by all banking institutions to the Bank Negara. Based on this report, answer the following questions:
1. Identify the functional dependencies (primary, partial, and transitive if any) in the relation above based on the information given to you. Specify whether it is primary, partial, or transitive.
2. Perform normalization process to this relation based on the following steps; 1st Normal Form, 2nd Normal Form and finally the 3rd Normal Form. Your answers are the final relations or tables created after you have performed all three Normal Form. Please indicate the primary keys or/and foreign key(s) for all the relations.
3. Using your findings in Question 2, draw an ERD to reflect the properly decomposed normalized tables. Show all the relationships, attributes, primary key, foreign key, and multiplicities.
Transcribed Image Text:ProductNo Type
Amount
|OfferNo
Date
ClientNo
ClientName BankNo
BankName
85000 FO01
12/9/2021|CO01
Yusuf
PO01
Car Loan
BO01
Maybank
120000 FO02
13/9/2021|CO02
Aishah
|Personal
PO02
50000
FO03
Loan
Ibrahim
|CO03
14/9/2021
BO02
Bank Islam
Housing
450000
PO03
Loan
800000 FO04
|CO04
Maryam
|CIMB
Bank
Car Loan
|Personal
67000 FO05
PO04
ВООЗ
15/9/2021 CO05
Fatimah
RHB Bank
PO05
Loan
30500 FO06
ВО4
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 3 images
Knowledge Booster
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
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education