In order to convert a table to BCNF, we must :
- Find and remove the overlapping candidate keys. Place the part of the candidate key and the attribute it is functionally dependent on, in a different table.
- Group the remaining items into a table.
Hence,from the PROJECT table( refer to the Boycee-Codd Normal Form (BCNF) Link: http://churmura.com/boycee-codd-normal-form-bcnf/), remove NAME and ECODE and palce them in a different table.You will arrive at the following tables.
