Question: You are studying the design documentation for an extremely large information system used by your organization. As expected, all entities on the logical data model
You are studying the design documentation for an extremely large information system used by your organization. As expected, all entities on the logical data model are in third normal form. But in comparing the logical data model to the physical database schema, you notice that two tables shown separately on the logical data model have been combined into one table on the physical database schema. There are no notes explaining this, and you can't ask the database administrator who signed off on the design documents but is no longer with the company What might the reason have been for compromising third normal form? What are the potential consequences?
Step by Step Solution
3.36 Rating (159 Votes )
There are 3 Steps involved in it
There could be several reasons for combining two tables from the logical data model into one table in the physical database schema potentially comprom... View full answer
Get step-by-step solutions from verified subject matter experts
