DB3a1-1-2(1)

docx

School

New Jersey Institute Of Technology *

*We aren’t endorsed by this school

Course

331

Subject

Computer Science

Date

Jan 9, 2024

Type

docx

Pages

10

Uploaded by ProfessorReindeer1238

Report
Jeet Patel CS 331 103 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 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. 3) The property by which subtype entities possess the values of all attributes of a supertype is called: A) hierarchy reception. B) class management. C) attribute inheritance. D) generalization.
4) Subtypes should be used when: A) there are attributes that apply to some but not all instances of an entity type. B) supertypes relate to objects outside the business. C) the instances of a subtype do not participate in a relationship that is unique to that subtype. D) none of the above. 5) In the figure below, which of the following are subtypes of patient? A) Outpatient B) Physician C) Bed D) All of the above 6) The process of defining one or more subtypes of a supertype and forming relationships is called: A) specialization. B) generalization. C) creating discord. D) selecting classes. 7) In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized?
A) Make B) Vehicle C) Model D) Price 8) The process of defining a more general entity type from a set of more specialized entity types is called: A) generalization. B) specialization. C) normalization. D) none of the above.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
9) Which of the following is a completeness constraint? A) Total specialization B) Partial generalization C) Total recall D) Partial hybridization 10) The following figure is an example of: A) partial specialization. B) completeness. C) total specialization. D) disjointness. 11) The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype. A) semi-specialization B) total specialization C) partial specialization D) disjointedness
12) The following figure is an example of: A) partial specialization. B) disjoint completeness. C) total specialization. D) transunion constraint. 13) The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship. A) semi-specialization B) total specialization C) partial specialization D) total convergence 14) A ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype. A) disjoint B) overlap C) completeness D) weak
15) In the figure below, a student: A) must be a graduate student, an undergraduate, a special student or some other type of student. B) must be a graduate student or an undergraduate student. C) must be at least a special student. D) none of the above. 16) The ________ rule specifies that an entity can be a member of only one subtype at a time. A) exclusion B) disjoint C) removal D) inclusion 17) A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes. A) disjointedness constraint B) disjoint rule C) partial specialization D) total specialization 18) In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ________ rule.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
A) disjoint B) specialization C) generalization D) overlap
19) Which of the following statements is true about the figure shown below? A) A rental unit must be either an apartment or a house, and cannot be both at the same time. B) A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time. C) A rental unit must be either an apartment or a house, and could be both. D) A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time.
20) Which of the following statements is true about the figure shown below? A) A rental unit must be either an apartment or a house, and cannot be both at the same time. B) A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time. C) A rental unit must be either an apartment or a house, and could be both. D) A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Part2: 1) Explain why the E-R model needed to be expanded into the enhanced E-R model. I would say that the expanded enhanced E-R model can be use in a hire corporate entities. EER is a high data model that incorpotes the extension of their original ER model. 2) Explain the terms subtype and supertype. Discuss the differences between them. Subtype uses unique entities of that organization and supertype can use entity that has a relationship with one or more subtypes. Subtype can use all the attributes that the supertype can have. 3) Compare and contrast generalization and specialization. Generalization involves multiple entities and combines them into a together group and on the other end specialization can uses a single entity broken into many sub groups. 4) Discuss the reasoning behind using supertype/subtype relationships. While supporting type-specific characteristics, relationships, and integrity requirements, subtypes enable us to unify common attributes, relationships, and integrity for numerous entity sets. 5) Discuss when one would use total specialization and when one would use partial specialization. According to the entire specialization rule, every member of the superclass must belong to a subclass. Total specialization is represented by a double line connection between entities, much like in a standard ERD.

Related Documents

ITT 370 Topic 2 DQ1.docx
Database Optimization and Performance Tuning Paper COMPLETE.docx
Term Group Project Deliverable 1.docx
workshop_9.pdf
ALU Lab.docx
DBch5a (1)-1-1(1).docx
CS331Prac1.docx
Homework 7.pdf
HW5.pdf
homework3.pdf
Quiz 2.docx
Midterm Exam Note.docx
Recommended textbooks for you
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
C++ Programming: From Problem Analysis to Program...
Computer Science
ISBN:9781337102087
Author:D. S. Malik
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
Text book image
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
C++ Programming: From Problem Analysis to Program...
Computer Science
ISBN:9781337102087
Author:D. S. Malik
Publisher:Cengage Learning
SEE MORE TEXTBOOKS