how DBMS solves the problems of the traditional file environment? explain
Answers
Explanation:
By using DBMS, it reduces the redundancy of the data (double/repeat data). Then, the data do not need to be updated one by one (each business functional area), but DBMS will ensure that the data has the same values (reduces inconsistency). ... So, this DBMS can solve the problems of traditional file environment
Answer:
Tutorial 6
1. Define a database and a database management system and describe how it solves the problems of a traditional file environment.
Database is defined as storage of collection of the data. The special software or program that is used to create and maintain a database and allowed business users to extract the data without making a separation of the file in their computer programs is called as database management system (DBMS). By using DBMS, it reduces the redundancy of the data (double/repeat data). Then, the data do not need to be updated one by one (each business functional area), but DBMS will ensure that the data has the same values (reduces inconsistency). When updating the software of DBMS, the data will not be dependent with the software which means do not require an update too, but the data will stand on their own. This DBMS also makes the users much easier in accessing the data, program development, and reducing maintenance cost because the system is equipped by ad hoc queries to perform in the database. So, this DBMS can solve the problems of traditional file environment.
2. Name and briefly describe the capabilities of a DBMS.
Data definition is the capability of DBMS to determine the structure content of the database and to create tables and describe the characteristics of the fields in each table.
Data dictionary is the manual or automatic tools to store the information about the meaning and characteristic of the data elements in database.
Data manipulation language is a language that used by users to extract the certain data and produce new resultant table based on the users’ requests (example: structured query language SQL).
3. Define business intelligence and explain how it is related to database technology.
Business intelligence is defined as the applications and technologies that help a user to analyze the data and make a better business decision. In this database technology, DBMS has capabilities such as data warehouse and data mining to lead a better performance of the users. Data warehouse is a database which is equipped with reporting and query tools so that can store the current and historical information from many operational system and help in management reporting and analyzing. Then, this DBMS also can do data mining which means that this database can find hidden pattern and relationship, define the rules to predict future behavior, and analyze the data to be used as a guide in decision making process.
4. By sharing a case study or article in powerpoint slides, explain how database systems/technology benefits a business organization.