Chapter 12 Powerpoint

Front 1

Most e-business software are ______ ________, meaning that the DBMS is independent of the application software.

Back 1

database agnostic

Front 2

The data are manipulated and retrieved using _______ ________.

Back 2

database software

Front 3

What permits multiple applications to share the same database? It also permits the data to be physically stored apart from the application.

Back 3

Database Agnosticity

Front 4

Databases are frequently connected to e-business software at the ___ ___.

Back 4

Back End

Front 5

These are used interchangeably to denote the smallest block of data that will be stored and retrieved.

Back 5

Field, Data items, Attribute, Elements

Front 6

A ______ ________ is a specific set of data values for the record.

Back 6

record occurrence

Front 7

What level of database architecture includes: Database contents, Uses of database, Desired reports, Information to be reviewed.

Back 7

Conceptual Level

Front 8

What level of database architecture includes: tree, Network, and Relational

Back 8

Logical level

Front 9

What level of database architecture includes: Sequential, Indexed-sequential, and Direct

Back 9

Physical level

Front 10

The relationships that exist between the segments in the database are determined by the what?

Back 10

logical data structure

Front 11

what are the tree major models of logical data structure?

Back 11

1. Tree 2. Network structures 3. Relational models

Front 12

Both trees and networks are implemented with imbedded _______ ______.

Back 12

pointer fields

Front 13

In what type of structure do several rings pass through individual records?

Back 13

Multiple Ring Structure

Front 14

What are the three basic relational algebra operations?

Back 14

Selection, Join, and Projection

Front 15

What are the three normal forms?

Back 15

First normal form, Second normal form, Third normal form

Front 16

What type of organization is useful when batch processing is required?

Back 16

Sequential file

Front 17

An ISAM file structurally consists of what three distinct areas?

Back 17

The index, The prime area, and the overflow area

Front 18

The basic economics of file processing are largely determined by what?

Back 18

activity ratio

Front 19

What is the second economic consideration concern?

Back 19

response time

Front 20

Response time is affected by what?

Back 20

physical access time

Front 21

The ________ ________ to database design is to use an entity relationship model, which is then translated into a relational database, which is then implemented using ISAm.

Back 21

classical approach

Front 22

An alternate approach to database design is to use what?

Back 22

object-modeling technique

Front 23

The advantage to OLAP is what?

Back 23

It provides fast response to complicated queries.

Front 24

What differs from conventional databases in that the database is loaded into computer-internal RAM or other high-speed electronic storage device?

Back 24

IN-MEMORY DATABASE (IMDB)

Front 25

The elimination of the slow physical disk media results in what?

Back 25

enormous gains in speed

Front 26

What comprises database software and associated databases where the database software inputs, retrieves, and manipulates data in the database?

Back 26

Database Management Systems (DBMS)

Front 27

What are the three common attributes contained in all DBMS for managing and organizing data?

Back 27

1. Data description language (DDL)
2. Data manipulation language (DML)
3. Data query language (DQL)

Front 28

SQL: SELECT_

Back 28

Retrieves rows from tables

Front 29

SQL: UPDATE_

Back 29

Modifies the rows of tables

Front 30

SQL: DELETE_

Back 30

Removes rows from tables

Front 31

SQL: INSERT_

Back 31

Adds new rows to tables

Front 32

What integrates, standardizes, and provides security for various accounting applications?

Back 32

DBMS

Front 33

What is used to centralize, document, control, and coordinate the use of data within an organization?

Back 33

Database dictionaries

Front 34

What is a specific set of data values for the record?

Back 34

Record Occurrence

Front 35

Function: Creates a new table from selected rows of existing tables.

Back 35

Operation: Selection

Front 36

Function: Creates a new table from the rows of two existing tables.

Back 36

Operation: Join

Front 37

Function: Creates a new table by deleting columns from an existing table.

Back 37

Operation: Projection

Front 38

Allows the database administrator to define the logical structure of the database, called the schema.

Back 38

DDL

Front 39

Consists of the commands for updating, editing, manipulating, and extracting data.

Back 39

DML

Front 40

A user-friendly language or interface that allows the user to request information from the database.

Back 40

DQL