Module #1 Flashcards
(49 cards)
organized collection of logically related data
Database
stored representations of meaningful objects and events
Data
data processed to increase knowledge in the person using the data
Information
data that describes the properties and context of user data
Metadata
All programs maintain metadata for each file they use
Program Data Dependence
Different systems/programs have separate copies of the same data
Duplication of Data
No centralized control of data
Limited Data Sharing
Programmers must design their own file formats
Lengthy Development Times
80% of information systems budget
Excessive Program Maintenance
Disadvantages of File Processing
- Program Data Dependence
- Limited Data Sharing
- Lengthy Development Times
- Excessive Program Maintenance
Central Repository of shared data
The Database Approach
Data is managed by a controlling agent
The Database Approach
Stored in a standardized convenient form
The Database Approach
A software system that is used to create, maintain, and provide controlled access to user databases
Database Management System
Graphical System capturing nature and relationship of data
Data models
high-level entities and relationships for the organization
Enterprise Data Model
more detailed view, matching data structure in database or data warehouse
Project Data Model
Composed of attributes
Entities
Noun form describing a person, place, object, event, or concept
Entities
Database technology involving tables (relations) representing entities and primary/foreign keys representing relationships
Relational Databases
computer aided software engineering
CASE Tools
centralized storehouse of metadata
Repository
software using the data
Application Programs
text and graphical displays to users
User Interface
