Fundamentals Of Database Management

Front 1

SQL aggregate

Back 1

SQL Functions that perform a calculation against a set of tables.

Front 2

Subqueries

Back 2

SELECT statement embedded within another SELECT statement.

Front 3

INSERT...SELECT

Back 3

SQL statement that retrieves data from one table and then feeds the retrieved data into another table.

Front 4

CREATE VIEW

Back 4

SQL statement that creates a virtual table.

Front 5

Prototyping

Back 5

Involves building a working model of the database system, which allows the designer or users to visualize and evaluate the system.

Front 6

Multi-valued Attribute

Back 6

Holds multiple values for an entity occurrence

Front 7

Relationship Occurrence

Back 7

Uniquely identifiable association, which includes one occurrence from each participating entity type.

Front 8

System Definition

Back 8

Involves identifying the scope and boundaries of the database system, including its major user views. A user view can represent a job role or business application area.

Front 9

Entity

Back 9

A set of objects with the same properties that are identified by a user or organization as having an independent existence.

Front 10

Weak Entity

Back 10

Partially or wholly dependent on the existence of another entity, or entities for its primary key.

Front 11

DBMS Selection

Back 11

Selection of an appropriate DBMS to support the database system.

Front 12

Transaction

Back 12

Action, or series of actions, carried out by a single user or application program that accesses or changes the content the database.

Front 13

Descriptive Attribute

Back 13

The name of the columns that are used to provide additional information about the relationship.

Front 14

Cardinality

Back 14

The number of possible relationships for each participating entity.

Front 15

Domain

Back 15

The set of allowable values for an attribute.

Front 16

Foreign Key

Back 16

A column, or set of columns, within one table that matches the primary key (i.e. candidate key) of some other table

Front 17

File-based system

Back 17

Collection of application programs that perform services for the end-users, such as production of reports; each program defines and manages its own data.

Front 18

Conceptual Level

Back 18

Community view of the database, describes what data is stored in database and relationships among the data.

Front 19

Logical data independence

Back 19

Refers to immunity of external schemas to changes in conceptual schema.

Front 20

Physical data indepence

Back 20

Refers to immunity of conceptual schema to changes in the internal schema.

Front 21

Database

Back 21

A shared collection of logically related data (and a description of this data), designed to meet the information needs of an organization.

Front 22

DBMS

Back 22

A software systems that enables users to define, create, and maintain the database, and also provides controlled access to this database.

Front 23

Database Application

Back 23

A computer program that interacts with the database by issuing an appropriate request (typically an SQL statement) to the DBMS

Front 24

Database System

Back 24

Used to define a collection of application programs that interacts with the database along with the DBMS and database itself.

Front 25

Database Instance

Back 25

The data in the database at a particular point in time.

Front 26

Database Schema

Back 26

A description of the database structure.

Front 27

Relations

Back 27

A table columns and rows.

Front 28

Attribute

Back 28

The name of the columns in a relation.

Front 29

Tuple

Back 29

A row in a relation table that represents an individual record.

Front 30

Domain

Back 30

The set of allowable values for an attribute.