Question: Data Modeling Based on well - Formed rules, list all errors exists in the following data model for Company Database. All entity names should be
Data Modeling Based on wellFormed rules, list all errors exists in the following data model for Company Database. All entity names should be unique.
All entity names should be singular.
All entity names should be meaningful.
Every entity should have identifierprimary key. Identifier could be single attribute or composite attributes.
All attribute within one entity should have a unique name.
All attribute within one entity should have a meaningful name.
All attribute names should be singular.
All attribute names should not be calculable.
All attribute names should not be aggregate name Address is an aggregate name. it should be broken down to street address, city, state, and zip code
Relationship between two entities should be manymany. It should be oneone or manyone.
More than one relationship between two entities should have label.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
