Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Name Start Date SIN Address Age Name 1,1 Patients O,n SIN Specialty Date of Entry Address Primary Physician O,n Doctor O,n Phone Prescription Date Takes Quantity O,n Trade Name O,n O,n Pharmacy Sell Drug Formula O,n Contract Price Pharmaceutical O,n Co. End Date Name Phone

Name Start Date SIN Address Age Name 1,1 Patients O,n SIN Specialty Date of Entry Address Primary Physician O,n Doctor O,n Phone Prescription Date Takes Quantity O,n Trade Name O,n O,n Pharmacy Sell Drug Formula O,n Contract Price Pharmaceutical O,n Co. End Date Name Phone

Np Ms Office 365/Excel 2016 I Ntermed
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 3RA
See similar textbooks
icon
Related questions
Question

Mapping from ER to Relational Model

Map the ER (Entity-Relationship) schema below into a relational schema. For each table, specify the primary keys and the foreign key(s) if any.
Note: Use a solid line to underline a primary key and indicate clearly the foreign key using arrows.

Name Start Date SIN Address Age Name 1,1 Patients O,n SIN Specialty Date of Entry Address Primary Physician O,n Doctor O,n Phone Prescription Date Takes Quantity O,n Trade Name O,n O,n Pharmacy Sell Drug Formula O,n Contract Price Pharmaceutical O,n Co. End Date Name Phone
Transcribed Image Text:Name Start Date SIN Address Age Name 1,1 Patients O,n SIN Specialty Date of Entry Address Primary Physician O,n Doctor O,n Phone Prescription Date Takes Quantity O,n Trade Name O,n O,n Pharmacy Sell Drug Formula O,n Contract Price Pharmaceutical O,n Co. End Date Name Phone
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
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
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
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
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Security (MindTap Cours…
Principles of Information Security (MindTap Cours…
Computer Science
ISBN:
9781337102063
Author:
Michael E. Whitman, Herbert J. Mattord
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS