Final Exam review part 1

Question 1

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the ___________________.

Answer 1

minimum cardinality

Question 2

T/F All weak entities must have a minimum cardinality of 1 on the entity on which it depends

Answer 2

True

Question 3

The data type for each attribute is chosen to maximize ___ and minimize storage space

a. query design
b. programmer productivity
c. data integrity
d. data integration

Answer 3

c. data integrity

Question 4

Boyce-Codd Normal Form is an example of database

a. normalization
b. denormalization
c. indexing
d. referential integrity

Answer 4

a. normalization

Question 5

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

Answer 5

foreign key

Question 6

As a database design passes from the logical phase to the physical, what do relations become

a. tuples
b. fields
c. tables
d. attributes
e. indexes

Answer 6

c. tables

Question 7

Relational database principles were first defined by a man named Codd (T/F)

Answer 7

True

Question 8

A database stores

a. data
b. relationships
c. applications
d. a and b
e. a b and c

Answer 8

e. a b and c

Question 9

An ID dependent entity is

a. a special type of weak entity
b. a special type of strong entity
c. an entity in which the identified of the entity cannot include the identifier of another entity
d. an entity with a max cardinality of one

Answer 9

a. a special type of weak entity