Author Question: When selecting an identifier, one should: A) use intelligent keys. B) use large composite keys ... (Read 140 times)

folubunmi

  • Hero Member
  • *****
  • Posts: 524
When selecting an identifier, one should:
 
  A) use intelligent keys.
  B) use large composite keys instead of single-attribute surrogate keys.
  C) choose a candidate key that will not change its value over the life of each instance of the entity type.
  D) choose a candidate key such that for each instance of the entity, the attribute is guaranteed to have valid values or is null.
  E) choose a candidate key that allows for duplicate values.

Question 2

On a data-flow diagram, you may:
 
  A) repeat data stores and processes.
  B) repeat sources/sinks and processes.
  C) only repeat processes.
  D) repeat relationships.
  E) repeat both data stores and sources/sinks.



mtmmmmmk

  • Sr. Member
  • ****
  • Posts: 335
Answer to Question 1

C
Explanation: C) An identifier uniquely identifies an entity instance. Because of this role, it cannot be null.
CL

Answer to Question 2

E
Explanation: E) While you may repeat data stores, sinks and sources, there is no reason to have two processes with the same name.
CL



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Atropine was named after the Greek goddess Atropos, the oldest and ugliest of the three sisters known as the Fates, who controlled the destiny of men.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

The U.S. Pharmacopeia Medication Errors Reporting Program states that approximately 50% of all medication errors involve insulin.

For a complete list of videos, visit our video library