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

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Did you know?

The first monoclonal antibodies were made exclusively from mouse cells. Some are now fully human, which means they are likely to be safer and may be more effective than older monoclonal antibodies.

Did you know?

People with high total cholesterol have about two times the risk for heart disease as people with ideal levels.

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

For a complete list of videos, visit our video library