Scribd
Upload
73 views2 pages

Activity 1 - ERD Solomon

The document outlines an activity for creating Entity Relationship Diagrams (ERDs) based on various scenarios involving customers, airlines, factories, employees, and construction projects. Each scenario describes relationships between entities, indicating whether they are one-to-one or many-to-many. The activity is part of a course at the School of Communication, Multimedia & Computer Studies, and is designed to assess students' understanding of database modeling.

Uploaded by

ghieyan solomon
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
73 views2 pages

Activity 1 - ERD Solomon

The document outlines an activity for creating Entity Relationship Diagrams (ERDs) based on various scenarios involving customers, airlines, factories, employees, and construction projects. Each scenario describes relationships between entities, indicating whether they are one-to-one or many-to-many. The activity is part of a course at the School of Communication, Multimedia & Computer Studies, and is designed to assess students' understanding of database modeling.

Uploaded by

ghieyan solomon
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

SCHOOL OF COMMUNICATION, MULTIMEDIA & COMPUTER STUDIES

ENTITY RELATIONSHIP DIAGRAM


ACTIVITY NO. 1

Name: Solomon, Ghieyan Kenshin E. Date: 04/01/2025


Year & Section: BSA2A

Direction: Create an ERD for each of the following descriptions. (Note that the word "many" is
meant to mean "more than one" in a database modeling environment. 3 points each, total of 15
points.)

1. During some period of time, a customer can rent many videotapes from the BigVid store. Each
of the BigVid’s videotapes can be rented to many customers during that period of time.

M M
Customer Rents Videotapes
Rents Rents
Rents Rents Rents

2. An airline can be assigned to fly many flights, but each flight is flown by only one airline.

1 M
Airline Flies Flights
Rents Rents
Rents Rents Rents

3. The KR Corporation operates many factories. Each factory is located in a region. Each region
can be "home" to many of KR’s factories. Each factory employs many employees, but each of
these employees is employed by only one factory.

1
Located in Region
Rents
Rents Rents
Factory 1
Rents Rents
M
Employs Employees
Rents
Rents Rents

Information Management System 1


SCHOOL OF COMMUNICATION, MULTIMEDIA & COMPUTER STUDIES

4. An employee may have earned many degrees, and each degree may have been earned by many
employees.

M M
Employees Earn Degrees
Rents Rents
Rents Rents Rents

5. RK Construction Company is a multi-state building contractor specializing in medium-priced


town homes. Assume that RK’s main entities are its customers, employees, projects and
equipment. A customer can hire the company for more than one project, and employees
sometimes work on more than one project at a time. Equipment, however, is assigned to only
one project at a time. Draw an ERD showing those entities.

1 M M M
Customer Has Project Assigns Equipment
Rents Rents Rents Rents
Rents Rents Rents
1 Rents Rents

Rents
Works
s
1
Rents
1
Rents
Employee
Rents
Rents

Information Management System 2

You might also like