How would you check a data model for redundancy? Give an example to illustrate your answer.
What will be an ideal response?
(1) Re-examine one-to-one (1:1) relationships
In the identification of entities, we may have identified two entities that represent the same
object in the enterprise. For example, we may have identified the two entities Client and
Renter that are actually the same; in other words, Client is a synonym for Renter. In this
case, the two entities should be merged together. If the primary keys are different, choose one
of them to be the primary key and leave the other as an alternate key.
A relationship is redundant if the same information can be obtained via other relationships.
We are trying to develop a minimal data model and, as redundant relationships are
unnecessary, they should be removed. It is relatively easy to identify whether there is more
than one path between two entities. However, this does not necessarily imply that one of the
relationships is redundant, as they may represent different associations between the entities.
(3) Consider time dimension The time dimension is important when assessing redundancy.
You might also like to view...
In the Web.config file, the service binding in the endpoint element must be set to ________ to support REST-based HTTP requests.
a) webHttpBinding b) wsHttpBinding c) basicHttpBinding d) netHttpBinding
The Columns button is found in the ________ group under the Page Layout tab
A) Page Setup B) Paragraph C) Page Background D) Arrange
The Revisions pane is used when ________ in a presentation
A) tracking changes B) creating and editing Microsoft Visual Basic C) editing comments D) working with ActiveX Controls
For the most part, licensing for Microsoft SQL Server 2008 is available under three specific terms. What are these?
What will be an ideal response?