Module #1 Flashcards

1
Q

organized collection of logically related data

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

stored representations of meaningful objects and events

A

Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

data processed to increase knowledge in the person using the data

A

Information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

data that describes the properties and context of user data

A

Metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

All programs maintain metadata for each file they use

A

Program Data Dependence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Different systems/programs have separate copies of the same data

A

Duplication of Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

No centralized control of data

A

Limited Data Sharing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Programmers must design their own file formats

A

Lengthy Development Times

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

80% of information systems budget

A

Excessive Program Maintenance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Disadvantages of File Processing

A
  • Program Data Dependence
  • Limited Data Sharing
  • Lengthy Development Times
  • Excessive Program Maintenance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Central Repository of shared data

A

The Database Approach

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Data is managed by a controlling agent

A

The Database Approach

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Stored in a standardized convenient form

A

The Database Approach

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

Database Management System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Graphical System capturing nature and relationship of data

A

Data models

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

high-level entities and relationships for the organization

A

Enterprise Data Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

Project Data Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Composed of attributes

A

Entities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Noun form describing a person, place, object, event, or concept

A

Entities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

Relational Databases

21
Q

computer aided software engineering

A

CASE Tools

22
Q

centralized storehouse of metadata

A

Repository

23
Q

software using the data

A

Application Programs

24
Q

text and graphical displays to users

A

User Interface

25
Q

personnel responsible for maintaining the
database

A

Data/Database Administrators

26
Q

people who use the applications and databases

A

End Users

27
Q

personnel responsible for designing databases and software

A

System Developers

28
Q

SDLC

A

System Development Life Cycle

29
Q

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

A

SDLC

30
Q

Rapid application development

A

RAD

31
Q

Cursory attempt at conceptual data modeling

A

Prototyping

32
Q

Define database during development of initial prototype

A

Prototyping

33
Q

Repeat implementation and maintenance activities with new prototype versions

A

Prototyping

34
Q

System Development Life Cycle

A
  1. Planning
  2. Analysis
  3. Logical Design
  4. Physical Design
  5. Implementation
  6. Maintenance
35
Q

User Views

A

External Schema

36
Q

Subsets of Conceptual Schema

A

External Schema

37
Q

Can be determined from business function/data entity matrices

A

External Schema

38
Q

E R models

A

Conceptual Schema

39
Q

Logical structures

A

Internal Schema

40
Q

Physical structures

A

Internal Schema

41
Q

is the underlying design and implementation

A

Internal Schema

41
Q

Different people have different views of the database

A

External Schema

41
Q

a planned undertaking of related activities to reach an objective that has a beginning and an end

A

Project

41
Q

Enterprise resource planning (ERP) systems

A

Enterprise applications

41
Q

Range of Database Applications

A
  1. Personal databases
  2. Multitier client/server databases
  3. Enterprise applications
41
Q

Data warehousing implementations

A

Enterprise applications

41
Q

Executed during analysis, design, and implementation

A

Managing Projects

41
Q

Initiated and planned in planning stage of SDLC

A

Managing Projects

41
Q

Closed at the end of implementation

A

Managing Projects