Hospital Management system Database design PDF

Preview

Summary

Download Hospital Management system Database design PDF

Description

www.freestudentprojects.com www.sourcecodefiles.com www.buystudentprojects.com

Hospital Management System

DATABASE DESI GN

1.Descr i pt i on A dat abasei sacol l ect i on ofi nf or mat i on and i ssys t emat i cal l y st or edi nt abl esi nt hef or m ofr owsandcol umns.Thet abl ei nt he dat abase has uni que name t hat i dent i fies i t s cont ent s. The dat abasei nt ur ni sf ur t herdescr i bed i n det ai lgi vi ngal lt hefiel ds used wi t ht he dat at ypes,const r ai nt s avai l abl e,pr i mar y key and f or ei gnkey . Dat abasedesi gni susedt omanagel ar gebodi esofi nf or mat i on. I nt hi s dat abase we descr i be al lt he 4 t abl es avai l abl ei nt he sof t war e,whi char eusedt ost or eal lt her ecor ds.

2.Dat at ypesandi t sdescr i pt i on: Fi el dsi n dat abaset abl ehaveadat at ype.Someoft hedat a t ypesusedi ndat abaset abl ear eexpl ai nedbe l ow. a)I nt eger : Oneopt i onalsi gnchar act er( +or)f ol l owedbyat l eastonedi gi t ( 09) .Leadi ngandt r ai l i ngbl anksar ei gnor ed.Noot herchar act er i sal l owed. b)Var char : I ti susedt ost or eal phanumer i cchar act er s.I nt hi sdat at ype wecanse tt hemaxi mum numberofchar act er supt o8000r anges bydef aul tSQLser verwi l lse tt hes i z et o50char act er sl ar ge .

www.freestudentprojects.com www.sourcecodefiles.com www.buystudentprojects.com

19 Hospital Management System c)Dat e /Ti me: Dat e /Ti medat at ypei susedf orr epr e sent i ngdat aort i me .

Pat i entTabl e: Fi el ds

Dat aType

Rel at i onshi ps

Pi d name age wei ght gender addr ess phoneno di sease doct or i d

Var char ( 5) Var char ( 20) i nt i nt Var char ( 10) Var char ( 50) i nt Var char ( 20) Var char ( 5)

Pr i mar yKey NotNul l NotNul l NotNul l Notnul l NotNul l NotNul l NotNul l NotNul l

Doct orTabl e: Fi el ds

Dat aType

Rel at i onshi ps

doct or i d doct or name dept

Var char ( 5) Var char ( 15) Var char ( 15)

Pr i mar yKey NotNul l NotNul l

www.freestudentprojects.com www.sourcecodefiles.com www.buystudentprojects.com

20 Hospital Management System

LabTabl e: Fi el ds

Dat aType

Rel at i onshi ps

l abno pi d wei ght doct or i d dat e cat egor y pat i ent _ t ype

Var char ( 5) Var char ( 5) i nt Var char ( 5) Dat e/Ti me Var char ( 15) Var char ( 15)

Pr i mar yKey NotNul l NotNul l For ei gnKey NotNul l NotNul l NotNul l

amount

i nt

NotNul l

I npat i entTabl e: Fi el ds

Dat aType

Rel at i onshi ps

pi d r oom_no dat e_of _ adm dat e_of _ di s advance l abno

Var char ( 5) Var char ( 50) Dat e/Ti me Dat e/Ti me i nt Var char ( 5)

Pr i mar yKey NotNul l NotNul l NotNul l NotNul l For ei gnKey

Out pat i entTabl e: Fi el ds

Dat aType

Rel at i onshi ps

pi d dat e l abno

Var char ( 5) Dat e/Ti me Var char ( 5)

Pr i mar yKey NotNul l For ei gnKey

www.freestudentprojects.com www.sourcecodefiles.com www.buystudentprojects.com

21

Hospital Management System

Room Tabl e: Fi el ds

Dat aType

Rel at i onshi ps

r oom_no r oom_t ype s t at us

Var char ( 50) Var char ( 10) Var char ( 10)

Pr i mar yKey NotNul l NotNul l

Bi l lTabl e: Fi el ds

Dat aType

Rel at i onshi ps

bi l l _no pi d pat i ent _ t ype doct or _ char ge medi ci ne_char ge r oom_char ge opr t n_char ge no_ of _ days nur si ng_char ge advance heal t h_ car d l ab_char ge bi l l

Var char ( 50) Var char ( 5) Var char ( 10) i nt i nt i nt i nt i nt i nt i nt Var char ( 50) i nt i nt

Pr i mar yKey For ei gnKey Al l ow Nul l NotNul l NotNul l NotNul l Al l ow Nul l Al l ow Nul l Al l ow Nul l Al l ow Nul l Al l ow Nul l Al l ow Nul l NotNul l

ER Di agr am Ent i t yr e l at i onshi p di agr am i sused i n moder n dat abase sof t war eengi neer i ngt oi l l ust r at el ogi cals t r uct ur eofdat abase .I t i sar e l at i onalsc he madat abasemode l i ngme t hod us ed t omode l a sys t e m and appr oach. Thi s appr oac h commonl y used i n

www.freestudentprojects.com www.sourcecodefiles.com www.buystudentprojects.com

dat abasede si gn.Thedi agr am cr eat e dusi ngt hi sme t hodi scal l ed ER di agr am. 22 Hospital Management System TheER di agr am depi c t st hev ar i ousr e l at i onshi psamong ent i t i e sconsi der i ngeachobj ec tase nt i t y .Ent i t yi sr e pr esent e das di amond shapeand r e l at i ons hi pi sr epr e sent ed asr ec t angl e .I t depi c t st her e l at i onshi pbe t weendat aobj ec t s .TheER di agr am i s t her e l at i ont hati susedt oconduc tt hedat amode l i ngac t i vi t y .

Ent i t y: Ent i t yi st het hi ngwhi chwewantt os t or ei nf or mat i on.I ti san e l ement ar y basi c bui l di ng bl oc k ofs t or i ng i nf or mat i on about busi ne sspr ocess.An ent i t yr epr e sent san obj ec t sdefine dwi t hi n t he i nf or mat i on sys t e m about whi c h you want t o s t or e i nf or mat i on.

Re l at i ons hi p: Ar e l at i onshi pi snamed connect i on orassoci at i on be t ween ent i t i e sused t or e l at et wo ormor eent i t i eswi t h somecommon at t r i but e sofmeani ngf uli nt er ac t i onbe t weent heobj e ct .

At t r i but e s: At t r i but esar et hepr oper t i esoft heent i t i esand r e l at i onshi p. De scr i pt or of t he ent i t y . At t r i but e s ar ee l ement ar y pi eces of i nf or mat i onat t ac hedt oanent i t y .

www.freestudentprojects.com www.sourcecodefiles.com www.buystudentprojects.com

23

Hospital Management System Symbol s

Me ani ng

Ent i t y

Re l at i onshi p

At t r i but e

KeyAt t r i but e

E1

R

E2

Car di nal i t y Rat i o N:1 f orE1: E2i nR

www.freestudentprojects.com www.sourcecodefiles.com www.buystudentprojects.com

24

Hospital Management System

ER Di agr am

pid

name

age

weight

gender

doctorid

patient

address phone no

Consults disease Doctorid dept doctor

Doctor name

amount Checks lab no

category

Pid date

lab Report weight

pid

Decides

advance date of admission

inpatient

lab no

doctorid

pid lab no

outpatient

date date of discharge

room no issued_to

Admitted to to status

medicine charge

room no room

room charge

bill no pid lab charge

www.freestudentprojects.com www.sourcecodefiles.com www.buystudentprojects.com

bill room type

patient type

operation charge

bill

no of days nursing charge

health card

advance

25

doctor charge...