Database systemItems Supervisor, Teacher, Year, Graduate, Student, Ungraduate.Consider subtype-supertype structure for above items and answer the following a) Define supertype and subtypes.b)Define correctly some attributes for supertype and subtypes.c) Check supertype-subtype structure if it is correctly defined.d) Define one relationship for supertype-subtype. Regarding to questions related to Entity Relationship Diagram, all answenshould use the similar writing notations for ERD provided below;ERD1This ERD will be written as;Entity ve AtrributesENTITY A (# id, * atr1, o atr2)ENTITY B (# nbr, * atr_1, * atr_2)Relationship (by using ERDish)Each Entity-A Optionality Relationship_Name Cardinality Entity-BEach Entity-B Optionality Relationship_Name Cardinality Entity-AERDZThis ERD must be shown as;SUPERTYPE: A (defining attributes with correct optionality)SUBTYPE: B (defining attributes with correct optionality)SUBTYPE: C (defining attributes with correct optionality)Items: Supervisor, Teacher, Year, Graduate, Student, Undergraduate

A subtype is a subgrouping of the entities in an entity type that is meaningful to the organization.…

Answered: a) Define supertype and subtypes.…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

Database system Items Supervisor, Teacher, Year, Graduate, Student, Ungraduate. Consider subtype-supertype structure for above items and answer the following a) Define supertype and subtypes. b)Define correctly some attributes for supertype and subtypes. c) Check supertype-subtype structure if it is correctly defined. d) Define one relationship for supertype-subtype.

Regarding to questions related to Entity Relationship Diagram, all answen
should use the similar writing notations for ERD provided below;
ERD1
This ERD will be written as;
Entity ve Atrributes
ENTITY A (# id, * atr1, o atr2)
ENTITY B (# nbr, * atr_1, * atr_2)
Relationship (by using ERDish)
Each Entity-A Optionality Relationship_Name Cardinality Entity-B
Each Entity-B Optionality Relationship_Name Cardinality Entity-A
ERDZ
This ERD must be shown as;
SUPERTYPE: A (defining attributes with correct optionality)
SUBTYPE: B (defining attributes with correct optionality)
SUBTYPE: C (defining attributes with correct optionality)
Items: Supervisor, Teacher, Year, Graduate, Student, Undergraduate

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions