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

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

Most strokes are caused when blood clots move to a blood vessel in the brain and block blood flow to that area. Thrombolytic therapy can be used to dissolve the clot quickly. If given within 3 hours of the first stroke symptoms, this therapy can help limit stroke damage and disability.

Did you know?

More than 4.4billion prescriptions were dispensed within the United States in 2016.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

Thyroid conditions may make getting pregnant impossible.

For a complete list of videos, visit our video library