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 69 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
:D TYSM

diana chang

  • Member
  • Posts: 288
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

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?

When blood is deoxygenated and flowing back to the heart through the veins, it is dark reddish-blue in color. Blood in the arteries that is oxygenated and flowing out to the body is bright red. Whereas arterial blood comes out in spurts, venous blood flows.

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

An example of color blindness test. A person with red-green color blindness would not be able to dis An example of color blindness test. A person with red-green color blindness would not be able to dis
Cultures Ideal Body Types Cultures Ideal Body Types
What are examples of ideal forms? What are examples of ideal forms?
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: Control of ventilation rate by other brain centers (posts, hypothalamus & cerebral cortex)

For a complete list of videos, visit our video library