Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The table below is the list of loan application data. Each application is handled by a specific banker. A client can apply for multiple types
The table below is the list of loan application data. Each application is handled by a specific banker. A client can apply for multiple types of loan from the bank. clientNo clientName stalo staf Name Joan Type loan. Amount 00011 Hilmi S0021 Ahmad Car Loan RM80000.00 00012 James S0021 Ahmad Personal Loan RM20000.00 Personal Loan RM15000.00 C0013 Jones S0021 Ahmad House Loan RM600000.00 00011 Hilmi S0033 Sue Ann House Loan RM360000.00 C0014 Amirah S0033 Sue Ann Car Loan RM76000.00 00013 Jones S0042 Joseph Car Loan RM60000.00 00011 Hilmi S0042 Joseph Personal Loan RM30000.00 Based on table above, analyse the FALSE statement. A. FD2: staffName staffNo B. FDI: clientNo, applicationDate staffNo, staffName, clientName, loanType, loanAmount O C. The table is in Unnormalized Form (UNF). O D. Deletion anomalies: deletion of staff "Ahmad" will delete the information of client "Hilmi" The table below is the list of loan application data. Each application is handled by a specific banker. A client can apply for multiple types of loan from the bank. clientNo clientName stalo staf Name Joan Type loan. Amount 00011 Hilmi S0021 Ahmad Car Loan RM80000.00 00012 James S0021 Ahmad Personal Loan RM20000.00 Personal Loan RM15000.00 C0013 Jones S0021 Ahmad House Loan RM600000.00 00011 Hilmi S0033 Sue Ann House Loan RM360000.00 C0014 Amirah S0033 Sue Ann Car Loan RM76000.00 00013 Jones S0042 Joseph Car Loan RM60000.00 00011 Hilmi S0042 Joseph Personal Loan RM30000.00 Based on table above, analyse the FALSE statement. A. FD2: staffName staffNo B. FDI: clientNo, applicationDate staffNo, staffName, clientName, loanType, loanAmount O C. The table is in Unnormalized Form (UNF). O D. Deletion anomalies: deletion of staff "Ahmad" will delete the information of client "Hilmi
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started