MIS 4113 Mid Term Exam MHarrold.

MIS 4113 Mid-Term Exam Solution

1.       A combination of one or more columns used to identify particular rows in a relation is a              .

a.       key

b.       tuple

c.       record

d.       field

2.       A relation is also known as a(n)                   .

a.       attribute

b.       tuple

c.       relationship

d.      table

3.       An identifier may be                   .

a.       a single attribute

b.       composite attributes

c.       a relationship

d.      A & B

e.       A, B, C

4.       Given the functional dependency A  (B, C), A is a(n) _ .

a.       Composite determinant

b.      Determinant

c.       Dependent variable

d.       Independent variable

5.       If a table is designed so that every determinant is a candidate key, then that relation is in

        .

a.       Boyce-Codd Normal Form

b.       First Normal Form

c.       Second Normal Form

d.       Third Normal Form

6.       Omitted!

7.       A Candidate Key of a relation consists of the Primary key plus any Alternate Keys.

          True                                 _X      False

8.       Explain when you would use a JOIN and when you would use a SUB QUERY.

You would use a subquery when all the selected fields are from the MAIN (Top) query. You can use a JOIN at any time.