« previous next »

Author Question: Discuss the reasoning behind using supertype/subtype relationships. What will be an ideal ... (Read 433 times)

leo leo

  • Hero Member
  • *****
  • Posts: 566
on: Jul 7, 2018
Discuss the reasoning behind using supertype/subtype relationships.
 
  What will be an ideal response?

Question 2

NoSQL focuses on avoidance of replication and minimizing storage space.
 
  Indicate whether the statement is true or false
Modern Database Management ¦ Hoffer, Venkataraman, Topi ¦ 13th Edition
Buy Test-Bank


6ana001

  • Sr. Member
  • ****
  • Posts: 311
Reply #1 on: Jul 7, 2018
Answer to Question 1

It is best to use a supertype/subtype hierarchy when there are attributes that apply to some but not all instances of an entity type. For example, if we have an employee entity type and there is an hourly wage attribute that only applies to hourly employees, it may be best to use a supertype/subtype relationship. Another reason for using supertype/subtype relationships is when you have instances of a subtype that participate in a relationship unique to that subtype. For example, if we have a contractor subtype of employee that has a relationship with staffing agency, then it would be best to use supertype/subtype relationship.

Answer to Question 2

FALSE


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

The senior population grows every year. Seniors older than 65 years of age now comprise more than 13% of the total population. However, women outlive men. In the 85-and-over age group, there are only 45 men to every 100 women.

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Scattergrams are a mechanism used by political scientists to show patterns and relationships among v Scattergrams are a mechanism used by political scientists to show patterns and relationships among v
CS-US Relationships Predict Conditioning CS-US Relationships Predict Conditioning
Dew point/temperature relationships in (a) unsaturated air and saturated air (b and c). Dew point/temperature relationships in (a) unsaturated air and saturated air (b and c).
Relationships in Dyads and Triads Relationships in Dyads and Triads
Discuss the trend you notice about enbridge inc Discuss the trend you notice about enbridge inc
Cladogram showing genetic distances and relationships between human populations Cladogram showing genetic distances and relationships between human populations
Video: Passive Smoke Exposure

For a complete list of videos, visit our video library