Explain the process of representing an entity using the relational model
What will be an ideal response?
To represent an entity using the relational model, first define a relation for the entity. The name of the entity is the name of the relation. Each attribute in the entity becomes a column in the relation. If the entity had a unique identifier that would make an appropriate primary key, then that attribute is made the key. If there is no such attribute, then the development team discusses identifiers with the users to determine if an acceptable key attribute exists. If not, then a surrogate key may be used. Finally, the relation is evaluated against the normalization criteria. Changes to the design may be necessary to satisfy the normalization requirements.
You might also like to view...
Policies that cover injuries reported during the policy period that occurred after the policy retroactive date are called:
a. Occurrence policies b. Claims Made policies c. Risk Transfer d. Risk Retention
The set of marketing variables a firm uses to achieve its desired sales performance is called the ________
A) promotion mix B) product mix C) marketing mix D) facilitating function E) CRM