Chapter 1 Flashcards
What is a organized collection of logically related data?
Database
What are stored representations of meaningful objects and events?
Data
What are the two types of data?
- Structured (numbers, text, dates)
- Unstructured (images, video, documents)
What is data processed to increase knowledged in the person using the data?
Information
What is data that describes the properties and context of user data?
Metadata
What are the disadvantages of file processing?
- Program-data dependence
- Duplication of data
- Limited data sharing
- Lengthy development times
- Excessive program maintenance
Why is the database approach the solution to the disadvantages of file processing?
- Central repository of shared data
- Data is managed by a controlling agent
- Stored in a standardized, convenient form
What are graphical diagrams capturing nature and relationship of data?
Data models
What are the two types of data models?
Enterprise Data Model - high-level entities and relationships
Project Data Model - more detailed view, matching data structure in database or data warehous
What is composed of attributes and is in noun form describing a person, place, object, event or concept?
Entities
What is the bond between entities that can be one-to many (1:M), many-to-many(M:N) or one-to-one (1:1)?
Relationships
What is database technology involving tables (relations) representing entities and primary/foreign keys representing relationships?
Relational databases
What are some costs and risks of the database approach?
- New, specialized personnel
- Installation and management cost and complexity
- Conversion costs
- Need for explicit backup and recovery
- Organizational conflict
What are automated tools used to design databases and application programs?
Data modeling and design tools
What is a centralized storehouse of metadata?
Repository