This topic contains a solution. Click here to go to the answer
« previous next »

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

Anajune7

  • Hero Member
  • *****
  • Posts: 574
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


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Pariscourtney

  • Sr. Member
  • ****
  • Posts: 352
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


Anajune7

  • Member
  • Posts: 574
Reply 2 on: Jul 7, 2018
Excellent

ricroger

  • Member
  • Posts: 352
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

Did you know?

Less than one of every three adults with high LDL cholesterol has the condition under control. Only 48.1% with the condition are being treated for it.

Did you know?

Only 12 hours after an egg cell is fertilized by a sperm cell, the egg cell starts to divide. As it continues to divide, it moves along the fallopian tube toward the uterus at about 1 inch per day.

Did you know?

Individuals are never “cured” of addictions. Instead, they learn how to manage their disease to lead healthy, balanced lives.

The process of mitosis in an animal cell. The process of mitosis in an animal cell.
Coracoid process Coracoid process
A model of anxiety in which stressful events or a changing mental condition can produce unfavorable A model of anxiety in which stressful events or a changing mental condition can produce unfavorable
Basic process of metabolic profiling Basic process of metabolic profiling
A current model for protein secretion by prokaryotes A current model for protein secretion by prokaryotes
Molecular model of homologous recombination in meiosis Molecular model of homologous recombination in meiosis
Video: Normal and abnormal blood pH

For a complete list of videos, visit our video library