Final exam -- open book section

The entire exam is to be turned in by 3:45 PM. You must turn in the closed book section of the final before you consult your textbook or notes.

Question 1. (8 points)

Suppose the following SQL SELECT statement will list the names, department, and salaries of all company employees

SELECT Staff.Name, Staff.Dept, Staff.Salary
       FROM EmployeeTable ;

Now write two SQL statements to

Problem 2 (2 points)

Give an example of a functional dependency that is not a full function dependency.

Problem 3 (3 points)

Which would you expect to generate the most tuples: joining two relations or unioning two relations.

Question 4. (6 points)

Give examples of the following

Question 5. (1 point)

What CASE tool was used in the ER-diagram homework?

Question 6. (3 points)

Briefly explan what the following two C calls accomplish

Question 7. (12 points)

Suppose you have a relation with six attributes, A, B, C, D, E, and F, and the following dependencies:

Transform this relation into a set of relations that are in Boyce-Codd Normal Form (BCNF).

Back to the CSCI 363 home page