« previous next »

Author Question: Discuss the reasoning behind using supertype/subtype relationships. What will be an ideal ... (Read 331 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?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

Did you know?

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

Stevens-Johnson syndrome and Toxic Epidermal Necrolysis syndrome are life-threatening reactions that can result in death. Complications include permanent blindness, dry-eye syndrome, lung damage, photophobia, asthma, chronic obstructive pulmonary disease, permanent loss of nail beds, scarring of mucous membranes, arthritis, and chronic fatigue syndrome. Many patients' pores scar shut, causing them to retain heat.

Did you know?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Synapomorphies reveal the relationships among tetrapods Synapomorphies reveal the relationships among tetrapods
CS-US Relationships Predict Conditioning CS-US Relationships Predict Conditioning
The Effect of Group Size on Relationships The Effect of Group Size on Relationships
Human Relations: The Art and Science of Building Effective Relationships Human Relations: The Art and Science of Building Effective Relationships
For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately
Cladogram showing genetic distances and relationships between human populations Cladogram showing genetic distances and relationships between human populations
Video: Introduction to Cystic Fibrosis

For a complete list of videos, visit our video library