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

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

Did you know?

More than 50% of American adults have oral herpes, which is commonly known as "cold sores" or "fever blisters." The herpes virus can be active on the skin surface without showing any signs or causing any symptoms.

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

If you could remove all of your skin, it would weigh up to 5 pounds.

For a complete list of videos, visit our video library