DBMS CHAPTERS 1-4: MIDTERM EXAM
Database - Correct Answers -- Organized collection of logically related data where data
is formatted
- Tabular format in two dimensions with columns and rows
Data - Correct Answers -- Bare facts without meaning
- Structured: numbers, text, dates
- Unstructured: images, videos, entire documents
Information - Correct Answers -- Data with context that has relevance or meaning
attached to it
- Has been processed to increase user's knowledge
Metadata - Correct Answers -- Data about data
- Describes the context of data (ex. name input is text, ID is numeric, source of data)
Program-Data Dependence - Correct Answers -- all programs have metadata for each
file
- each programmer must maintain their own data and include code for their metadata.
Metadata must be the same throughout all programs.They should include their own
processing routines, have coordination and central control, and standardize file formats.
Duplication of Data - Correct Answers -- different systems/programs have separate
copies of the same data which is a waste of space and causes more maintenance. The
biggest problem is that data changes in one file cause inconsistencies and
compromises in data integrity (redundancy)
RAD (Rapid Application Development) - Correct Answers -1. Prototyping
2. Agile methodologies
3. Extreme programming
4. Scrum
5. Dynamic system development methodologies (DSDM)
Three Schema Architecture - Correct Answers -1. External Schema: User views,
subsets of conceptual schema, DBA determines schema for different users
2. Conceptual Schema: ER Models
3. Internal Schema: logical and physical structures
Enterprise Applications - Correct Answers -- Gigabytes, terabytes, or petabytes, very
large user base
Database - Correct Answers -- Organized collection of logically related data where data
is formatted
- Tabular format in two dimensions with columns and rows
Data - Correct Answers -- Bare facts without meaning
- Structured: numbers, text, dates
- Unstructured: images, videos, entire documents
Information - Correct Answers -- Data with context that has relevance or meaning
attached to it
- Has been processed to increase user's knowledge
Metadata - Correct Answers -- Data about data
- Describes the context of data (ex. name input is text, ID is numeric, source of data)
Program-Data Dependence - Correct Answers -- all programs have metadata for each
file
- each programmer must maintain their own data and include code for their metadata.
Metadata must be the same throughout all programs.They should include their own
processing routines, have coordination and central control, and standardize file formats.
Duplication of Data - Correct Answers -- different systems/programs have separate
copies of the same data which is a waste of space and causes more maintenance. The
biggest problem is that data changes in one file cause inconsistencies and
compromises in data integrity (redundancy)
RAD (Rapid Application Development) - Correct Answers -1. Prototyping
2. Agile methodologies
3. Extreme programming
4. Scrum
5. Dynamic system development methodologies (DSDM)
Three Schema Architecture - Correct Answers -1. External Schema: User views,
subsets of conceptual schema, DBA determines schema for different users
2. Conceptual Schema: ER Models
3. Internal Schema: logical and physical structures
Enterprise Applications - Correct Answers -- Gigabytes, terabytes, or petabytes, very
large user base
