Quiz 2

Question 1

The columns range of permissible values is known as its

Answer 1

Domain

Question 2

an attribute or combination of attributes that uniquely identifies any given row

Answer 2

Primary key (pk)

Question 3

A_____consists of one or more attributes that determine other attributes

Answer 3

Key

Question 4

____ is the state in which knowing the value of one attribute makes it possible to determine the value of another

Answer 4

Determination

Question 5

the value of one or more attributes determines the value of one ore more other attributes

Answer 5

Functional dependence

Question 6

the attribute whose value determines another is called ____

Answer 6

Determinant

Question 7

The attribute whose value is determined is called____

Answer 7

Dependent

Question 8

a key that is composed of more than one attribute

Answer 8

Composite Key

Question 9

an attribute that is part of a key is called ____

Answer 9

Key Attribute

Question 10

a key that can uniquely identify any row in the table

Answer 10

superkey

Question 11

is a minimal superkey– a superkey without any unnecessary attributes

Answer 11

candidate key

Question 12

is the condition in which each row in the table has its own unique identity

Answer 12

Entity integrity

Question 13

the abscence of any data value, and is never allowed in any part of the primary key

Answer 13

Null

Question 14

is the primary key of one table that has been placed into another table to create a common attribute

Answer 14

foreign key

Question 15

is defined as a key strictly for data retrieval purposes

Answer 15

Secondary key

Question 16

relational operators have the property of _____; that is, the use of relational algebra operators on existing relations produces new relations

Answer 16

closure

Question 17

some designers use special codes called_____to indicate the absence of some value

Answer 17

codes

Question 18

_____theoretical way of manipulating table contents

Answer 18

Relational algebra

Question 19

what are the 8 relational operators

Answer 19

SELECT, PROJECT, JOIN, INTERSECT,UNION,DIFFERENCE, PRODUCT, DIVIDE

Question 20

when a table contains the same number of columns and compatible domain it is called

Answer 20

Union compatible

Question 21

Links tables on the basis of an equality condition that compares specified columns of each table

Answer 21

Equijoin

Question 22

only returns matched records from the tables that are being joined

Answer 22

Inner Join

Question 23

Inner join plus all cells that don’t have a match

Answer 23

Outer Join

Question 24

provides a detailed description of all tables in the database

Answer 24

data dictionary

Question 25

detailed systems data dictionary, contains metadata

Answer 25

System catalog

Question 26

a ______ table is the implementation of a composite entity

Answer 26

linking table

Question 27

an orderly arrangement used to logically access rows in a table

Answer 27

Index

Question 28

the index’s reference point

Answer 28

index key