Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Advance Database > Database Design > Flashcards

Database Design Flashcards

1
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
2
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
3
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
4
Q

System Development

A

System Development

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
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
6
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
7
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
8
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
9
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
9
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
10
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
11
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
12
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
13
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
14
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
15
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

16
Q

system maintenance activities

maintenance in response to systems errors

A

Corrective maintenance

17
Q

system maintenance activities

maintenance due to changes in the business environment

A

Adaptive maintenance

18
Q

system maintenance activities

maintenance to enhance the system

A

Perfective

19
Q

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

A

DATABASE LIFE CYCLE

20
Q

The overall purpose of the database initial study

A
  • Analyze the company situation
  • Define problems and constraints
  • Define objectives
  • Define scope and boundaries
21
Q

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

A

DATABASE DESIGN

22
Q

Two views of data

data as a source of
information

A

business view

23
Q

Two views of data

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

A

designer’s view

24
Q

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

A

IMPLEMENTATION AND LOADING

25
Q

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

A

Analyze the company situation

26
Q

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?

A

Define problems and constraints

27
Q

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?

A

Define Objectives

28
Q

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

A

Define Scopes and Boundaries

29
Q

defines the extent of the design according to operational requirements.

A

system’s scope

30
Q

Actions in database implementation and loading

a technique that creates logical representations
of computing resources that are independent of the underlying physical computing resources.

A

Install DBMS, Virtualization

31
Q

Actions in database implementation and loading

creation of special storagerelated constructs to house the end-user tables.

A

Create Database(s)

32
Q

Actions in database implementation and loading

Data will be migrated from the prior version of the system.

A

Load or Convert the data

33
Q

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

A

TESTING AND EVALUATION

Advance Database (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions