Rob & Coronell - Chapter 1 Flashcards
What is the difference between data and information?
Data: Raw facts that have not yet been processed to reveal their meaning
Information: The result of processing raw data to reveal its meaning.
What is knowledge?
The body of information and facts about a specific subject. Knowledge implies familiarity, awareness and understanding of information.
What are the 5 key points of data/information/knowledge?
- Data constitute the building blocks of information
- Information is produced by processing data
- Information is used to reveal the meaning of data
- Accurate, relevant, and timely information is the key to good decision making
- Good decision making is the key to organizational survival in a global environment
What is data management?
The discipline that focuses on the proper generation, storage, and retrieval of data.
–> It is a core activity for any business, government agency, service organization or charity.
What is a database system?
An organization of components that define and regulate the collection, storage, management, and use of data within a database environment
Of which 5 components is a database system comprised, according to a general management view?
- Hardware
- Software
- People
- Procedures
- Data
What does hardware refer to?
All of the system’s physical devices.
-> Think about computers, storage devices, network devices
Which 3 types of software are needed to make a database system function fully?
- Operating system software
- DBMS software
- Application programs and utility software
What does the operating system software do?
It manages all hardware components and makes it possible for all other software to run on the computers
What does the DBMS software do?
It manages the database within the database system”
-> Think about Microsoft SQL server, Oracle
What do application programs and utility software do?
They are used to access and manipulate data in the DBMS and to manage the computer environment in which data access and manipulation take place.
For example to make reports.
Which five types of users can be identified in a database system?
- System administrators
- Database administrators
- Database designers
- System analysts and programmers
- End-users
What does a system administrator do?
He oversees the database systems general operations
What does a database administrator do?
He manages the DBMS and ensures that the database is functioning properly
What does a database designer do?
He designs the database structure. -> The architects of the database