Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

DB2 9 For Linux UNIX And Windows Advanced Database Administration Certification Certification Study Guide

Authors: Roger E. Sanders, Dwaine R Snow

1st Edition

1583470808, 978-1583470800

More Books

Students also viewed these Databases questions

Question

What is the best way to resolve contract disputes?

Answered: 1 week ago