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

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

Did you know?

Most fungi that pathogenically affect humans live in soil. If a person is not healthy, has an open wound, or is immunocompromised, a fungal infection can be very aggressive.

Did you know?

A cataract is a clouding of the eyes' natural lens. As we age, some clouding of the lens may occur. The first sign of a cataract is usually blurry vision. Although glasses and other visual aids may at first help a person with cataracts, surgery may become inevitable. Cataract surgery is very successful in restoring vision, and it is the most frequently performed surgery in the United States.

For a complete list of videos, visit our video library