You are creating an enhanced entity relationship model for a campus information system. A junior team member...

90.2K

Verified Solution

Question

Programming

You are creating anenhanced entity relationship model for a campus information system.A junior team member who is helping you asks you to describe thefollowing terms with examples of relevant entities from the system,for example, students, activities etc.
1.Â Â Â Â Â Â Â Supertype andSubtype
2.Â Â Â Â Â Â Â Disjoint andOverlapping Discriminator
3.Â Â Â Â Â Â Â Total and PartialCompleteness
4.Â Â Â Â Â Â Â AttributeInheritance

Answer & Explanation Solved by verified expert

4.0 Ratings (531 Votes)

Supertype and Subtype in Entity Relationship Model ERModel It can considered as a Extended Entity Relationship Model An Introduction It is the Result of adding more more semantic constructs to the original entity relationship ER model Its a Diagram based Using this model is called an Enhanced ER Diagram or EER diagram EERD It Cartels nearly of the Objectoriented notions along with Entity Relationship notions About Entity Supertypes Subtypes Entity supertype Its a Generic entity type related to one or more entity based subtypes It Contains common characteristics like Entity subtype It contains some exclusive features of every entity subtype and also it is used to keep a side unnecessary nullo See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member