Design a conceptual schema (ER diagram) for doctors’ offices. The following information describes the situation that doctors’ offices database must model. Be sure to indicate all key and cardinality constraints and any assumptions you make.      Each doctor has badgeId , and name. A doctor is uniquely identified by their badgeId and may manage more than one office. An office may be managed by at most one doctor. An office has address and a phone. it is uniquely identified by its address, and it contains one or more exam rooms An exam room can be identified by its room number, and the office that it is in. Each patient has SSN, name, and phone number. Patient is uniquely identified by their SSN. When a patient visits an office, he or she has a consultation with a doctor in an examination room.

A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 3TD
icon
Related questions
Question

Design a conceptual schema (ER diagram) for doctors’ offices. The following information describes the situation that doctors’ offices database must model. Be sure to indicate all key and cardinality constraints and any assumptions you make.   

 

  • Each doctor has badgeId , and name. A doctor is uniquely identified by their badgeId and may manage more than one office. An office may be managed by at most one doctor.
  • An office has address and a phone. it is uniquely identified by its address, and it contains one or more exam rooms
  • An exam room can be identified by its room number, and the office that it is in.
  • Each patient has SSN, name, and phone number. Patient is uniquely identified by their SSN.
  • When a patient visits an office, he or she has a consultation with a doctor in an examination room.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning