The Database Environment and Database Development Process

Reference:
Modern Database Management 8th Edition
BY: Jeffrey A. Hoffer, Mary B. Prescott , Fred R. McFaddenChapter 1 & Chapter 2

143 cards   |   Total Attempts: 182
  

Cards In This Set

Front Back
Organized collection of logically related data
Database
Stored representations of meaningful objects and events
Data
2 types of Data.
>structured
>unstructured
What type of data are numbers, text and dates?
Structured
What type of data are images, videos and documents
Unstructured
What does UML stand for?
Unfinished Modelling Languages
Helps users understand data
Context
Turn data into useful information that managers can use for decision making and interpretation
Graphical display
Descriptions of the properties or characteristics of the data, including data types, field sizes, allowable values, and data context
Metadata
5 Disadvantages of File Processing
>Program-data dependence>Duplication of Data/ data redundancy
>Limited Data Sharing
>Lengthy Development Times
>Excessive Program Maintenance
Disadvantage of file processing where All programs maintain metadata for each file they use
Program-data dependence
Disadvantage of file processing where different systems/programs have seperate copies of the same data.
Duplication of data/data redudancy
Disadvantage of file processing where there is no centralized control of data
Limited Data sharing
Disadvantage of file processing where programmers must design their own file formats
Lengthy development time
Disadvantage of file processing where 80% of information systems budget is used.
Excessive program Maintenance