We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
The database is currently in 2NF with 10 tables
Each table has:
1 key attribute
1 non-key attribute
To convert from 2NF to 3NF:
Any non-key attribute that is transitively dependent on the key is removed into a separate table
Since each table already has only 1 non-key attribute, there are no transitive dependencies possible within a table
Therefore, no further normalization is needed to achieve 3NF
The 10 existing tables satisfy 3NF requirements
So if the database has 10 tables in 2NF, with 1 key and 1 non-key column each, then the same 10 tables also represent the 3NF form.
Minimum number of tables required for 3NF = 10
Therefore, the minimum number of tables required to express this database in 3NF is 10.
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Database Normalization #4
You are viewing a single comment's thread. Return to all comments →
The database is currently in 2NF with 10 tables Each table has: 1 key attribute 1 non-key attribute To convert from 2NF to 3NF: Any non-key attribute that is transitively dependent on the key is removed into a separate table Since each table already has only 1 non-key attribute, there are no transitive dependencies possible within a table Therefore, no further normalization is needed to achieve 3NF The 10 existing tables satisfy 3NF requirements So if the database has 10 tables in 2NF, with 1 key and 1 non-key column each, then the same 10 tables also represent the 3NF form.
Minimum number of tables required for 3NF = 10
Therefore, the minimum number of tables required to express this database in 3NF is 10.