Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions