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...
Which of the following is true of the reasons section of a bad-news message??
A) ?It should be written using the deductive approach. B) ?It should always be presented in the closing paragraph. C) ?It should include "company policy" as one of the reasons. D) ?It should emphasize how the audience will benefit from a decision.
________ is based on research that estimates how much of a product will sell over a given period of time.
A. Marketing effectiveness B. Promotion evaluation C. Demand analysis D. Sales forecasting E. Sales tracking
In order to begin exponential smoothing, a forecaster needs ______.
a. seasonal indices b. tracking signals c. the value of ? d. leading indicators
Only corner points should be considered for the optimal solution to a linear programming problem
Indicate whether the statement is true or false