Given the following business rules, define the relationships between entities and identify cardinalities: A university is divided into many schools. Each school has many departments, where each department belongs to one and only one school.  Each department should have one or more professors assigned to it, where each professor cannot teach more than two courses.  The university wants to record the following data for all professors: professor number and full name.  All courses are classified into two categories: Fashion and Technology.

Question
Asked Nov 13, 2019
99 views

Given the following business rules, define the relationships between entities and identify cardinalities:

 

A university is divided into many schools. Each school has many departments, where each department belongs to one and only one school.  Each department should have one or more professors assigned to it, where each professor cannot teach more than two courses.  The university wants to record the following data for all professors: professor number and full name.  All courses are classified into two categories: Fashion and Technology.

check_circle

Expert Answer

Step 1

Entity-Relationship (ER) diagram:

The following ER diagram defines the cardinalities and relationships between the entities.

help_outline

Image Transcriptionclose

Univ_ID Univ_Name School_ID School_Name Location Location М divided into University School Prof No Records has Prof Name Prof_Name Phone_No М Department Professor have 1-M Prof No Dept_Name Dept_ID teaches 1.2 Courses Course_Name Course_Code Technology Fashion

fullscreen
Step 2

The symbols used in the above ER...

help_outline

Image Transcriptionclose

Symbols Description Defines relationship Defines attributes Defines entity

fullscreen

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.
Tagged in

Engineering

Computer Science

Related Computer Science Q&A

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

Q: Computer Science Question

A: Note: As per the guidelines Q1 with three sub-parts can be answered. Re-post the question for the so...

question_answer

Q: 4.7: Time Machine Your time machine is capable of going forward in time up to 24 hours. The machine ...

A: Following is the c++ program that takes start time and future time as input from user and finally pr...

question_answer

Q: The essential condition of third normal form is automatically satisfied whenA) a table has only one ...

A: To solve this question a user have to know the definition of Third Normal Form (3NF):Third Normal Fo...

question_answer

Q: Python 3.7.4 Use the file object output to write the string "3.14159" to a file called pi.

A: Following is the program code which writes the string "3.14159" to a file called pi.To open a file c...

question_answer

Q: In Python Use the Design Recipe to write a function round_list, which consumes two arguments, a list...

A: Program Instructions:Write the function header and type contrast of the program.Write description an...

question_answer

Q: Python 3.7.4 Write a statement to open the file priceList.txt for writing.

A: To open the file priceList.txt for writing, the statement is: f=open('priceList.txt','w')The followi...

question_answer

Q: Problem 1 A. Consider the following recursive method. def foo1(n):
      if n == 2:           retur...

A: a.Complete Python Program: #Recursive Function foo1() which accepts a parameter ndef foo1(n):       ...

question_answer

Q: What are the benefits of using a vector over an array?

A: Vector - It is a data structure used to store data.Vectors can be implemented as dynamic arrays with...

question_answer

Q: Write a wholly creative quiz program that consists of three original questions that you make up acco...

A: Error in the program-Remove the points variable after each fragment of code except the point variabl...