Author Question: When selecting an identifier, one should: A) use intelligent keys. B) use large composite keys ... (Read 75 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?

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

Did you know?

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

For a complete list of videos, visit our video library