Several managers perform interviews with job applicants (one applicant is interviewed by one manager). The manager makes appointments for interviews with the applicants. Each applicant may be interviewed on several occasions, possibly by different managers, but in that case, the interviews take place on different days. Each manager uses the same room for all interviews during the day. A room may, however, be used by different managers during the day, as long as the interviews are not at the same time. The system uses a single relation for all data, with the following schema:

Interviews(manager, applicant, day, time, room).

1. Find functional dependencies.

2. Find the keys of the relation.

3. Show that the relation is in 3NF but not in BCNF.

4. Decompose the relation in relations that are in BCNF.

5. Draw an E/R diagram that describes the system.

Try to incorporate all dependencies.

 

Answer rating: 100% (QA)

Solution Functional Dependencies and Keys 1 Functional Dependencies manager day room A manager schedules interviews on a specific day in a specific ro... View the full answer