Database Design Flashcards by Oldest Dream

Q

system that provides for data collection, storage, and retrieval

A

Information System

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

An information system is composed of

A

hardware,
the DBMS and other software, database(s),
People
Procedures

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

the process that establishes the need for an information system and its extent.

A

System Analysis

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

System Development

A

System Development

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

three factors an information system depends on

Database design and ______________

A

implementation

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

three factors an information system depends on

________ design and implementation

A

Application

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

three factors an information system depends on

____________ procedures

A

Administrative

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

the process of database design and implementation

A

Database Development

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

to create complete, normalized, no redundancy, and fully integrated conceptual, logical, and physical
database models is the primary objective of what?

A

Database Design

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

This phase includes creating the database storage structure, loading data into the database, and providing for data management.

A

implementation

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

a cycle that traces the history of an information system.

A

System Development Life Cycle (SDLC)

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

System Development Life Cycle (SDLC)

This phase yields a general overview of the company and its objectives

A

PLANNING

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

System Development Life Cycle (SDLC)

This phase of the SDLC is, in effect, a thorough audit of user requirements.

A

ANALYSIS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

System Development Life Cycle (SDLC)

This phase includes all the necessary technical specifications for the screens, menus,
reports, and other devices that might help make the system a more efficient information
generator

A

DETAILED SYSTEMS DESIGN

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

System Development Life Cycle (SDLC)

This phase is where actual database is created, and the system is customized by the creation of table
views, user authorization and so on.

A

IMPLEMENTATION

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

System Development Life Cycle (SDLC)

This phase is where the system is operational and end users begin to request changes in it

A

MAINTENANCE

Q

system maintenance activities

maintenance in response to systems errors

A

Corrective maintenance

Q

system maintenance activities

maintenance due to changes in the business environment

A

Adaptive maintenance

Q

system maintenance activities

maintenance to enhance the system

A

Perfective

Q

A cycle that traces the history of a database within an information system.

A

DATABASE LIFE CYCLE

Q

The overall purpose of the database initial study

A

Analyze the company situation
Define problems and constraints
Define objectives
Define scope and boundaries

Q

most critical DBCL phase since it will make sure that the final product meets the user and system requirements.

A

DATABASE DESIGN

Q

Two views of data

data as a source of
information

A

business view

Q

Two views of data

data structure, its access, and the activities required to transform the data into information.

A

designer’s view

includes creation of tables, attributes, domains, views, indexes, security constraints and storage and performance guidelines

IMPLEMENTATION AND LOADING

It describe the general condition in which the company operates, its organizational structure, and its mission.

Analyze the company situation

Should answer questions like: * How does the existing function? * What input does the system require? * What document does the system generated? * By whom and how the is the system output used?

Define problems and constraints

The database designer must address the following questions: * What is the proposed system’s initial objective? * Will the system interface with other existing or future systems in the company? * Will the system share the data with other systems or users?

Define Objectives

It helps define the required data structures, the type and number of entities, the physical size of the database, and so on.

Define Scopes and Boundaries

defines the extent of the design according to operational requirements.

system’s scope

# Actions in database implementation and loading a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.

Install DBMS, Virtualization

# Actions in database implementation and loading creation of special storagerelated constructs to house the end-user tables.

Create Database(s)

# Actions in database implementation and loading Data will be migrated from the prior version of the system.

Load or Convert the data

DBA test and fine-tunes the database to ensure that is performed as expected

TESTING AND EVALUATION