Page 462 - Computer_Science_F5

Salesperson

Invoice

Customer Chapter Eight: Databases and Database Management Systems
FOR ONLINE READING ONLY
Places
Includes Line Specifies
Orders Product
items

Generates

Invoice

Figure 8.16: An example Entity-Relationship Diagram (ERD) - customer order database

Activity 8.5:

Construction of an E-R diagram to represent a real-life database

Aim:
Develop an Entity-Relationship (E-R) diagram to model and visualise the
relationships between students, courses, and professors in a university database
scenario.

Materials Required:
1. Computer with ER diagramming software (such as Lucidchart, Microsoft Visio)
2. Access to a DBMS for conceptual modeling
3. Data or information about students, courses, and professors in a university
setting

Instructions:
In a University, a student enrols in courses. A student must be assigned to at least
one or more courses. To maintain instruction quality, a Professor can deliver only
one course. Create an Entity Relationship Diagram (ERD) following the steps
indicated in the diagram below and the steps that follow:

Relationship Cardinality Identify
Entity Identification Identification Identification Attributes Create ERD

453
Student’s Book Form Five

Computer Science Form 5.indd 453 23/07/2024 12:34