2. Referential intergrity constraints are used to limit the possible values of a
a.candidate key
b.surrogate key
c.foregin key
d.composite key
e. dependency

3. In a sql query which built in function is used to compute the no. of rows in a table
Avg
Count
Max
Min
Mean

4. A sales contact manger application used by a salesperson is an example of an ……………………
a.single user database application
b.multi user database application
c. e-commerce database application
all of the above
both A or C

5. Saying that two entities are functionally dependent means that ……………….
a. Entities are always connected by a mathematical equation
b. For one of the entities if we are given the value of that entity we can determine the value of one other entity
c. For both of the entities if we are given the value of those entities we can determine the value of one other entity
d. The functional dependency will have to be removed through normalization
e. All of the above

6. Match the following terms to their definitions
Answer potential matches
____________ MAX 1. Sql built in function that obtains the smallest value in a numeric column
____________SUM 2. Sql built in function that obtains the largest value in a numeric column
___________ AVG 3. Sql built in function that computes the number of rows in a table
__________ MIN 4. Sql built in function that totals values in a numeric column
_________ COUNT 5. SQL built in function that computes the average of values in a numeric column

7. Explain the relationships among the primary keys and functional dependencies. (20 points)