« previous next »

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

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

A serious new warning has been established for pregnant women against taking ACE inhibitors during pregnancy. In the study, the risk of major birth defects in children whose mothers took ACE inhibitors during the first trimester was nearly three times higher than in children whose mothers didn't take ACE inhibitors. Physicians can prescribe alternative medications for pregnant women who have symptoms of high blood pressure.

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Relationships between direction of flow of blood and water or air in different vertebrates. Relationships between direction of flow of blood and water or air in different vertebrates.
Relationships and dates divergence of living primate group based on molecular and DNA comparisons. Relationships and dates divergence of living primate group based on molecular and DNA comparisons.
CS-US Relationships Predict Conditioning CS-US Relationships Predict Conditioning
The Effect of Group Size on Relationships The Effect of Group Size on Relationships
What are examples of ideal forms? What are examples of ideal forms?
Lab: Mass Relationships in Chemical Reaction Lab: Mass Relationships in Chemical Reaction
Video: Congenital Heart Defects Animation

For a complete list of videos, visit our video library