Search code examples
databasedatabase-designdatabase-normalization

Is a database design's normal form the least of the normal forms of its tables?

I was wondering, if I have

Table1 -> 2NF
Table2 -> 3NF 
Table3 -> 3NF

then is my database design's normal form the least one among its tables' normal forms? In this case 2nf?

Solution

  • Yes. When we say that a database is in a certain normal form we mean that every table in it is in at least that normal form.