clif
commented
6 years ago I added the functional dependencies for each table in the Final Report document in our team drive. We need to populate our table to verify that they may be true
Open clif opened 6 years ago
clif
commented
6 years ago I added the functional dependencies for each table in the Final Report document in our team drive. We need to populate our table to verify that they may be true
Hmmm... we can easily argue that every non-key attribute in each table we have in our DB schema depends on the primary keys that we have and no other non-key attributes can can uniquely identify them, which means there are no transitive dependencies. There are no nested relations and there are no partial dependencies.
Seems like we will need to populate our tables with data to be able to list out any other possible functional dependencies that aren't obvious. I can work on the SQL script for creating the tables tomorrow.