M1

Question 1

organized collection of logically related data

Answer 1

Database:

Question 2

stored representations of meaningful objects and

event

Answer 2

Data:

Question 3

data processed to increase knowledge in the

person using the data

Answer 3

Information:

Question 4

data that describes the properties and context

of user data

Answer 4

Metadata:

Question 5

All programs maintain metadata for each file they use.

Answer 5

Program-Data Dependence.

Question 6

Different systems/programs have separate copies of the same data.

Answer 6

Duplication of data.

Question 7

No centralized control of data

Answer 7

Limited Data Sharing

Question 8

Programmers must design their own file formats

Answer 8

Lengthy Development Times

Question 9

80% of information systems budget

Answer 9

Excessive Program Maintenanc

Question 10

Solution to the disadvantages of file processing

Answer 10

database

Question 11

A software system that is used to create, maintain, and provide controlled access to user databases

Answer 11

Database System Management

Question 12

Graphical system capturing nature and relationship of data

Answer 12

Data models

Question 13

high-level entities and relationships for the organization

Answer 13

Enterprise Data Model–

Question 14

more detailed view, matching data structure in database or data warehouse

Answer 14

Project Data Model–

Question 15

Noun form describing a person, place, object, event, or concept. Composed of attributes

Answer 15

entities

Question 16

Between entities. Usually one-to-many (1:M) or many-to-many (M:N

Answer 16

Relationships

Question 17

Database technology involving tables (relations) representing entities and primary/foreign keys representing relationship

Answer 17

Relational Databases

Question 18

computer-aided software engineering

Answer 18

CASE Tools

Question 19

centralized storehouse of metadata

Answer 19

Repository–

Question 20

software for managing the database

Answer 20

Database Management System (DBMS) –

Question 21

storehouse of the data

Answer 21

Database–

Question 22

software using the data

Answer 22

Application Programs–

Question 23

text and graphical displays to users

Answer 23

User Interface–

Question 24

personnel responsible for maintaining the database

Answer 24

Data/Database Administrators–

Question 25

personnel responsible for designing databases and software

Answer 25

System Developers–

Question 26

people who use the applications and databases

Answer 26

End Users–

Question 27

software using the data

Answer 27

Application Programs–

Question 28

text and graphical displays to users

Answer 28

User Interface–

Question 29

personnel responsible for maintaining the database

Answer 29

Data/Database Administrators–

Question 30

personnel responsible for designing databases and software

Answer 30

System Developers–

Question 31

people who use the applications and databases

Answer 31

End Users–

Question 32

Detailed, well-planned development process. Time-consuming, but comprehensive. Long development cycle.

Answer 32

System Development Life Cycle SLDC

Question 33

Cursory attempt at conceptual data modeling. Define database during the development of the initial prototype. Repeat implementation and maintenance activities with new prototype versions.

Answer 33

Rapid application development (RAD) // Prototyping

Question 34

Purpose–preliminary understanding Deliverable–request for study Database activity– enterprise modeling and early conceptual data modeling

Answer 34

Planning

Question 35

Purpose–thorough requirements analysis and structuring Deliverable–functional system specifications Database activity–thorough and integrated conceptual data modeling

Answer 35

Analysis

Question 36

Purpose–information requirements elicitation and structure Deliverable–detailed design specifications Database activity– logical database design (transactions, forms, displays, views, data integrity and security)

Answer 36

Logical Design

Question 37

Purpose–develop technology and organizational specifications Deliverable–program/data structures, technology purchases, organization redesign Database activity– physical database design (define database to DBMS, physical data organization, database processing programs)

Answer 37

Physical Design

Question 38

Purpose–programming, testing, training, installation, documenting Deliverable–operational programs, documentation, training materials Database activity– database implementation, including coded programs, documentation, installation and conversion

Answer 38

Implementation