False. It is not necessary that all databases should be in the Third Normal Form. It is upto the requirement of the application.
Adhering to the third normal form, while theoretically desirable, is not always practical. If you have a Customers table and you want to eliminate all possible interfield dependencies, you must create separate tables for cities, ZIP codes, sales representatives, customer classes, and any other factor that may be duplicated in multiple records.
In theory, normalization is worth pursuing; however, many small tables may degrade performance or exceed open file and memory capacities. |
