ZuoTi.Pro
Question

The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary,...

The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will be to the same dentist. A client can be insured or self-paying. An insured client should have an insurance company-name, and company-Phone, while a self-paying client must have a bank-name and a bank account. Each visit of a client is described by a date, type, action, fee, and date-of-next-appointment.

Question: Design an Entity Relationship (ER) Model to represent the above requirements

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Roorm ors ray lS 多夢メ

1 0
Add a comment
Know the answer?
Add Answer to:
The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have...

    question One: Design an ER diagram for the following Dental Clinic database. Your diagram should have all the needed details. You may make any reasonable assumptions but you have to state them clearly. ------ The clinic has several dentists. Each dentist has a unique Number, name, nationality, multiple room-number, salary, birth-date and home-address (Box, City, Zip). Each client (patient) has a unique Code, name, home-phone, work-phone, address, and birth-date. Each client is assigned to one dentist. All future visits will...

  • for question (c) do like this 3. A table to record the information of Dentists, Patients,...

    for question (c) do like this 3. A table to record the information of Dentists, Patients, and Appointments in a clinic is given below. DentistNo DentistName PatientNo PatientName PatientPhone AppointmentDate Appointment Time AppointmentFee On a single day each patient can have more than one appointment. It is known that DentistNo is unique for each dentist. PatientNo is unique for each patient. PatientNo must not be used as a composite key. A patient is allowed to see any dentist. (a) Use...

  • Conceptual data diagram The ABC university keeps track of each student&#39;s name, student number, social security...

    Conceptual data diagram The ABC university keeps track of each student&#39;s name, student number, social security number (I C number), current address and phone, permanent address and phone, birthdate, sex, class (alpha, Beta, Gamma ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student&#39;s permanent address, and to the student&#39;s last name. Both social security number and student number have...

  • Q1: Each student has a unique student id, name, unique email address, and a phone number....

    Q1: Each student has a unique student id, name, unique email address, and a phone number. A student is either a degree seeking student or a non-degree seeking student. For degree seeking students, additional information such as catalog year and date of admission are recorded. For non-degree seeking students, additional information on program of interest needs to be recorded. Only degree seeking students can submit financial aid applications. Each degree seeking student can submit multiple financial aid applications or none....

  • Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is...

    Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, birth date, sex, class (freshman, sophomore,., graduate), major department, minor department (if any), and degree program (B.A., B.S.,..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...

  • First, draw an EER that models the given requirements. You will play with the Bank Database...

    First, draw an EER that models the given requirements. You will play with the Bank Database in this homework. Please download and execute the bank.sql from Canvas to create this database in your MySQL system. Please submit the results as a zip file with a name <yourname>-bank.zip. Consider modeling a bank: . The bank keeps personal information of each customer including name, sex, address, phone number, social security number, and date of birth. . Each customer owns one or more...

  • 1. Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients....

    1. Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test. Required: Write out a set of relational tables that correspond to the class diagram that you prepared for Problem 1. Identify primary and foreign keys. Using Microsoft Access, define the tables and set up...

  • You were requested to design a database to store the data concerning a large mechanic shop....

    You were requested to design a database to store the data concerning a large mechanic shop. Your database has to store the following: For each car, you want to store the make, model, year, color, engine info, license plate, VIN (vehicle identification number), and a field for general notes. Additionally, for each car, you need to keep information about the owner. For each owner, you need to store the client ID, the name, address information, phone number, and email. An...

  • Project 4: ER-Diagram and DBDL (25 Points) Database Design Language (DBDL) Use Visio or Word to...

    Project 4: ER-Diagram and DBDL (25 Points) Database Design Language (DBDL) Use Visio or Word to create the model. The correct syntax must be used. Remember to list out all alternate keys, secondary keys, and foreign keys. Entity Relationship Diagram (ERD) Draw the data model for the situation using LucidChart, Microsoft Visio, Word or other ERD Drawing Program. When drawing the objects, be sure to use the correct shapes, and syntax. Example: Entity is a rectangle box, and the name...

  • Case Study You have been hired to manage a portfolio of several specialty clinics in a...

    Case Study You have been hired to manage a portfolio of several specialty clinics in a large multi-physician group practice in an academic medical center. The clinics reside in a multi-clinic facility that houses primary care and specialty practices, as well as satellite laboratory, radiology and pharmacy services. The practice provides the following centralized services for each of its clinics: Registration Payer Interface (e.g., authorization) Billing The CEO of the practice has asked you to initially devote your attention to...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT