This topic contains a solution. Click here to go to the answer

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

Anajune7

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


amynguyen1221

  • Member
  • Posts: 355
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

Patients who have been on total parenteral nutrition for more than a few days may need to have foods gradually reintroduced to give the digestive tract time to start working again.

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

For a complete list of videos, visit our video library