« previous next »

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

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

Bacteria have flourished on the earth for over three billion years. They were the first life forms on the planet.

Did you know?

The first-known contraceptive was crocodile dung, used in Egypt in 2000 BC. Condoms were also reportedly used, made of animal bladders or intestines.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

Possible symbiotic or endosymbiotic relationships that gave rise to the first eukaryotic cells Possible symbiotic or endosymbiotic relationships that gave rise to the first eukaryotic cells
Three possible phylogenies for the australopithecines with Au. anamnesis as the stem ancestor and re Three possible phylogenies for the australopithecines with Au. anamnesis as the stem ancestor and re
This chart illustrates the four quadrants in which we can place the relationships between the state This chart illustrates the four quadrants in which we can place the relationships between the state
Sibling relationships can be intense, in terms of both having fun together and engaging in conflict. Sibling relationships can be intense, in terms of both having fun together and engaging in conflict.
A Spatial Model of Reasoning A Spatial Model of Reasoning
Human Relations: The Art and Science of Building Effective Relationships Human Relations: The Art and Science of Building Effective Relationships
Video: Net filtration pressure and lymph formation, edema & blood velocity

For a complete list of videos, visit our video library