Q.4.

4.1. 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. Explain why they should not be placed at a higher or lower level.

4.2. Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number, room-number, and time. Alternatively, one or more additional entity sets could be defined, along with relationship sets to replace some of the attributes of the exam entity set, as

course with attributes name, department, and c-number

section with attributes s-number and enrollment, and dependent as a weak entity set on course

room with attributes r-number, capacity, and building Show an E-R diagram illustrating the use of all three additional entity sets listed.

Question 04 12-10 - 20 Marks 4.1. Design a generalization-specialization Bierarchy for a motorile sales company. The company sells motorcycles, passenger cars, vans, and buses. Justify your placement of attributes at each level of the hierarchy. Explain why they should not be placed at a higher or lower level 4.2. Coudera university database for the scheduling of classroom for finalem. This database could be modeled as the single entity set um, with tribes course-me, section-cumber, room-number, and time. Alternatively, one or more additional entity sets could be defined along with relationship sets to replace some of the botes of the amenity course with writes, department, and amber section with state-rindenrollment, and dependent as weakently encore "room with the copy, and building Show an IR diagram illustrating the use of all three ditional entity sets listed