Question: I'm trying to create an ERD in Microsoft Visio using the following business rules. Does my current diagram look correct? Am I missing any relationships

I'm trying to create an ERD in Microsoft Visio using the

I'm trying to create an ERD in Microsoft Visio using the following business rules. Does my current diagram look correct? Am I missing any relationships or Foreign Key fields?

Patient makes an appointment to see a doctor

The appointment is for a particular date and time

The patient is assigned to a doctor but if this doctor is not available, the patient is allowed to see the other available doctors

After treatment, the patient makes a co-pay payment

The patient is insured by an insurance company

The insurance company makes the remaining payment

Appointment Doctor Patient AppointmentNumber int Doctorid PatientiD int Appttype Varchar DoctorFirstName PatientFirstName Varchar ApptDescrip Varchar DoctorAddress int DoctoriD int Insurance Company Payment int InsuranceColD int PaymentiD PaymentMethod PolicyNumber int CreditCardNumber PatientiD int CreditCardExp nsurancecOID PatientiD

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Create an ERD based on the Crow s Foot notation with Microsoft Visio, using the following business rules or requirements: In the ERD should include: 1 . all entities ( 2 5 pts ) 2 . for each entity...

Assignment #2 - Data Modeling Assignment 40 Points Possible Part 1: (20 points) Use Microsoft Visio to create and ERD. Julia, a recent graduate of UToledo has launched her own web design company:...

can you please make the answer the how it order in last page exactly appreciate your help Part 1: (20 points) Use Microsoft Visio to create and ERD. Julia, a recent graduate of UToledo has launched...

In this part of the assignment, you will learn to create an Entity Relationship Diagram (ERD) for a construction company using the data provided. Trstrictions: Read Project 29: Billing Data on pages...

In this part of the assignment, you will leam to create an Entity Relationship Diagram (ERD) for a construction company using the data provided. On-The-Level Construction Company is a Denver-based...

complete it!!!!!!!!!!!!!!!!!!!!!!!!! Assignment #2 - Data Modeling Assignment 40 Points Possible Part 1: (20 points) Use Microsoft Visio to create and ERD. Julia, a recent graduate of UToledo has...

I JUST NEED THE ANSWER TO PART 2 Part 1: Artists and Songs Review the following structural business rules regarding artists and songs to complete this part. An artist sings many songs. A song is sung...

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

please help. 3/2016 MeGW HI Connect Ebook The entity danses and primary kays for the database have been identified as the following: Project Project Rumber Employee Nur Job Number Ass Number kod The...

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

Start from a = 250 and b = 500. Take two steps, with a step length of t = 0.1, as in Section 5.5, Exercise 8.

Two resistors, 100 and 25k, are rated for a maximum power output of 1.5 W and 0.25 W, respectively. (a) What is the maximum voltage that can be safely applied to each resistor? (b) What is the...

An example of a security is an ) smartphone . antique coin.O bond issued by Deere

undefined Delos Debt Renegotiations (B). Delos is continuing to renegotiate its prior loan agreement (80 million for six years at 8.622% per annum E), two years into the agreement. Delos is now...

How can classroom learning be designed to ensure that each student is motivated by his or her felt needs for new learning rather than using a one size fits all approach?

McGregor calls for broad involvement in management development by leaders at all levels. To what degree has that become a reality today?

As a small entrepreneurial organization develops, at what point might you expect it to shift into a formal matrix structure (with different people in staff and line roles)at 10 people, 25 people, 50...