This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Distinguish between entity identifiers and keys. What will be an ideal ... (Read 28 times)

nummyann

  • Hero Member
  • *****
  • Posts: 576
on: Jul 7, 2018
Distinguish between entity identifiers and keys.
 
  What will be an ideal response?

Question 2

In MySQL, surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.
 
  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

mariahkathleeen

  • Sr. Member
  • ****
  • Posts: 337
Reply #1 on: Jul 7, 2018
Answer to Question 1

An entity identifier is an attribute or group of attributes that is used to name or identify instances of an entity class. Unlike a key in the relational model, an entity identifier is more of a logical concept. It is simply an attribute that the users think of as distinguishing between entity instances in their environment.

Answer to Question 2

FALSE


nummyann

  • Member
  • Posts: 576
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

ghepp

  • Member
  • Posts: 361
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

The average older adult in the United States takes five prescription drugs per day. Half of these drugs contain a sedative. Alcohol should therefore be avoided by most senior citizens because of the dangerous interactions between alcohol and sedatives.

Did you know?

People often find it difficult to accept the idea that bacteria can be beneficial and improve health. Lactic acid bacteria are good, and when eaten, these bacteria improve health and increase longevity. These bacteria included in foods such as yogurt.

Did you know?

More than 20 million Americans cite use of marijuana within the past 30 days, according to the National Survey on Drug Use and Health (NSDUH). More than 8 million admit to using it almost every day.

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Some mangrove islands in the Florida Keys, which number in the thousands, are convenient places to t Some mangrove islands in the Florida Keys, which number in the thousands, are convenient places to t
Cultures Ideal Body Types Cultures Ideal Body Types
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ... Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ...
A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ... A very light ideal spring stretches by when it is used to hang a 135-N object. What is the ...
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
Video: Semidiscontinuous DNA replication

For a complete list of videos, visit our video library