Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: A large university consists of several schools. Each school is chaired by one employee. An employee may be the dean of one and only one school. All employees are classified into three categories: Professors, Administrators, and Staff. A professor may also be an administrator.The university wants to record the following data for all employees: ID, full name, and address. In addition, the university wants to include data that are peculiar to each category. The list of such attributes includes but is not limited to the following: the highest degree earned by a professor, the title of an administrator, and hourly rate for staff.Each professor is assigned to either teaching or research position but not both. For professors teaching classes, the university wants to keep track of the number of classes taught and the average rating. For professors working on research, the total amount of grant money received must be included.
- Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows:
A large university consists of several schools. Each school is chaired by one employee. An employee may be the dean of one and only one school. All employees are classified into three categories: Professors, Administrators, and Staff. A professor may also be an administrator.The university wants to record the following data for all employees: ID, full name, and address. In addition, the university wants to include data that are peculiar to each category. The list of such attributes includes but is not limited to the following: the highest degree earned by a professor, the title of an administrator, and hourly rate for staff.Each professor is assigned to either teaching or research position but not both. For professors teaching classes, the university wants to keep track of the number of classes taught and the average rating. For professors working on research, the total amount of grant money received must be included.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
