CHAPTER 9

Question 1

frameworks for organizing, storing and managing data

Answer 1

data structures

Question 2

file processing systems, stores data in one or more separate files

Answer 2

file oriented system

Question 3

all the tables are connected by common fields

Answer 3

database management systems

Question 4

data design concepts

Answer 4

data structures
file oriented system
database management systems

Question 5

three potential problems (file oriented system)

Answer 5

data redundancy
data integrity
rigid data structure

Question 6

data common to two or more information system

Answer 6

data redundancy

Question 7

occur if updates are not applied

Answer 7

data integrity

Question 8

retrieving information from independent, file based systeme

Answer 8

rigid data structure

Question 9

Types of files

Answer 9

master file
table file
transaction file
work file
security file

Question 10

stores relatively permanent data about all an entiry

Answer 10

master file

Question 11

contains reference data used by the information system

Answer 11

table file

Question 12

stores records that contain day to day business and operational data

Answer 12

transaction file

Question 13

temporary file created by an IS for a single task

Answer 13

work file

Question 14

created and saved for back up & recovery purposes

Answer 14

security file

Question 15

file created for archiving purposes

Answer 15

history file

Question 16

collection of tools, features, and interfaces

Answer 16

database management system

Question 17

complete definition of database, including descriptions of all fields

Answer 17

schema

Question 18

view of database used by one or more systems

Answer 18

subschema

Question 19

advantages of database management system

Answer 19

1. scalability
2. better support for client/server systems
3. economy of scale
4. flexible data sharing
5. enterprise wide application
6. stronger standards
7. controlled redundancy
8. better security
9. increased programmer productivity
10. data independence

Question 20

integrates different applications

Answer 20

middleware

Question 21

must be secure, yet easily accessible tp authorized users

Answer 21

data security

Question 22

include entity, table, file, field, record, and key field

Answer 22

data design terminology

Question 23

business that has its own separate legal and financial existence

Answer 23

entity

Question 24

shown as two dimensional structures that consists vertical columns and horizontal rows

Answer 24

table or file

Question 25

single characteristics or facts about an entity

Answer 25

field

Question 26

set of related fields that describes one instance or occurrence of an entity

Answer 26

record

Question 27

to organize, access and maintain data structure

Answer 27

key fields