Draw an ER diagram accordingly to the following user requirements. You can draw the diagram using tools that you prefer, such as Microsoft Visio, Microsoft Word, Microsoft Power Point. Hand-drawn diagram will get a Zero. Please use the ER notation taught in this class to complete this assignment. Using any other ER notation will get a Zero. Please don't use non-binary relationship in this assignment. Please submit a PDF file to Canvas. List assumptions for your diagram, if there is any. A database is gathering the following information: Doctors are uniquely identified by their SSNSS. For each doctor, the name, specialty must be recorded. Each pharmaceutical company is identified by a unique name and has a phone number. For each drug, the drug name and formula must be recorded. Each drug is manufactured by a pharmaceutical company, and drug name identifies a drug uniquely from among the products of that company. The name is unique only regarding the same pharmaceutical company. For example, name of “Ibuprofen" can be produced by different pharmaceutical companies. Each pharmacy has a unique name, address and phone number. Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another. Doctors can make many prescriptions. Each prescription has a unique number with regard to a doctor. For example, Dr. Smith can produce prescription number 328. Dr. Miller can produce prescription number 328. Because the they are from different doctors, these two prescriptions can be distinguished in the database. The prescription date is also recorded. Please make this date as an attribute of your entity, instead of an attribute of relationship. A prescription is made by one and only one doctor. _Each prescription includes at least one drug. A drug may not be in any prescription. A drug may be in different prescriptions. One drug can be sold by many pharmacies and one pharmacy can sell many drugs. Some drugs may not be sold by any pharmacy. One drug can be made by one pharmaceutical company where as a pharmaceutical company can make many drugs.

Draw an ER diagram accordingly to the following user requirements. You can draw the diagram using tools that you prefer, such as Microsoft Visio, Microsoft Word, Microsoft Power Point. Hand-drawn diagram will get a Zero. Please use the ER notation taught in this class to complete this assignment. Using any other ER notation will get a Zero. Please don't use non-binary relationship in this assignment. Please submit a PDF file to Canvas. List assumptions for your diagram, if there is any. A database is gathering the following information: Doctors are uniquely identified by their SSNSS. For each doctor, the name, specialty must be recorded. Each pharmaceutical company is identified by a unique name and has a phone number. For each drug, the drug name and formula must be recorded. Each drug is manufactured by a pharmaceutical company, and drug name identifies a drug uniquely from among the products of that company. The name is unique only regarding the same pharmaceutical company. For example, name of “Ibuprofen" can be produced by different pharmaceutical companies. Each pharmacy has a unique name, address and phone number. Each pharmacy sells several drugs and has a price for each. A drug could be sold at several pharmacies, and the price could vary from one pharmacy to another. Doctors can make many prescriptions. Each prescription has a unique number with regard to a doctor. For example, Dr. Smith can produce prescription number 328. Dr. Miller can produce prescription number 328. Because the they are from different doctors, these two prescriptions can be distinguished in the database. The prescription date is also recorded. Please make this date as an attribute of your entity, instead of an attribute of relationship. A prescription is made by one and only one doctor. _Each prescription includes at least one drug. A drug may not be in any prescription. A drug may be in different prescriptions. One drug can be sold by many pharmacies and one pharmacy can sell many drugs. Some drugs may not be sold by any pharmacy. One drug can be made by one pharmaceutical company where as a pharmaceutical company can make many drugs.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 8EYW

See similar textbooks