Question

PROJECT CODE 21-522 25-2D- 25-5A- 25-9T+ PROJECT MANAGER MANAGER PHONE- MANAGER ADDRESS+ PROJECT BID- HOLLY B. PARKER 904-338-3416 3334 Lee Rd, 16833460.00+ Gainesville, FL 37123 JANE D. GRANT 615-898-99092 218 Clark Blvd 12500000.00 Nashville, TN 36362- GEORGE F. DORTS+ 615-227-12452 124 River Dr., Franklin, 32512420.00- TN 291852 HOLLY B. PARKER 904-338-3416 3334 Lee Rd, 21563234.00- Gainesville, FL 37123 GEORGE F. DORTS 615-227-12452 124 River Dr., Franklin, 10314545.00- TN 291852 HOLLY B. PARKER 904-338-3416 3334 Lee Rd, 25559999.00- Gainesville, FL 37123 WILLIAM K. MOOR- 904-445-27192 216 Morton Rd., Stetson, 56850000.00+ FL 301552 27-4Q- 29-2D- 31-7P-

Imagine that the table is part of a huge spreadsheet with thousands or millions of rows of data. Explain as well as you can all of the problems caused by this format of data storage, and all of the advantages of using a DBMS to store and retrieve the same data instead of using a spreadsheet.

Answer 1

Advantages of using a DBMS to store and retrieve the same data instead of using a spreadsheet:

1. In DBMS user do not need to write procedures to manage the database, whereas if you use spreadsheet user has to write them.
2. If system crashes while inputting some data into file, the contents will be lost. However in database, DBMS has crash recovery mechanisms.
3. DBMS is more efficient in terms of storage and retrieval than File System.
4. Wen you want to access data from file, whole file has to be loaded into RAM. But in database only the data in which you are working will be loaded into RAM.
5. The database allows for certain variables to be set as the only possible entries. In file system we cannot restrict this.
6. Data duplicacy can be avoided in database.
7. Spreadsheets don't have data security which might result in data corruption.
8. Spreadsheets cannot offer multiple users to work on the different data in the same file, because once the first user opens the file it is locked to other users. But in database it is not the case. Multiple users can can affect multiple transactions.