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
44 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

Step 1

The entities, primary keys and foreign keys and attributes of ERD are:

help_outline

Image Transcriptionclose

attributes Entity Primary keys Foreign keys university id University_name university School id School School_name university_id Deptartment id School_id Department Department_name professors id Deptartment_id Professor_name Professor specility course_name Course description professors Course id professors_id Courses

fullscreen
Step 2

Cardinalities betwe...

help_outline

Image Transcriptionclose

Entity Relationship Cardinalities Entity School university HAS 1:M School HAS 1:M Department Department Belongs to 1:1 School professors Department HAS 1:M professors Teach 1:M Courses

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

Databases

Related Computer Science Q&A

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

Q: Write a loop that sets newScores to oldScores shifted once left, with element 0 copied to the end. E...

A: oldScores is an integer type array that stores 4 value.newScores is an integer type array that copy ...

question_answer

Q: Python 3.7.4 Write a statement that associates s with the empty set.

A: Set:A set is a list of unranked data items, in python data items can be added or removed in a set.Em...

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: I am working in eclipse to find 3 ingredients from user, how many cups per ingredient and then add t...

A: The java program obeys the following rubrics: -Importing the essential headers.In main method – Decl...

question_answer

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

A: The gates involved in the given circuits are:AND gate between Y and X.XNOR gate between Y and ~Z whi...

question_answer

Q: 2)   Consider the following class   class Department { private: string name; const long locationNo; ...

A: Program descriptionThe class definition has the declarations of the static variables, regular variab...

question_answer

Q: 2. What are the differences between the top-down and bottom-up approaches to information security?Wh...

A: What are the differences between the top-down and bottom-up approaches to information security?Why i...

question_answer

Q: what are the mantissa and exponent values if 6.75 is represented in 8-bit binary floating point repr...

A: Conversion of decimal to 8-bit floating point representation:Step 1: Convert the integer part of the...

question_answer

Q: Even though the employees in the Cisco systems have doubled, STs remains the same. Why? And how it h...

A: Cisco systemsCisco systems develop, manufactures and sells networking hardware, telecommunications e...