Author Question: Explain the process of representing an entity using the relational model. What will be an ideal ... (Read 43 times)

Anajune7 · **on:** Jul 7, 2018

Explain the process of representing an entity using the relational model.

What will be an ideal response?

Question 2

Given the functional dependency for the attributes of ENTITY1, X (A, B, C), X is a candidate key for the relation ENTITY1 (A, B, C, X).

Indicate whether the statement is true or false

Pariscourtney · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

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.

Answer to Question 2

TRUE