View the step-by-step solution to:

Thank you! Question: Database Purpose: To tack the doctors office visits. Business Rules : One doctor can see many patients on the same day.

I would need your help with normal form. Thank you!


Question:


Database Purpose: To tack the doctors office visits.

Business Rules : One doctor can see many patients on the same day.

One patient can see different doctors on different days.

On one day, one patient sees only one doctor. 

One doctor can have many specialties.

We can have many doctors with the same specialty.

Many patients can have the same Insurance.

One Insurance company can have many patients.

For both Doctor and Patients we record only one phone number.

 

DocOffice

VisirID_PK

DoctorName

DoctorSpeciality1

DoctorSpeciality2

DoctorSpeciality3

DoctorPhoneNumer

PatientName

PatientPhoneNumber

VisitDate

TotalCost

PatientInsuranceNumber

InsuranceCompany



  Requirements:

 

List all fields that violate the third normal form.

 

Redesign the database that includes at least the information in the table

 

Design should meet the business rules and design requirements.

Design must be in third normal form.

Provide names to fields and tables based on recommended naming conventions.

Specify the primary key fields in each table by placing an asterisk beside the fields.

Draw a line between the fields of each table to show the relationships between each

table.

Specify which table is one the one side of the relationship by placing a one next to the field where the line starts.

Specify which table is on the many side of the relationship by placing a crow's feet symbol next to the field where the line ends.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question