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

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

nummyann

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


samiel-sayed

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

 

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

One way to reduce acid reflux is to lose two or three pounds. Most people lose weight in the belly area first when they increase exercise, meaning that heartburn can be reduced quickly by this method.

Did you know?

A strange skin disease referred to as Morgellons has occurred in the southern United States and in California. Symptoms include slowly healing sores, joint pain, persistent fatigue, and a sensation of things crawling through the skin. Another symptom is strange-looking, threadlike extrusions coming out of the skin.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Did you know?

There are more bacteria in your mouth than there are people in the world.

For a complete list of videos, visit our video library