Question: A functional dependency such as X ? Y means a. X functionally determines Y. b. Y is functionally dependent on X. c. either a. or

A functional dependency such as X ? Y means

a.

X functionally determines Y.

b.

Y is functionally dependent on X.

c.

either a. or b.

d.

neither a. or b.

QUESTION B

A functional dependency such as X ? Y means

a.

for each unique value Y in a relation table, there is one unique value X value associated.

b.

for each unique value X in a relation table, there is one unique value Y value associated.

c.

for each unique value Y in a relation table, there is at most one unique value X value associated.

d.

for each unique value X in a relation table, there is at most one unique value Y value associated.

QUESTION C

A key in a relation table is

a.

a proper subset of a candidate key.

b.

a proper superset of a superkey key.

c.

a minimal superkey.

d.

None a., b, and c are correct.

QUESTION D

A transaction is a logical unit of sequential operations that must be

a.

entirely completed.

b.

entirely aborted.

c.

either a. or b.

d.

neither a. nor b.

QUESTION E

Each transaction must display

a.

durability

b.

atomicity

c.

consistency

d.

isolation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!