Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

The strut on the utility pole supports the cable having a weight of 600 lb. Determine the absolute maximum bending stress in the strut if A, B, and C are assumed to be pinned. 2 in. -4 ft- -2 ft C01...

I need help with Section 4 part A please look at the case study Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student identification (student to complete) Please complete the...

Im having trouble with question 3 part A of the attached file. I know and understand her needs but im not sure if im filling out the table correctly ? Assignment Tier 1 Financial Planning...

Hi, can you help me with this question? I attached the file and other people's assignment. I hope these two can help you finish my assignment. Read the article ?Who Regulates Whom and How?? in the...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

ASSESSMENT TASKS - ASSIGNMENT 1 Page 2 ASSIGNMENT 1 Task Using the information contained in the Scenario below, please complete the following 6 tasks. You must complete each task for your submission...

Fact Find Initial Interview: Time Date Location Referred by: A. Personal Details Applicant 1 Applicant 2 Full Name of Applicant Full Name of Applicant Mr Mrs Miss OMS Dr Mr Mrs Miss OMs Dr Full Name...

CERTIFICATE IV IN FINANCE AND MORTGAGE BROKING - FN540820 Page 1 UNIT 3 - COMPLY WITH FINANCIAL SERVICES REGULATION AND INDUSTRY CODES OF PRACTICE Unit Code: FNSFMK515 This unit describes the skills...

ATTENTION TUTORS PLEASE HELP ME IN ANSWERING THIS ATTACHMENT WORKSHEET I NEED IT FOR CLASS IN ACCOUNTING THANK YOU HAVE THE ANSWERS IN YELLOW PLEASE SEE ATTACHMENT Question 1 of 15 1. A small...

I need a tutor help answer this question. Read the article ?Who Regulates Whom and How?? in the module resources and answer the following prompts in your initial post: Identify three policy problems...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

GBC Ltd. prepares a monthly cash budget. Here is income statement data for the next two months, Dec 2021 and Jan 2022: December, 2021 January, 2022 Sales $380,000 $400,000 Direct Materials Purchases...

Assume you are the IT manager for a large urban health care system. Lately you have been bombarded with requests for new projects, including system upgrades, support services, automated record...

The risk that basis will change unpredictably between time hedge is placed and time it is lifted called a . Default risk b . Market risk c . Basis risk d . Credit risk

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

=+4 Why is designing and implementing a global human resource information system so difficult?

=+2 Why have family-friendly and work-life balance programs become so important?

=+1 What makes managing employee health and safety programs around the world so difficult?