Using the Crows Foot methodology create an ERD that can be i

Using the Crow’s Foot methodology, create an ERD that can be implemented for a medical clinic, using at least the following business rules:

Solution

ERD is the one of the common data modeling technique. Entities I mean components are used in creation of ER Diagram. Components are depend upon one to one or many to one or many to many. These attributes has an identifier for uniquely identified this is known as primary key in our database terminology.

Relation ships are:

One to one

One to many

Many to one

Many to many

Here in this case Medical clinic ERD:

1. Patient – Attributes:

P_id (primary key)

P_lname

P_fname

Appointent

2.Doctor- Attributes:

Doct_id (primary key)

Doct_name

3.Appointment – attributes:

AppointmentId (primary key)

Patient ID (foreign key)

4.Insurance –Attributes:

Policy(insurance)_Id(Primary key)

Pateint id

5.Visit Record- Attributes:

Visit ID(Primary key)

Treatment

6. Bill Attrbiute:

Doctor ID

InsuranceID

7. Payment _ Attbutes:

Biil ID (Primary key)