Modern Database Management, 11e (Hoffer et al.) Chapter 3 The Enhanced E-R Model and Business Rules
1) Which of the following is a generic entity type that has a relationship with one or more subtypes? A) Megatype B) Supertype C) Subgroup D) Class Answer: B Diff: 1 Page Ref: 113 Topic: Representing Supertypes and Subtypes AACSB: Use of Information Technology 2) Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload A) Define one vehicle entity type to hold all entities. B) Define a separate entity type for each entity. C) Define a supertype called vehicle and make each of the entities subtypes. D) Keep only the Truck entity type. Answer: A Diff: 1 Page Ref: 115 Topic: Representing Specialization and Generalization
Document information
- Uploaded on
- June 29, 2022
- Number of pages
- 33
- Written in
- 2021/2022
- Type
- Exam (elaborations)
- Contains
- Questions & answers