Hello,Just want to check if the attached Crow's Foot ERD is correct for the following problem: 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.Extracted text: SCHOOL CODE SCHOOL SCHOOL CHAIR UNIVERSITY headed by ADDRESS ΕMPLOYΕ UNIVERSITY_CODE ADDRESS EMPLOYEE ID NAME

Hello, Just want to check if the attached Crow's Foot ERD is correct for the following problem: Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy...

Hello,

Just want to check if the attached Crow's Foot ERD is correct for the following problem:

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.

Extracted text: SCHOOL CODE SCHOOL SCHOOL CHAIR UNIVERSITY headed by ADDRESS ΕMPLOYΕ UNIVERSITY_CODE ADDRESS EMPLOYEE ID NAME

Jun 02, 2022