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.

Question
Asked Oct 2, 2019
105 views
  1. 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.

check_circle

Expert Answer

Step 1

The fully labelled Crow's Foot ERD using a specialization hierarchy is given below. The ERD...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.

Related Computer Science Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: How would I go about writing the code in the problem in the picture?

A: Program AlgorithmCreate a class Prime_Numbers and define the main() function.Initialize the required...

question_answer

Q: How would I go about writing this program?

A: Create a class and get int type data from a user, to print the number of lines on console.Use three ...

question_answer

Q: Create a recursive store function called add_numbers to calculate the total of all consecutive posit...

A: As there is no specific programming language mentioned, so we are creating this program in C program...

question_answer

Q: The following data fragment occurs in the middle of a data stream for which the byte-stuffing algori...

A: Byte stuffing algorithm, also referred as Character stuffing algorithm was invented to overcome the ...

question_answer

Q: Construct npda that accept the following languages on Σ = {a, b, c}: L = {wcwR : w ∈ {a, b}∗}.

A: Non-deterministic pushdown automaton (NPDA):Given: L = {wcwR : w ∈ {a, b}∗}To construct NPDA, when “...

question_answer

Q: (check all that apply) The ER model for a small bank system has Customer, Account, CheckingAccount, ...

A: The answer is option D - Employees and their supervisors.

question_answer

Q: Using the gate diagram below, create an equivalent Boolean equation along with a truth table.Simplif...

A: As given in the gate diagram,there are following gates are used:NOT gateAND gateOR gateXOR gateYou c...

question_answer

Q: Transform the grammar S → aSaaA|A, A → abA|bb into Chomsky normal form.

A:  For solving your problem , first of all we will discuss about  algorithm to convert grammar into  C...

question_answer

Q: I am trying ro create this java program , i have the table in my tatabase . I am using postgresql ii...

A: Program Instructions:Add the postgresql jar file in your project library.Create a database and a tab...