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 127 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
Great answer, keep it coming :)

tanna.moeller

  • Member
  • Posts: 328
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

A model genetic system, the fern Ceratopteris richardii A model genetic system, the fern Ceratopteris richardii
Lab: Amoeba Model Lab: Amoeba Model
Model for the events occurring around a single replication fork Model for the events occurring around a single replication fork
Comparison of Steps of the Nursing Process with the Research Process Comparison of Steps of the Nursing Process with the Research Process
Vermont Instruments manufactures two models of calculators. The finance model is the Fin-X and ... Vermont Instruments manufactures two models of calculators. The finance model is the Fin-X and ...
The first generation of model organisms in genetic analysis The first generation of model organisms in genetic analysis
Video: Heart Chambers

For a complete list of videos, visit our video library