intro to databases

Question 1

decision support system

Answer 1

computer-based info system that uses data and models to help a user solve semi-structured or unstructured decision problems

Question 2

structured problems

Answer 2

can write an algorithm, program is solved same way every time with the same answer every time

Question 3

structured problems are not included in DSS because

Answer 3

a decision is not being made

Question 4

unstructured problems

Answer 4

rare, most are semi structured

Question 5

database

Answer 5

collection of interrelated data organized in such a way that it corresponds to the needs and structure of an organization and can be used by more than one person for more than one application

Question 6

DBMS - meaning and enables?

Answer 6

database management system
- storage of data in database, retrieval of data, and control of database

Question 7

data

Answer 7

raw facts that can be recorded and preserved

Question 8

data management focuses on

Answer 8

proper generation, storage, and retrieval of data

Question 9

information

Answer 9

result of processing raw data to reveal its meaning in a given context

Question 10

key to good decision making

Answer 10

accurate, relevant, and timely information that provides a competitive advantage

Question 11

history has used a

Answer 11

traditional file-based system

Question 12

manual filing systems

Answer 12

• individual files for each purpose
• each business unit had its own file system
• organized to facilitate the expected use of the data
• data processing specialist required to retrieve data and run reports

Question 13

issues with file-based systems

Answer 13

• data redundancy (different files contain same info)
• isolation of data in separate systems
• data inconsistency (address changed in one file only)
• data anomalies (all changes may not be made successfully)
• program-data dependency (definition of data is coded into application programs)

Question 14

database systems

Answer 14

collection of programs that manages the database structure and controls access to data (security). makes data management more effective and efficient

Question 15

data based systems provides access to

Answer 15

data via query language (SQL)

Question 16

DBS makes it possible to

Answer 16

share data among multiple users/applications

Question 17

with DBS, end users have access to

Answer 17

more, better-managed data
- its possible to produce quick answers
- data inconsistencies recuced

Question 18

dbs promotes

Answer 18

integrated view of org’s operations

Question 19

advantages of database systems

Answer 19

• minimal data redundancy
• data consistency
• integration of data
• improved data sharing
• enforcements of standards
• ease of application development
• uniform security, privacy, integrity
• data independence from applications

Question 20

components of database system

Answer 20

hardware, software, people, procedures, data

Question 21

people

Answer 21

system administrators, database administrators, database designers, system analysts/programmers, end users

Question 22

system administrators

Answer 22

oversee general operations of entire system

Question 23

database administrators (DBAs)

Answer 23

manage DBMS

Question 24

system analysts and programmers

Answer 24

design and implement application programs to use the data

Question 25

databases can be classified according to

Answer 25

number of users, database locations, type of use

Question 26

number of users

Answer 26

single-user, multiuser

Question 27

multiuser

Answer 27

workgroup (50 or less) or enterprise databases

Question 28

locations

Answer 28

centralized or distributed database

Question 29

distributed database example

Answer 29

google search

Question 30

type of use

Answer 30

operational DB, data warehouse