In your group, you will need to create an entity relation (E-R) diagram using the Crow's foot symbols that models the problem. This will include:Summarise the ERM's components, and names the entities and their relationship (As given in the Textbook, p.143, Table 4.4)all entities, relationships (including names) and attributes that are relevant,primary keys identified, andinclude relationship participation - participation (optional / mandatory) symbols and cardinality.The E-R diagram should be completed using the standards of this unit. Use Microsoft Visio to create the E-R diagram. Table 4.4Components of the ERMEntityRelationshipConnectivity EntitySCHOOLoperates1:MDEPARTMENTDEPARTMENThas1:MSTUDENTDEPARTMENTemploys1:MPROFESSORDEPARTMENToffers1:MCOURSECOURSEgenerates1:MCLASSSEMESTERincludes1:MCLASSPROFESSORis dean of1:1SCHOOLPROFESSORchairs1:1DEPARTMENTPROFESSORteaches1:MCLASSPROFESSORadvises1:MSTUDENTSTUDENTenrolls inM:NCLASSBUILDINGcontains1:MROOMROOMis used for1:MCLASSNote: ENROLL is the composite entity that implements theM:N relationship "STUDENT enrolls in CLASS."

Given, The answer is given below Note: As Microsoft Visio is paid software(Unavailable freely). so,…

Answered: In your group, you will need to create…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

In your group, you will need to create an entity relation (E-R) diagram using the Crow's foot symbols that models the problem. This will include:

Summarise the ERM's components, and names the entities and their relationship (As given in the Textbook, p.143, Table 4.4)
all entities, relationships (including names) and attributes that are relevant,
primary keys identified, and
include relationship participation - participation (optional / mandatory) symbols and cardinality.

The E-R diagram should be completed using the standards of this unit. Use Microsoft Visio to create the E-R diagram.

Table 4.4
Components of the ERM
Entity
Relationship
Connectivity Entity
SCHOOL
operates
1:M
DEPARTMENT
DEPARTMENT
has
1:M
STUDENT
DEPARTMENT
employs
1:M
PROFESSOR
DEPARTMENT
offers
1:M
COURSE
COURSE
generates
1:M
CLASS
SEMESTER
includes
1:M
CLASS
PROFESSOR
is dean of
1:1
SCHOOL
PROFESSOR
chairs
1:1
DEPARTMENT
PROFESSOR
teaches
1:M
CLASS
PROFESSOR
advises
1:M
STUDENT
STUDENT
enrolls in
M:N
CLASS
BUILDING
contains
1:M
ROOM
ROOM
is used for
1:M
CLASS
Note: ENROLL is the composite entity that implements the
M:N relationship "STUDENT enrolls in CLASS."

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions