Given the follwing business rules, create an ERD.  The ERD must include all primary keys, foreign keys, attributes, cardinalities.  Also consider relational strengths (dashed lines or solid lines) :  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 11, 2019
81 views

Given the follwing business rules, create an ERD.  The ERD must include all primary keys, foreign keys, attributes, cardinalities.  Also consider relational strengths (dashed lines or solid lines) :  

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

ER diagram:

...
Uni Name
schl Name
Uni Num
schl Num
location
location
M
University
divided into
School
Prof Num
Prof Name
contains
геcords
Prof Name
Prof Num
м
name
1 Mi
Department
Professor
have
Phone
COurse ID
dept ID
course_Name)
1.2
Course
teaches
duration
Fashion
Technology
help_outline

Image Transcriptionclose

Uni Name schl Name Uni Num schl Num location location M University divided into School Prof Num Prof Name contains геcords Prof Name Prof Num м name 1 Mi Department Professor have Phone COurse ID dept ID course_Name) 1.2 Course teaches duration Fashion Technology

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: Given a nested list named NxN_table that represents a table with N rows and N columns, print each el...

A: Program Instructions:Store the 3 sub lists of 3 elements in the list nested list NxN_table.Use a for...

question_answer

Q: Using C++ 11 Write a program which overloads fractions arithmetic operations for division. And inclu...

A: To write a program which overloads fractions arithmetic operation for division add the following mai...

question_answer

Q: You will write 4 classes for Program 5.  Assignment:The BankAccount class models an account of a cus...

A: Java Program:Filename :- BankAccount.java// Import the required packageimport java.util.Date;// Clas...

question_answer

Q: Some system analysts maintain that source doucments are unnecessary. They say that all input cab be ...

A: “Yes”, any user can agree with the given statement.

question_answer

Q: 8. Write a C++ program to find the sum of all odd integers from 1 to 99, and the sum of their cubes.

A: To solve this question following variables and loop should be required:Variables: total, num, and cu...

question_answer

Q: How can I fix that Traceback (most recent call last):  File "C:\Users\Richard Seegerer\Documents\Pyt...

A: Here you are trying to open a file name module.txt in reading only format. You are utilizing a relat...

question_answer

Q: An administrator has received a call indicating that some users are having difficulty logging on aft...

A: Domain Controller:Domain controller is a server computer on Microsoft servers.The purpose of domain ...

question_answer

Q: Write a program (IN C++) that will present the user with a main menu of options which the user can c...

A: Click to see the answer

question_answer

Q: In Python use the Design Recipe to write a function,  count_odds, that consumes a list and two integ...

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