Rob & Coronell - Chapter 1 Flashcards

1
Q

What is the difference between data and information?

A

Data: Raw facts that have not yet been processed to reveal their meaning

Information: The result of processing raw data to reveal its meaning.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is knowledge?

A

The body of information and facts about a specific subject. Knowledge implies familiarity, awareness and understanding of information.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the 5 key points of data/information/knowledge?

A
  • 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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is data management?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is a database system?

A

An organization of components that define and regulate the collection, storage, management, and use of data within a database environment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Of which 5 components is a database system comprised, according to a general management view?

A
  1. Hardware
  2. Software
  3. People
  4. Procedures
  5. Data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What does hardware refer to?

A

All of the system’s physical devices.

-> Think about computers, storage devices, network devices

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Which 3 types of software are needed to make a database system function fully?

A
  1. Operating system software
  2. DBMS software
  3. Application programs and utility software
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What does the operating system software do?

A

It manages all hardware components and makes it possible for all other software to run on the computers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What does the DBMS software do?

A

It manages the database within the database system”

-> Think about Microsoft SQL server, Oracle

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What do application programs and utility software do?

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which five types of users can be identified in a database system?

A
  1. System administrators
  2. Database administrators
  3. Database designers
  4. System analysts and programmers
  5. End-users
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What does a system administrator do?

A

He oversees the database systems general operations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What does a database administrator do?

A

He manages the DBMS and ensures that the database is functioning properly

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What does a database designer do?

A

He designs the database structure. -> The architects of the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What do system analysts and programmers do?

A

They design and implement the application software. They design and create the data entry screens, reports etc.

17
Q

What are end-users?

A

The people using the application programs to run the organizations daily operations.

18
Q

What do procedures refer to in a database system?

A

The instructions and rules that govern the design and the use of the database system.

They enforce the standard by which business is conducted.

They ensure there is an organized way to monitor and audit data, and the information derived from data.

19
Q

What is meant by data in a database system?

A

The collection of facts stored in the database.

20
Q

What are three considerations managers have to take into account if they think about implementing a new DBMS?

A
  1. Database complexity varies per company, and is partly a result of the organization’s management structure
  2. Database solutions must be cost-effective, but also tactically and strategically effective.
  3. The database technology in use is likely to affect the selection of a database system
21
Q

What are the 9 main functions of a DBMS?

A
  1. Data dictionary management
  2. Data storage management
  3. Data transformation and presentation
  4. Security Management
  5. Multi-user access control
  6. Backup and recovery management
  7. Data integrity management
  8. Database access languages and application programming interfaces
  9. Database communication interfaces
22
Q

What is meant with data dictionary management as a function of a DBMS?

A

The DBMS stores definitions and relationships from and between data elements. Changes made in database structure are recorded in the dictionary as well and applied.

-> The DBMS provides data abstraction and removes the structural and data dependence from the system.

23
Q

What is meant with data storage management as a function of a DBMS?

A
  • It creates and manages the complex structures required for data storage.
  • It provides storage for related data entries as well, such as entry forms, screen defintions, report definitions etc.
  • It is also important for database performance tuning
24
Q

What is database performance tuning?

A

The activities that make the database perform more efficiently in terms of storage and access speed.

25
Q

What is meant with data transformation and presentation as a function of a DBMS?

A

The transformation of the entered data to conform to required data structures.

Think about the way dates are formatted

26
Q

What is meant by security management as a function of a DBMS?

A

The DBMS creates a security system that enforces user security and data privacy.

-> Who can access what etc.

27
Q

What is meant by multi-user access control as a function of a DBMS?

A

The use of sophisticated algorithms to ensure that multiple users can access the database concurrently without compromising the integrity of the database

28
Q

What is meant by backup and recovery management as a function of a DBMS?

A

The provision of backup and data recovery to ensure data safety and integrity.

29
Q

What is meant by data integrity management as a function of a DBMS?

A

The promotion and enforcement of integrity rules, so that data redundancy is minimized and data consistency is maximized.

30
Q

What is meant by database access languages and application programming interfaces as a function of a DBMS?

A

A DBMS provides data acccess through a query language.

31
Q

What is a query language?

A

A nonprocedural language that lets the user specify what must be done without having to specify how it has to be done.

-> SQL

32
Q

What is database communication interfaces as a function of a DBMS?

A

Having interfaces for end-users’ requests that are using different network environments .

  • Screen forms for different browsers
  • Having pre-defined reports
  • Connect to third-party systems
33
Q

What are five disadvantages of a database system?

A
  • Increased cost
  • Management complexity
  • Maintaing currency (keep it up to date)
  • Vendor dependence
  • Frequent upgrade/replacement cycles
34
Q

What is meant with management complexity?

A

Managing the different technologies and the impact that they have on a company’s resources and culture.