Author Question: Which of the following is not true about representing subtypes in a relational database design? ... (Read 24 times)

craiczarry

  • Hero Member
  • *****
  • Posts: 527
Which of the following is not true about representing subtypes in a relational database design?
 
  A) One table is created for the supertype and one for each subtype.
  B) All of the attributes of the supertype are added to the subtype relations.
  C) The key of the supertype is made the key of the subtypes.
  D) An instance of the supertype may be related to one instance each of several subtypes.

Question 2

When running an SQL query that uses NOT EXISTS, the NOT EXISTS keyword will be true if ________.
 
  A) any row in the subquery meets the condition
  B) all rows in the subquery meet the condition
  C) no row in the subquery meets the condition
  D) any row in the subquery fails to meet the condition



Jody Vaughn

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

B

Answer to Question 2

C



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

In 1885, the Lloyd Manufacturing Company of Albany, New York, promoted and sold "Cocaine Toothache Drops" at 15 cents per bottle! In 1914, the Harrison Narcotic Act brought the sale and distribution of this drug under federal control.

Did you know?

The FDA recognizes 118 routes of administration.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

For a complete list of videos, visit our video library