Quiz 1 - Part 3

Question 1

A table is perceived as a t….-d……. structure composed of r…. and c…..

Answer 1

two-dimensional / rows and columns

Question 2

each table row (tuple) represents a single e…. o…… within the e…. s….

Answer 2

entity occurrence / entity set

Question 3

Each table column rerpresent an a….., and each column has a distinct name

Answer 3

attribute

Question 4

Each intersection of a r…. and a c……. represent a single d…. v…..

Answer 4

row and column / data value

Question 5

All values in a column must conform to the same d…. f….

Answer 5

data format

Question 6

Each column has a specific range of values known as the a…… d…….

Answer 6

attribute domain

Question 7

the order of the rows and columns is i…… to the DBMS

Answer 7

IMMATERIAL

Question 8

Each table must have an a….. or combination of a….. that u….. identifies each row

Answer 8

attribute / attributes / uniquely

Question 9

Consist of one or more attributes that determines other attribute

Answer 9

Keys

Question 10

Keys are used to ensure that each row in a table is u….. identifiable

Answer 10

uniquely

Question 11

Keys are used to establish r….. among tables and to ensure i…. of the data

Answer 11

relationships / integrity

Question 12

Attribute or combination of attributes that uniquely identifies any give row

Answer 12

Primary key

Question 13

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

Answer 13

Functional dependence

Question 14

Attribute whose value determines another

Answer 14

Determinant

Question 15

Attribute whose value is determined by the other attribute

Answer 15

Dependent

Question 16

Full f….. d….. is when Entire collection of attributes in the determinant is necessary for the relationship

Answer 16

functional dependence

Question 17

Key that is composed of more than one attribute

Answer 17

Composite key

Question 18

Attribute that is a part of a key

Answer 18

key attribute

Question 19

Any key that uniquely identifies each row

Answer 19

superkey

Question 20

A superkey without redundancies

Answer 20

candidate key

Question 21

Condition in which each row in the table has its own unique identity. All values in the PK must be unique. No nulls in the PK

Answer 21

entity integrity

Question 22

Every reference to an entity instance by another entity instance is valid

Answer 22

Referential integrity

Question 23

Not permitted in primary key, should be avoided in other attributes. can create problems when functions as average are used. can create logcal problems.

Answer 23

Nulls

Question 24

C…… r……. makes the relational database work

Answer 24

controlled redundancy

Question 25

R……. exists only when there is unnecessary duplication of attributes values

Answer 25

redundancy

Question 26

An attribute whose values match primary key values in the related table

Answer 26

Foreign key

Question 27

FK contains a value that refers to an existing valid tuple (row) in another relation

Answer 27

Referential integrity

Question 28

Key used strictly for data retrieval purposes

Answer 28

Secondary key

Question 29

for integrity rules requirement is that all …. keys entries are unique, and no nulls

Answer 29

primary keys

Question 30

for integrity rules a ….. key may have either a null entry or a entry that matches the primary key value in a tabe to which it is related

Answer 30

foreign key

Question 31

Special codes used to indicate the absence of some value

Answer 31

flags

Question 32

Placed on a column to ensure that every row in the table has a value for that column

Answer 32

NOT NULL constrains

Question 33

Restriction placed on a column to ensure that no duplicate values exist for that column

Answer 33

UNIQUE constraint

Question 34

SELECT, PROJECT, UNION, INTERSECT , ETC ARE

Answer 34

Relational algebra operators

Question 35

Only returns matched records from the tables that are being joined

Answer 35

Inner join

Question 36

Yields all of the rows in the first table, including those that do not have a matching value in the second table

Answer 36

left outer join

Question 37

Yields all of the rows in the second table, including those that do not have matching values in the first table

Answer 37

right outer join

Question 38

Provides detailed description of all tables found within the user/designer-created database

Answer 38

Data dictionary

Question 39

data dictionary contains m….

Answer 39

metadata

Question 40

Detailed system data dictionary that describes all objects within the database

Answer 40

SYSTEM CATALOG

Question 41

System catalog and data dictioanry are often used i……

Answer 41

interchangeably

Question 42

Should be the norm in any relational database design

Answer 42

1:M relationship

Question 43

Should be rare in any relational database design

Answer 43

1:1 relationship

Question 44

Cannot be implemented as such in the relational model

Answer 44

M:N relationships

Question 45

Helps avoid problems inherent to M:N relationships, includes the primary keys of tables to be linked

Answer 45

Composite entity (Bridge or associative entity)

Question 46

Arrangement used to logically access rows in a table

Answer 46

index

Question 47

index reference point. point to data location identified by the key

Answer 47

index key

Question 48

index in which the index key can have only one pointer value associate with it

Answer 48

unique index

Question 49

each index is associated with o….. o….. table

Answer 49

only one