Answer the following base on the given picture: Identify what type of data each field is and explain your answer What are the anomalies present on the given data? Provide basic steps in solving those anomalies.

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
icon
Related questions
Question

Answer the following base on the given picture:

  1. Identify what type of data each field is and explain your answer
  2. What are the anomalies present on the given data? Provide basic steps in solving those anomalies.

 

DEPOSIT ILOAN_PR( DEPOSIT_ICOUNT_TRANSA/ AMOUNT MONTHS_MONTHS_COUNT_L(AMOUNT_AGE_MON TENURE_NMONTHS_CNT_LN_TLOAN_BAIAGE_MON TENURE_NLOAN_AN
1 8.853912
1 2.75455
2 97.17168
1 9.124448
1 8.853912
1 24.5942
41 614.8564
90 245.9426
41 1967.541
41 614.8564
1
8
602
41
4 590.2608
1
8
8
841
90
2 160.2804
1 97.17168
1 9.124448
2
11
11
482
41
899.6558
1
1 3.68913
9
9
445
41
1 607.4767
1
0 7.351565
2 0.991884
684
99
684
99
1 33.0792
1 8.484999
1 504.2549
90 614.8564
49 541.0736
96 614.8564
95 20000
1
8
625
90
2 541.0724
1 504.2549
1 33.0792
8 541.0724
3 541.0724
13
13
604
49
1
1 8.484999
689
96
2
1 14.4833
2 821.7738
21
21
1 820.79
749
95
13997
749
Transcribed Image Text:DEPOSIT ILOAN_PR( DEPOSIT_ICOUNT_TRANSA/ AMOUNT MONTHS_MONTHS_COUNT_L(AMOUNT_AGE_MON TENURE_NMONTHS_CNT_LN_TLOAN_BAIAGE_MON TENURE_NLOAN_AN 1 8.853912 1 2.75455 2 97.17168 1 9.124448 1 8.853912 1 24.5942 41 614.8564 90 245.9426 41 1967.541 41 614.8564 1 8 602 41 4 590.2608 1 8 8 841 90 2 160.2804 1 97.17168 1 9.124448 2 11 11 482 41 899.6558 1 1 3.68913 9 9 445 41 1 607.4767 1 0 7.351565 2 0.991884 684 99 684 99 1 33.0792 1 8.484999 1 504.2549 90 614.8564 49 541.0736 96 614.8564 95 20000 1 8 625 90 2 541.0724 1 504.2549 1 33.0792 8 541.0724 3 541.0724 13 13 604 49 1 1 8.484999 689 96 2 1 14.4833 2 821.7738 21 21 1 820.79 749 95 13997 749
Expert Solution
steps

Step by step

Solved in 5 steps with 5 images

Blurred answer
Knowledge Booster
Types of Security Models
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education