Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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