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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Systems Analysis And Design 12th Questions!