List and describe advantages of the database approach.

Question

What will be an ideal response?

Answer 1

Advantages of the database approach include the following:•Reduced data redundancy: Most data items are stored in only one file, which greatly reduces duplicate data. •Improved data integrity: When users modify data in the database, they make changes to one file instead of multiple files. Thus, the database approach increases the data's integrity by reducing the possibility of introducing inconsistencies.•Shared data: The data in a database environment belongs to and is shared, usually over a network, by the entire organization. This data is independent of, or separate from, the programs that access the data. Organizations that use databases typically have security settings to define who can access, add, modify, and delete the data in a database.•Easier access: The database approach allows nontechnical users to access and maintain data, provided they have the necessary privileges. Many computer users also can develop smaller databases themselves, without professional assistance.•Reduced development time: It often is easier and faster to develop programs that use the database approach. Many DBMSs include several tools to assist in developing programs, which further reduces the development time.