A specialization hierarchy depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →1. A specialization hierarchy depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities). Entity supertype contains the common characteristics and the entity subtypes contain the unique characteristics of each entity subtype.
Example: EMPLOYEE supertype and three entity subtypes—PILOT, MECHANIC, and ACCOUNTANT.
· Write the business rules
· Enter sample data to demonstrate inheritance.
2. In a university environment, an employee may be a professor or an administrator.
· Write the business rules
· Draw the ERD showing the inheritance relationship between the super type and sub type entities with appropriate attributes, PKs and foreign key
· Enter sample data to demonstrate inheritance.
3. In a university environment, a student may be a GRAD or UNDERGRAD.
· Write the business rules
· Draw the ERD showing the inheritance relationship between the super type and sub type entities with appropriate attributes, PKs and foreign key
· Enter sample data to demonstrate inheritance.
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds
