Design an Enhanced Entity Relationship diagram (EERD) by referring the below given scenario. Use appropriate notations and names to draw the diagram. Scenario All EMPLOYEESs working in the University of Technology and Applied Sciences are grouped into ACADEMICS and ADMIN_STAFFs. An Admin_staff cannot be considered as Academics. An Employee is Identified with a EmpCode, Academic is having a specific attribute Degree and a Status is assigned to an Admin_Staff. Some of the Academics are further classified as LECTURER and PROFESSOR. LrsCode is a specific attribute for a Lecturer and PrfCode is a specific for a Professor. Lecturers can be considered as Professors after a few years of experience. 2. Design an Enhanced Entity Relationship diagram (EERD) byreferring the below given scenario.and names to draw the diagram.Use appropriate notationsScenarioAll EMPLOYEESS working in the University of Technologyand Applied Sciences are grouped into ACADEMICS andADMIN_STAFFS. An Admin_staff cannot be considered asAcademics. An Employee is Identified with a EmpCode,Academic is having a specific attribute Degree and a Status isassigned to an Admin_Staff. Some of the Academics are furtherclassified as LECTURER and PROFESSOR. LrsCode is aspecific attribute for a Lecturer and PrfCode is a specific for aProfessor. Lecturers can be considered as Professors after a fewyears of experience.

Objective: An Enhanced ERD should be designed for all the employees working in a technical…

Answered: Design an Enhanced Entity Relationship…

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

Design an Enhanced Entity Relationship diagram (EERD) by referring the below given scenario. Use appropriate notations and names to draw the diagram. Scenario All EMPLOYEESs working in the University of Technology and Applied Sciences are grouped into ACADEMICS and ADMIN_STAFFs. An Admin_staff cannot be considered as Academics. An Employee is Identified with a EmpCode, Academic is having a specific attribute Degree and a Status is assigned to an Admin_Staff. Some of the Academics are further classified as LECTURER and PROFESSOR. LrsCode is a specific attribute for a Lecturer and PrfCode is a specific for a Professor. Lecturers can be considered as Professors after a few years of experience.

2. Design an Enhanced Entity Relationship diagram (EERD) by
referring the below given scenario.
and names to draw the diagram.
Use appropriate notations
Scenario
All EMPLOYEESS working in the University of Technology
and Applied Sciences are grouped into ACADEMICS and
ADMIN_STAFFS. An Admin_staff cannot be considered as
Academics. An Employee is Identified with a EmpCode,
Academic is having a specific attribute Degree and a Status is
assigned to an Admin_Staff. Some of the Academics are further
classified as LECTURER and PROFESSOR. LrsCode is a
specific attribute for a Lecturer and PrfCode is a specific for a
Professor. Lecturers can be considered as Professors after a few
years of experience.

Expert Solution

Step by step

Solved in 2 steps with 1 images

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