database-design methodology functional-dependencies

Database Design - functional dependency methodology

Is there any standard methodology (step-by-step system) to determine the functional dependencies of a database? Maybe an algorithm that i could apply?I'm trying to optimize a beta database model i have created for a site like imdb and to work through Armstrong's axioms seems impossible for a huge database model, like the one i have created.Thanks in advance!

Solution

Functional dependencies are really business rules, i.e. statements about the real world to be modelled in a database. There is no tool or shortcut that can decide them for you. You have to discover functional dependencies through proper analysis and understanding of the problem domain.

SET CONSTRAINTS ALL DEFERRED not working as expected
Verify and/or Recommend Re Database Design for an Internal Admin Chat System
Why should I create separate payment table for orders table for ecommerce database
How do I store a directory / hierarchy / tree structure in a database?
How can I model resource exchange processes?
Why would you want to put an index on a view?
SQL table design with foreign key
Use of SQL Schema
Execute deferred trigger only once per row in PostgreSQL
In ER diagram, is order and cart relationship are weak entity relationship?
Relational table design with same type in a many-to-many relationship
Where Constants should be stored in the database
What is suggested database schema for order/invoice information?
internal implementation of database queries
How can you represent inheritance in a database?
Database Design Without Foreign Keys
MySQL database design for image options relationships
Normalization of vehicle data
Should I always use navigation properties or use the .Where query?
Ensuring consistent common reference among two tables
Calculating and saving space in PostgreSQL
Should I create a surrogate key instead of a composite key?
Relational Data Model for Double-Entry Accounting
MySQL partitioning by week automatically
When should you use a one-to-one relationship with tables in your database?
Housing Society management system database structure
How do I simplify this model with a double reference?
To use a FK in a one-to-many relationship versus using a join table
Facing the problem of uploading the member ID while uploading the data to multiple tables through a single form/click
Difference between superkey and composite key