HomeworkLib
Question

Create an ERD using the following information: A dentist's office needs to keep information about patients,...

Create an ERD using the following information:

A dentist's office needs to keep information about patients, the number of visits they make to the office, work that must be performed, procedures performed during visits, charges and payments for only one dentist so there is no need to store information about the dentist in the database. There are several hundred patients. Patients make many visits, and the database should store information about the services performed during each visit and the changes for each of the services. There is a standard list of charges, kept outside of the database. The office uses three dental laboratories that provide supplies and services, such as fabricating dentures.

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

Homework Answers

Answer #1

Database : DENTIST OFFICE

Relations :-

Admin(admin_ID, Name)

Patients(Name, Phone_no, Address, Age, gender, NumberofVisits)

Procedures(Visit_no, procedure_performed, ChargesandPayments)

Laboratories(Lab_ID, type, OtherInformation)

ER Diagram is as follows :

I have tried my best to provide you with the required answer.Do give a thumbs up for my efforts :))

0 0
Add a comment
Know the answer?
Add Answer to:
Create an ERD using the following information: A dentist's office needs to keep information about patients,...
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

  • In this assignment, you will create both a Domain Model Class Diagram (database model) and a...

    In this assignment, you will create both a Domain Model Class Diagram (database model) and a Design Class Diagram (for programmers). The receptionists of the dental clinic are responsible for entering information about patients, including head of household information, insurance information, and number of office visits. The dental clinic business manager also maintains patient information, as well as dental staff information. The business manager responsibilities include printing invoices and sending them to the heads of households on a monthly basis,...

  • Read, read and read and then think about that you can create perfectly an enhanced ERD...

    Read, read and read and then think about that you can create perfectly an enhanced ERD for the following description. with making sure to include all kind of entities, attributes, and correct cardinality in relationships between entities. Never forget foreign keys. You need to build a database for the Good College. The College database administrator needs to keep track of the students that attend the College, the courses offered by the college, and the college employees. College tracks the first...

  • database management 4.6u Dental Office Data Model For each of the following problems, create a conceptual...

    database management 4.6u Dental Office Data Model For each of the following problems, create a conceptual data model, consisting of object sets, relationships, attributes, and so on, that can be used to answer questions similar to the questions given. Indicate cardinalities. PLEASE NOTE YOU WILL SUBMIT YOUR COPY USING ONE OF THE FOLLOWING METHODS Your Choice) to me USING THE UPLOAD LINK! Possible options include: 1. Hand drawn solutions can be a paper submission or scanned and uploaded as a...

  • It's due tonight. Thanks! Part 1 refer to pages 370 and 371 answer to the following...

    It's due tonight. Thanks! Part 1 refer to pages 370 and 371 answer to the following (10 pts) Outline (list)managed care requirements for patient referrals. Medicaid patients before the fifth of each month. This allows ample time for the beneficiary to receive the medical coupon. If the patient presents for an appointment without a medical coupon, and proof of eligibility cannot be determined elsewhere, it is common practice to have that patient reschedule the appointment. The exception is an emergency...

  • Read the information before each question, then answer the question right there. Don't read ahead. I...

    Read the information before each question, then answer the question right there. Don't read ahead. I want you to think about each set of information and what that means at the time. Your first impressions might be different as new information is presented. That is to be expected as patients exhibit new signs and symptoms, and new information from the laboratory or other sources becomes available. Ted is a 67-year-old male with no significant past medical history, except for occasional...

  • PART 1 Introduction to Medical Assisting 12 Grade Name: Date: MULTIPLE CHOICE 1. The branch of...

    PART 1 Introduction to Medical Assisting 12 Grade Name: Date: MULTIPLE CHOICE 1. The branch of law concerned with issues of citizen Scenario for questions 6 and 7: A man is found lying unconscious outside the physician's office. You alert several colleagues, who go outside to assess the man's condition. It is clear that he will be unable to sign a consent form for treatment. welfare and safety is: a. private law b. criminal law c. constitutional law d. administrative...

  • a. Which of the following statements about managerial accounting is true? 1) Managerial accounting information is...

    a. Which of the following statements about managerial accounting is true? 1) Managerial accounting information is prepared for external users. 2) Managerial accounting information is a legal requirement. 3) The structure of managerial accounting practice is relatively flexible. 4) There are structured standards of acceptability for managerial accounting. b. Which of the following statements is incorrect with regard to a manufacturing firm? 1) Inventoriable costs include only prime costs. 2) Inventoriable costs include prime costs and manufacturing overhead costs. 3)...

  • 1. Bookworm Publishers publishes books, and they have gathered the following data for the month of...

    1. Bookworm Publishers publishes books, and they have gathered the following data for the month of October: Data Cash on 10/1 $7,900 Expected Cash Collections $350,000 Direct Materials Cash Disbursements $68,000 Direct Labor Cash Disbursements $45,000 MOH Cash Disbursements $41,500 Operating Expenses Cash Disbursements $93,000 Capital Expenditures Cash Disbursements $132,000 Bookworm Publishers requires an ending cash balance of at least $5,000 and can borrow from a line of credit in $1,000 increments. How much cash is available for October? A....

  • Textbook: Information Systems Business Concepts Baltzan, Business Driven Technology, 8e ( Baltzan, 8e) Disrupting the Taxi:...

    Textbook: Information Systems Business Concepts Baltzan, Business Driven Technology, 8e ( Baltzan, 8e) Disrupting the Taxi: Uber Ray Markovich started driving a taxi in Chicago three years ago after closing his struggling wireless-phone store. Driving a cab wasn’t particularly gratifying or lucrative; he had to pay $400 a week just to lease his 2011 white Ford Escape. It was predictable if monotonous work. Well, there’s nothing monotonous about it now. In June, Markovich, a thin, well-dressed man with short brown...

  • Select two of the discussion questions and analyze the case study using project management principles. Apply...

    Select two of the discussion questions and analyze the case study using project management principles. Apply your knowledge of project management to the facts presented in the case study to describe how you would proceed. We only need to answer one of the questions. A thorough answer will probably require 300 to 500 words for each question.   Feel free to use text bullets, tables, or graphics to summarize your points. Questions Q1: Make or Buy decision – Describe the make...

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