Scribd
Upload
823 views4 pages

ER Diagram (Lab - 1)

This document provides tasks for constructing Entity-Relationship diagrams using draw.io. The tasks include drawing ER diagrams for a bank database with branches and accounts, a hospital database with affiliated hospitals and treatments, a sports league database with teams, players and games, a car insurance database with customers and accidents, and a movie database with movies, actors, directors and awards. The document explains the components to include in the ER diagrams such as entity types, attributes, relationships, participation constraints, and key constraints.

Uploaded by

gg als
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
823 views4 pages

ER Diagram (Lab - 1)

This document provides tasks for constructing Entity-Relationship diagrams using draw.io. The tasks include drawing ER diagrams for a bank database with branches and accounts, a hospital database with affiliated hospitals and treatments, a sports league database with teams, players and games, a car insurance database with customers and accidents, and a movie database with movies, actors, directors and awards. The document explains the components to include in the ER diagrams such as entity types, attributes, relationships, participation constraints, and key constraints.

Uploaded by

gg als
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/ 4

Nepathya College

Tilottama – 5, Rupandehi

Lab # 1

Construction of Entity-Relationship
Diagram (ER Diagram)

Prepared By: Shiva Bhattarai


Table of Contents
1. Objective...........................................................................................................................................3
2. Requirements....................................................................................................................................3
3. Tasks.................................................................................................................................................3
4. References........................................................................................................................................4

Prepared By: Shiva Bhattarai 2


1. Objective
To construct the Entity Relationship diagram using draw.io.

2. Requirements
• draw.io.
• DBMS Lab file (this document)

3. Tasks
1. Draw an ER diagram for database showing Bank. Each Bank can have multiple
branches, and each branch can have multiple accounts and loans.
2. Draw an ER diagram for a database showing Hospital system. The Hospital
maintains data about Affiliated Hospitals, type of Treatments facilities given at each
hospital, and Patients.
3. A database is being constructed to keep track of the teams and games of a sports
league. A team has number of players, not all of whom participate in each game. If is
desired to keep track of the players participating in each game for each team, the
positions they played in that game, and the result of the game. Design an ER diagram
for this application
4. Construct an ER diagram for a car insurance company whose customers are own one
or more cars each. Each car has associated with it zero or any number of recorded
accidents.
5. Consider a database of movie information, suppose we want to allow users to get
information about:
• movies
• actors
• directors
• Academy Awards
We’ll assume that each movie has a single director, and we will only concern
ourselves with the following awards: Best Picture, Best Actor, Best Actress, Best
Supporting Actor, and Best Supporting Actress.
Let’s construct an ER diagram for this domain. While there are many possible
answers for this problem, you should try to include at least one example of each of
the following:
• a relationship set with one or more descriptive attributes
• a key constraint
• a participation constraint

Prepared By: Shiva Bhattarai 3


• a ternary (three-way) relationship set

Note: Try to include all the symbols that you have studied

Entity Types, Attributes and its types, relationships (degree and cardinalities),
participation, weak entity concepts.

4. References
• https://draw.io/
• https://www.lucidchart.com/
• https://gleek.io/

Prepared By: Shiva Bhattarai 4

You might also like