SSN name age address phone Pharmacy Start date Patient End date supervisor sname m address m m n Contact has Prescription Sell 1 n n n SSN name Doctor Quantity date Drug E specialty make 1 Company Experience years Formula Trade Name name address

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter7: Developing An Excel Application
Section: Chapter Questions
Problem 3.6CP
icon
Related questions
Question

Need help translating this ER diagram into the appropriate relational schemas. 

SSN
name
age
address phone
Start date
End date
Patient
Pharmacy
supervisor
sname
m
address
m
m
n
Contact
has
Prescription
Sell
1
P
n
n
n
SSN
name
Doctor
Quantity
date
Drug
m
specialty
make
1
Company
Experience
years
Formula
Trade Name
name
address
Transcribed Image Text:SSN name age address phone Start date End date Patient Pharmacy supervisor sname m address m m n Contact has Prescription Sell 1 P n n n SSN name Doctor Quantity date Drug m specialty make 1 Company Experience years Formula Trade Name name address
Expert Solution
steps

Step by step

Solved in 5 steps with 7 images

Blurred answer
Knowledge Booster
Graphical User Interface
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
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning