The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.
When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.
The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.
In all cases, normalization into BCNF is desirable.
Please disable the adBlock and continue. Thank you.