I have been reading up on database design and I am having some difficulty constructing functional dependency diagrams from tables.
I have the following table. Each salesperson is identified by a salesperson’s number, and their sales activities are recorded for each month in the table.
http://i.stack.imgur.com/2NXru.png
I have made the following assumptions:
- Each Salesperson has a unique salesperson number
- Each Client has a unique client number
- Each product has a unique product number and description
- Each Customer has a unique sales persons that they deal with.
I have come up with the following functional dependencies diagram:
http://i.stack.imgur.com/XFndy.png
My questions are:
- First of all is this correct way of creating a fd diagram?
- Is this correct based upon the assumptions?