Author Question: Which of the following is not true about representing subtypes in a relational database design? ... (Read 51 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?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.

Did you know?

Tobacco depletes the body of vitamins A, C, and E, which can result in any of the following: dry hair, dry skin, dry eyes, poor growth, night blindness, abscesses, insomnia, fatigue, reproductive system problems, sinusitis, pneumonia, frequent respiratory problems, skin disorders, weight loss, rickets, osteomalacia, nervousness, muscle spasms, leg cramps, extremity numbness, bone malformations, decayed teeth, difficulty in walking, irritability, restlessness, profuse sweating, increased uric acid (gout), joint damage, damaged red blood cells, destruction of nerves, infertility, miscarriage, and many types of cancer.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

Asthma-like symptoms were first recorded about 3,500 years ago in Egypt. The first manuscript specifically written about asthma was in the year 1190, describing a condition characterized by sudden breathlessness. The treatments listed in this manuscript include chicken soup, herbs, and sexual abstinence.

For a complete list of videos, visit our video library