Question
Draw Enhanced ERD of Hospital management system. followings should b include in EERD. try to add these entities and attributies in your Enhanced ERD. i
Draw Enhanced ERD of Hospital management system. followings should b include in EERD.
try to add these entities and attributies in your Enhanced ERD.
i need EERD not simple ERD.
Table structure for table `admin`
id` `username` varchar `password `updationDate`
Table structure for table `appointment`
id` `doctorSpecialization `doctorId `userId `consultancyFees `appointmentDate `appointmentTime `postingDate` `userStatus `doctorStatus` `updationDate`
TABLE OF doctors:
`id` int(11) NOT NULL, `specilization`
`doctorName`
`address` `docFees` `contactno `docEmail` `password` `creationDate `updationDate`
Table of doctorslog:
`id` `uid` `username` `userip` `loginTime` `logout` `status`
table of doctorspecilization
id` int(11) NOT NULL, `specilization
`creationDate` `updationDate`
table of contactus:
id` int(11) NOT NULL, `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