For the given business rule,  is the explanation for relationship and cardinality correct between PROFESSOR and COURSE below:  Business Rule: 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.   Relationship:  PROFESSOR “teaches” COURSE Relationship type:  1:MExplanation:  Business rules state, “Each course belongs to one and only one professor.  Each professor includes one or more courses”.  The PROFESSOR entity is on the “one” side of the relationship and the COURSE entity is on the “one or more” side of the relationship. Relationship participation: Mandatory on the “one” side of the relationship and mandatory on the “one or more” side of the relationship.Explanation:  The PROFESSOR entity is mandatory in the relationship because” Each course belongs to one and only one professor”.  The COURSE entity is mandatory in the relationship because “Each professor teaches one or more courses”, so a professor must teach at least one or more courses.  Cardinality:The cardinality of PROFESSOR is (1,1)The cardinality of COURSE is (1, N)

Question
Asked Nov 13, 2019
29 views

For the given business rule,  is the explanation for relationship and cardinality correct between PROFESSOR and COURSE below:  

Business Rule:

 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.

 

 

 

Relationship:  PROFESSOR “teaches” COURSE

 

Relationship type:  1:M

Explanation:  Business rules state, “Each course belongs to one and only one professor.  Each professor includes one or more courses”.  The PROFESSOR entity is on the “one” side of the relationship and the COURSE entity is on the “one or more” side of the relationship.

 

Relationship participation: Mandatory on the “one” side of the relationship and mandatory on the “one or more” side of the relationship.

Explanation:  The PROFESSOR entity is mandatory in the relationship because” Each course belongs to one and only one professor”.  The COURSE entity is mandatory in the relationship because “Each professor teaches one or more courses”, so a professor must teach at least one or more courses. 

 

Cardinality:

  • The cardinality of PROFESSOR is (1,1)
  • The cardinality of COURSE is (1, N)

 

 

 

check_circle

Expert Answer

Explanation for relationship

Here the relationship is PROFESSOR “teaches” COURSE. Business rule states that “Each course belongs to one and only one professor. Each professor cannot teach more than two courses”. The PROFESSOR entity is on the “one” side of the relationship. The PROFESSOR entity is ...

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: An uppercase character is a character whose ASCII value is between 65(A) and 90(Z). Write a C++ prog...

A: Following is the c++ program:For loop is used to from 0 to length of string to read every character ...

question_answer

Q: I am getting a floating point exception in my code. Which is to divide matrix 1 by matrix 2 (striaig...

A: Program Instructions:A floating-point exception occurs when an attempt is made to divide a number by...

question_answer

Q: This program is written in pseudocode."Design a program that asks the user to enter a store's sales ...

A: Create a C++ program and in the "main" method define an array with name "item" and define a macro wi...

question_answer

Q: Discuss the approaches used to categorize access control methodologies. Discuss the types of control...

A: Answer:Access control:Access control is a security technique that controls the admission of workers ...

question_answer

Q: Explain the difference in the C memory model between global and local variables. How is each allocat...

A: Variable :A variable is used in a program to store any data in the memory.The value stored in a vari...

question_answer

Q: Find the truth table that describes the following circuit.

A: The given circuit diagram shows operations for each gate. The final Boolean expression found through...

question_answer

Q: How often does garbage collection run on a DC? Group of answer choices 2 hours 6 hours 12 hours...

A: In this question a user must know about Garbage collection (GC) in the computer system:Garbage colle...

question_answer

Q: Using MIPS assembly language can someone help me write a program that does .. Write a program to fin...

A: Program Instructions:Ask the user for number of integers and get those integers.Load the array, redu...

question_answer

Q: Python 3.7.4 Open the file hostdata.txt for reading.

A: To open the file hostdata.txt for reading, the statement is: f=open('hostdata.txt','r')The following...