List and describe advantages of the database approach.
What will be an ideal response?
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.
You might also like to view...
The following SELECT statement:
SELECT ProductName, ProductPrice FROM tblInventory WHERE ProductName Like "pr*"; would list the ProductName and ProductPrice that ________. A) begins with the letters "pr", such as pretzel, prime rib, and prosciutto sorted in descending order B) begins with the letters "pr", such as pretzel, prime rib, and prosciutto C) begins with the letters "pr", such as pretzel, prime rib, and prosciutto sorted in ascending order D) contains the letters "pr", such as pretzel, prime rib, and prosciutto anywhere in the field
Project managers use planning software such as Project 2013 to prevent deviating from the scope of a project
Indicate whether the statement is true or false