Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ExcelCollege has many departments such as computer science, business administration and social science. Each department)has many (employees) which includes technical staffs, administrators, and lecturers. Technical

image text in transcribed

ExcelCollege has many departments such as computer science, business administration and social science. Each department)has many (employees) which includes technical staffs, administrators, and lecturers. Technical staffs have a work level classification, such as level 1 for technicians and level 2 for IT officers. Administrators have a position title. The lecturers also consist of three different ranks which is senior lecturer, associate professor, and professor. The lecturers are required to state their research area of expertise. Other than that, all employees have the basic attributes such as employee ID, employee name and employee date of birth. Draw an extended entity relationship (EER) diagram based on the scenario above. You are required to use specialization hierarchy whichever appropriate. Make sure you identify and include all primary keys and foreign keys where appropriate

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle Database Foundations Technology Fundamentals For IT Success

Authors: Bob Bryla

1st Edition

0782143725, 9780782143720

More Books

Students also viewed these Databases questions