CHAPTER 9 Flashcards
(27 cards)
frameworks for organizing, storing and managing data
data structures
file processing systems, stores data in one or more separate files
file oriented system
all the tables are connected by common fields
database management systems
data design concepts
data structures
file oriented system
database management systems
three potential problems (file oriented system)
data redundancy
data integrity
rigid data structure
data common to two or more information system
data redundancy
occur if updates are not applied
data integrity
retrieving information from independent, file based systeme
rigid data structure
Types of files
master file
table file
transaction file
work file
security file
stores relatively permanent data about all an entiry
master file
contains reference data used by the information system
table file
stores records that contain day to day business and operational data
transaction file
temporary file created by an IS for a single task
work file
created and saved for back up & recovery purposes
security file
file created for archiving purposes
history file
collection of tools, features, and interfaces
database management system
complete definition of database, including descriptions of all fields
schema
view of database used by one or more systems
subschema
advantages of database management system
- scalability
- better support for client/server systems
- economy of scale
- flexible data sharing
- enterprise wide application
- stronger standards
- controlled redundancy
- better security
- increased programmer productivity
- data independence
integrates different applications
middleware
must be secure, yet easily accessible tp authorized users
data security
include entity, table, file, field, record, and key field
data design terminology
business that has its own separate legal and financial existence
entity
shown as two dimensional structures that consists vertical columns and horizontal rows
table or file
