Question: need answer please be fast 2 a) Design a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles, passenger cars, vans, and buses.

need answer please be fast 2 a) Design a

need answer please be fast

2 a) Design a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles, passenger cars, vans, and buses. Justify your placement of attributes at each level of the hierarchy. Justify their placement in higher or lower level hierarchy. i ii. Apply the disjoint and overlapping constraints. Consider a weak entity and try identifying it with an identifying entity. Apply the constraints of Generalization with user-defined and condition- defined constraints. b) Convert the following E-R diagram to relational schema han Employees Degends Note: Dependents is a Wesk Entity and Policy is the Weak Relationship

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!