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 30 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
:D TYSM

xiazhe

  • Member
  • Posts: 331
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

The cure for trichomoniasis is easy as long as the patient does not drink alcoholic beverages for 24 hours. Just a single dose of medication is needed to rid the body of the disease. However, without proper precautions, an individual may contract the disease repeatedly. In fact, most people develop trichomoniasis again within three months of their last treatment.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

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
Model of the Reading Process Model of the Reading Process
What are examples of ideal forms? What are examples of ideal forms?
The leaky-barrel model: a settling-point model of eating and body weight homeostasis. The leaky-barrel model: a settling-point model of eating and body weight homeostasis.
The Collision-Coalescence Process The Collision-Coalescence Process
A Model of Directional Selection against a Recessive Lethal Allele A Model of Directional Selection against a Recessive Lethal Allele
Video: Red Blood Cells - Erythropoietin (EPO)

For a complete list of videos, visit our video library