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 29 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
Wow, this really help

sultansheikh

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

« previous next »
 

Did you know?

A headache when you wake up in the morning is indicative of sinusitis. Other symptoms of sinusitis can include fever, weakness, tiredness, a cough that may be more severe at night, and a runny nose or nasal congestion.

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

Kidney Anatomy model Kidney Anatomy model
Human Heart Model Human Heart Model
Eye Model Eye Model
Critical thinking model for safety assessment Critical thinking model for safety assessment
A summary model of the regulation of gonadal hormones. A summary model of the regulation of gonadal hormones.
Vulnerability – Stress Model Vulnerability – Stress Model
Video: Electrical Conduction System of the Heart

For a complete list of videos, visit our video library