Supertype entities - Study guides, Class notes & Summaries

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, NoWheel...

Answers to Review Questions 1. Name and discuss the different levels of data abstraction as defined by ANSI/SPARC. Conceptual Located at the abstraction apex, the conceptual model represents a global view of the data. It forms the basis of the conceptual schema, which provides a relatively easily understood bird's-eye view of the data environment. Since the conceptual model focuses on the main data objects and avoids detail, it exhibits both software and hardware independence. The most ...