Hello, here is the table and functional dependancies that I am working with:

Furniture (FID, Manufacturer Name, Model#, Model Name, Description, I#, Step#, Text, Part#Number Used)

FDs:

FID - Manufacturer Name, Model#, Model Name, Description, I#

I#, Step# - Text

I#, Step#, Part# -Number Used

I belive my key is: (FID, I#, STEP#, PART#).

I know need to decompose this database as stated in the question below:

a) Put your version of the database into 3NF (you may assume it is already in 1NF). Provide one list of relations defining the database in 3NF.

b) Put your version of the database into BCNF. Start with your result from part a). Provide one list of relations defining the database in BCNF. You must use Normalization through Decomposition to normalize your database.

Note that this is a binary process you must show all the steps. Be sure to show which dependencies hold with each relation DO NOT just list all FDs at the end.

Thank you for your help!