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 128 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

steff9894

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

« previous next »
 

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Did you know?

The human body produces and destroys 15 million blood cells every second.

The Murphy–Moller wellness model. The Murphy–Moller wellness model.
How to fit an exponential model to data How to fit an exponential model to data
DPSIR Model DPSIR Model
The first generation of model organisms in genetic analysis The first generation of model organisms in genetic analysis
Cancer cells can move to new locations in the body, a process called metastasis Cancer cells can move to new locations in the body, a process called metastasis
A multistep model for colon cancer. The first mutation, in the APC gene, leads to the formation of p A multistep model for colon cancer. The first mutation, in the APC gene, leads to the formation of p
Video: Coronary Heart Disease

For a complete list of videos, visit our video library