Discuss the advantages and disadvantages of the DBMS approach.
What will be an ideal response?
?Because a DBMS can pull data out of more than one table at a time (compared with a file management system that can only work with one table at a time), there is a very low level of redundancy in the tables in a DBMS database. In fact, often only a single field (the primary key) appears in more than one file. This low level of redundancy has several advantages. For instance, a DBMS database typically has a faster response time and lower storage requirements than a file management system, and it is easier to secure. In addition, data accuracy is increased because updates (such as an address change for a customer) are only made to a single table, cutting down on the possibility of data errors and inconsistencies that can occur when the same update has to be made manually to multiple tables.One of the most significant disadvantages of the DBMS approach is increased vulnerability. Because the data in the database is highly integrated, the potential for data loss (for example, if records or tables are accidentally deleted, the system fails, or the database is breached) is much greater.
You might also like to view...
Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.
Answer the following statement true (T) or false (F)
Hypertext transfer protocol (HTTP) only allows one-way communication from the server to the client (Web browser).
Answer the following statement true (T) or false (F)
You can modify the effects of a filter by controlling the brightness and contrast of the layer.
Answer the following statement true (T) or false (F)
You can suppress error messages in PHP using the _________________________ (@).
Fill in the blank(s) with the appropriate word(s).