Key terms

Question 1

The program accessing the database is dependent on the structure

Answer 1

Structural Dependence

Question 2

The program accessing the database is dependent on the type of data being stored

Answer 2

Data dependence

Question 3

When one attribute is dependent on the contents of the other attribute

Answer 3

Functional dependence

Question 4

One attribute value determines another attribute value

Answer 4

Determinant

Question 5

Attribute whose value is dependent on another attribute

Answer 5

Dependent

Question 6

A key with more than one attribute

Answer 6

Composite key

Question 7

Any attribute that is a part of a key

Answer 7

Key attribute

Question 8

A set of keys that uniquely identify each row

Answer 8

Superkey

Question 9

A superkey without the unnecessary attributes

Answer 9

Candidate key

Question 10

Happens where each row in an entity has a unique identity

Answer 10

Entity integrity

Question 11

A characteristic of an entity

Answer 11

Attribute

Question 12

An association among entities

Answer 12

Relationship

Question 13

A restriction placed on data

Answer 13

Constraint

Question 14

A description of a policy, procedure or principle within and organization

Answer 14

Business rule

Question 15

Defines the environment in which data can be managed (or can be used to work with data in the database). Examples are SELECT, INSERT, UPDATE, etc.

Answer 15

Data Manipulation Language (DML)

Question 16

Enables the database administrator to define the database structure and schema components

Answer 16

Data Definition Language (DDL)