Question
Question: Draw Enhanced ERD of Hospital management system. followings should b include in EERD. Add these entities and attributies in your Enhanced I need EERD
Question: Draw Enhanced ERD of Hospital management system. followings should b include in EERD.
Add these entities and attributies in your Enhanced I need EERD not simple ERD.
Make Enhanced ERD according to these requirements. If you dont know how to draw enhanced erd of hospital management system then please dont give me wrong solution In that i case I will give you dislike.
these entities and attributes must be included in enhanced ERD
(Enhanced entity-relationship (EER) diagrams are basically an expanded upon version of ER diagrams. EER models are helpful tools for designing databases with high-level models. With their enhanced features, you can plan databases more thoroughly by delving into the properties and constraints with more precision.)
Requirements:
Table structure for table `admin`
id` `username `password `updationDate`
Table structure for table `appointment`
id` `doctorSpecialization `doctorId `userId `consultancyFees `appointmentDate `appointmentTime `postingDate` `userStatus `doctorStatus` `updationDate`
TABLE OF doctors:
`id` `specilization`
`doctorName`
`address` `docFees` `contactno `docEmail` `password` `creationDate `updationDate`
Table of doctorslog:
`id ,username` `userip` `loginTime` `logout` `status`
table of doctorspecilization
id `specilization
`creationDate` `updationDate`
table of contactus:
id` `fullname` `email` `contactno``message` `PostingDate` `AdminRemark``LastupdationDate` `IsRead` userlog users
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started