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


flexer1n1

  • Member
  • Posts: 373
Reply 3 on: Yesterday
Wow, this really help

 

Did you know?

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

Did you know?

A seasonal flu vaccine is the best way to reduce the chances you will get seasonal influenza and spread it to others.

Did you know?

The U.S. Preventive Services Task Force recommends that all women age 65 years of age or older should be screened with bone densitometry.

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

For a complete list of videos, visit our video library