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

70.2K

Verified Solution

Question

Programming

You are creating an enhanced entity-relationship model for acampus information system. A junior team member who is helping youasks you to describe the following terms with examples of relevantentities from the system, for example, students, activities etc.
1. Supertype and Subtype
2. Disjoint and Overlapping Discriminator
3. Total and Partial Completeness
4. Attribute Inheritance

Answer & Explanation Solved by verified expert

4.3 Ratings (890 Votes)

1Supertype and Subtype Supertype is an entity type that has got relationship parent to child relationship with one or more subtypes and it contains attributes that are common to its subtypes Subtypes are subgroups of the supertype entity and have unique attributes but they will be different from each subtype For example Examination is a supertype of QUIZ TERM examination and FINAL examination subtypeextra points for 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