« previous next »

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

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?

Fewer than 10% of babies are born on their exact due dates, 50% are born within 1 week of the due date, and 90% are born within 2 weeks of the date.

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Edward Bellamy, author of the utopian novel Looking Backward (1888) Bellamy’s socialism worried many Edward Bellamy, author of the utopian novel Looking Backward (1888) Bellamy’s socialism worried many
CS-US Relationships Predict Conditioning CS-US Relationships Predict Conditioning
Bronfenbrenner was interested in bidirectional relationships between different levels of the ... Bronfenbrenner was interested in bidirectional relationships between different levels of the ...
Stereochemical relationships of the D-aldoses Stereochemical relationships of the D-aldoses
Middle adults usually have more time to focus attention on their relationships Middle adults usually have more time to focus attention on their relationships
Relationships among Jawed Vertebrates Relationships among Jawed Vertebrates
Video: Brain Anatomy Animation (Part 1 of 2)

For a complete list of videos, visit our video library