Database Management

You have recently been hired as a data base expert for a consulting organization. As one of your first assignments, you have been asked to redesign an existing database that captures data on the different projects under way, the employees who are assigned to each project, their job titles and hourly charge rates, and the number of hours they have devoted to each project. The users are not happy with the existing database for several reasons.

This database was implemented by another employee as an Access data base. The corresponding table is reproduced below.  This person was unable to set a primary key because of the nature of the database, and felt it is a shortcoming of MS Access. The individual who maintains the data feels that she is often duplicating information when adding new rows of data.

1. Is the shown table in first normal form? If not, how could you convert it to such a table?
2. Infer the functional dependencies across the different attributes based on the description above and the data shown.
3. Identify instances of insertion, deletion, and modification anomaly if they exist.
4. Convert the relation to a set of 3NF relations. Give reasons for your answer.
5. Are the relations proposed in part (d) in BCNF? Why or why not?

PROJECTS