Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given that information below for an employer, create the complete crows foot ERD containing all primary keys, foreign keys, and main attributes. Hint: Add Overlapping
Given that information below for an employer, create the complete crows foot ERD
containing all primary keys, foreign keys, and main attributes. Hint: Add
OverlappingDisjoint supersubtypes as needed
An employee could be staff or a professor or an administrator.
A professor may also be an administrator.
Staff employees have a work level classification, such a Level I and Level II
Only professors can chair a department. A department is chaired by only one
professor.
Only professors can serve as the dean of a college. Each of the universitys
colleges is served by one dean.
A professor can teach many classes.
Administrators have a position title.
Some staff employees are information technology IT personnel.
Some IT personnel provide technology support for academic programs.
Some IT personnel provide technology infrastructure support.
Some IT personnel provide technology support for academic programs and
technology infrastructure support.
IT personnel are not professors.
IT personnel are required to take periodic training to retain their technical
expertise.
The employer tracks all IT personnel training by date, type, and results
completed vs not completed
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started