Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2) Peter encounters issues in his daily work when using a tab-delimited text file to manipulate data. There are several advantages of using DBMS which

image text in transcribed

2) Peter encounters issues in his daily work when using a tab-delimited text file to manipulate data. There are several advantages of using DBMS which can resolve Peter's issues. Please kindly fill in the table below; map the DBMS advantages that can solve Peter's corresponding issues, and describe how the situation could be improved. Issues 1 Update the balance of a bank account in which the bank account is already closed. 2 The bank account must be sorted by company name in ascending order. One company may have several accounts. When a company changes its name, Peter needs to manipulate the files line by line to reorder the account list. 3 Peter may copy the account file in a USB drive and take it home to do his work, and then copy it back to the USB drive and bring it to the office the next morning. Sometimes, this operation may mess up and overwrite the file with old data. As mentioned before Peter may use a USB drive. When the USB drive is corrupted, Peter needs to rework it again. + 5 After preparing the list, he needs to send it to the account department and the account department may adjust the account balance. While at the same time his boss may update the account list and Peter needs to resend it to the account department again. Nearly 10% of Peter's workload is to send/resend this account list across several parties. Peter sends the file by email as an attachment. While his boss is so careless that he may directly forward the whole account list to all customers, and all the customers may then know other companies' sales amounts. 4 6 How the situation could be improved Issues DBMS Advantages 12 22 32 4 ( 5 62

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

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions