E r diagrams

1. Parul Institute of Engineering & Technology
(Diploma Studies-2
nd
shift)
Subject Code :3330703
Name Of Subject : Database management system
Name of Unit :Entity relationship model
Topic : E-R Diagrams
Name of Faculty : Mihir rajyaguru
Name of Students: Samarth S. Gandhi

2. Entity Relation ships Diagrams

3. Entiyi LibraryRelanaoas
Institutehyl
has pDeygs
l.nameRDyrrisll
I.addresspDmeayma
l.contact aorsea
StudentDeygs
S.nameDyrrisll
S.addressDmeayma
S.contactDys
S.age RDeygs
I.nameRDyrrisll
I.addressRDmeayma
I.contactRDrsyiagsea
I.department l
BooksDnr
B.idDeygs
B. nameDlotsma
B.subjectDrsyiagsea
B.departmentii
Borrow Dnr
S.id
Gives
Study
I_id
M
em
ber
*
*
*
*
*
1
1
1
Librery Management SystemR"D
S_ID.
……R"D
S_ID.
……

4. srnmnesl MedicinesEntiy takes $yanseal
Patients"mail
Doctors%irl Words
Hospital$islminal
Prescripts'llne
Assign ny
HasR
e
l
t
y
W
o
r
k
s(
i
s
y
a
l
Treats'
r
g
n
a
a
s
r
A
d
m
i
t
t
e
d
Hospital Management SystemR"
M_ID eygs
M_name ( s
M_Type
P_No.
P_Age$eygs
P_name$Rr
P_Id
P_Add
W_Type
W_name&'rr
H_Add%Rr
W_Id&)D
H_No.&)ygs
H_Name"R"
D_ID")D
D_No.D_Name"'rr
D_Add"'s
D_Age "R"D
D_ID.$Rr
P_Id
*
*
***
*
*
*
1
1
1
……
……
……

5. Enti A_idy Re
BankynR la
B_nameynti
B_id ynosRh
B_phno s pa
have Dgrmhla
customernti
C_idh Rnti Loan _id ynti
B_id ynosRh
B_phno tpar
Gives Enti
A_idh R
loannmoa
L_typenti
l_idn ti
C _id ynti
B_id DDhgRm
account nmoa
a_type nti a_idnti
C _id ynti B_id nRh
a_no s pa
have y
h


h

B o r r o w
Bank Management System
C_age *
*
*
*1
1
*
1
……
……
……
……
……
…… ……

6. Movie Screens
Customer
Theater
Tickets
H
a
s
Watch
s
h
o
w
s
Play
Buy
*
*
*
11
1
1
1
1
H
a
s
T_no. S_no.
T_time
T_type
T_date
1
S_no
1
*
T_name T_Add
T_com
pany
M_type
M_name
S_no.
C_name
C_no. C_add C_age
T_no.
Theater ticket booking System
……
……

7. Railway reservation system
Ticket
T_date
t.amount
t.id
tnumber
Buy Passenger
pname P_no.
p.id
T.C
Check
t.id
tname
address
Have Train
Travel
T_number
T_windows
T_time
t.sites
t.route
p.sitenumber P_age
T_age
* *
1
11
1
1
1
1
T_number …….……….
…….……….
T_number

8. Bus reservation system
Ticket
T_date
t.amount
t.id
tnumber
Buy Passenger
pname P_no
p.id
Conductor
Check
C_id
cname
C_addres
s
Have Bus
Travel
B_number
B_windows
B_time
B.sites
B.route
p.sitenumber P_age
C_age
* *
1
11
1
1
1