HomeworkLib
Question

Drugs are sold in pharmacies. Each pharmacy has a unique identification. Every pharmacy sells one or...

Drugs are sold in pharmacies. Each pharmacy has a unique identification. Every pharmacy sells one or more drugs, but some pharmacies do not sell every drug.crete ERD and also show cardinality constraints, cardinality limits, and existence dependencies.

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

Homework Answers

Answer #1

ER diagram is given below. Every pharmacy must sell one or more medicine while a drug may be sold by one or more pharmacies - However, it is not given that every drug is sold in pharmacies so we can assume that there may be drugs that may not be sold currently at any pharmacy. So cardinality of drugs and pharmacy become M and N while their modality become 0 and 1 respectively. Pharmacy are also shown to be dependent on Drugs for existence in the dependency Relationship (there is no need of pharmacy which don't sell any drugs).

IS DRUGS 1.N ...M SOLD BY PHARMACY Unique-ld

0 0
Add a comment
Know the answer?
Add Answer to:
Drugs are sold in pharmacies. Each pharmacy has a unique identification. Every pharmacy sells one or...
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

  • Q3: You have been hired to design a database for prescriptions for RX pharmacies and your...

    Q3: You have been hired to design a database for prescriptions for RX pharmacies and your first job now is to design an ER model for this database using the following description of that world. i. patients are identified by their SSN and have other attributes as names, addresses, and ages. ii. Doctors are identified by their SSN and have other attributes as names, specialty, and years of experience. iii. Each pharmaceutical company is identified by name and has a...

  • Advanced Pharmaceuticals, Inc., is a wholesale distributor of prescription drugs to independent retail and hospital-based pharmacies....

    Advanced Pharmaceuticals, Inc., is a wholesale distributor of prescription drugs to independent retail and hospital-based pharmacies. Management believes that top-notch customer representatives are the key factor in determining whether the company will be successful in the future. Customer representatives serve as the company's liaison with customers—helping pharmacies monitor their stocks, delivering drugs when customer stocks run low, and providing up-to-date information on drugs from many different companies. Customer representatives must be ultra-reliable and are highly trained. Good customer representatives are...

  • Advanced Pharmaceuticals, Inc., is a wholesale distributor of prescription drugs to independent retail and hospital-based pharmacies....

    Advanced Pharmaceuticals, Inc., is a wholesale distributor of prescription drugs to independent retail and hospital-based pharmacies. Management believes that top-notch customer representatives are the key factor in determining whether the company will be successful in the future. Customer representatives serve as the company’s liaison with customers—helping pharmacies monitor their stocks, delivering drugs when customer stocks run low, and providing up-to-date information on drugs from many different companies. Customer representatives must be ultra-reliable and are highly trained. Good customer representatives are...

  • Vaxis Pharmaceuticals has one product, Vaxim, that it sells in two nations, Northland and Southland. The...

    Vaxis Pharmaceuticals has one product, Vaxim, that it sells in two nations, Northland and Southland. The marginal cost of producing Vaxim is 0. Northland is a small country with a regulated health care system. Patients obtain all prescription drugs free of charge. Northland’s government purchases exactly 200 units of Vaxim and agrees to pay Vaxis $100 per unit. It distributes Vaxim to local retail pharmacies which receive an additional $10 fee for each prescription filled (making the effective price $110)....

  • Consider the following case study of Pharmacy Service Improvement at a pharmacy. Customers drop off their...

    Consider the following case study of Pharmacy Service Improvement at a pharmacy. Customers drop off their prescriptions either in the drive-through counter or in the front counter of the pharmacy. Customers can request that their prescription be filled immediately. In this case, they have to wait between 15 min and 1 h depending on the current workload. However, most customers are not willing to wait that long, so they opt to nominate a pickup time at a later point during...

  • 1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s),...

    1. Draw an ERD for the following situation. Be sure to show: entity information, attributes, identifier(s), relationships and relationship names, and cardinality Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher may publish one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or...

  • DRAW THE ERD(CDM) AND GENERATE THE RELATIONAL TABLE (PDM) USING POWER DESIGNER. PLEASE COMPLETE EACH ENTITY...

    DRAW THE ERD(CDM) AND GENERATE THE RELATIONAL TABLE (PDM) USING POWER DESIGNER. PLEASE COMPLETE EACH ENTITY WITH ATTRIBUTES INCLUDING PRIMARY KEY AND FOREIGN KEY CONSTRAINTS PROBLEM 3 - Draw an entity-relationship diagram for the following scenario, stating any assumptions you find it necessary to make, and showing unknown cardinalities and optionalities using question marks on the relationship line. Show also the attributes explicitly mentioned in the scenario and underline any you consider suitable candidates for being primary keys. It is...

  • This is about ERD. Question: The Gotham Buildings Department (GBD) is a city agency that tracks...

    This is about ERD. Question: The Gotham Buildings Department (GBD) is a city agency that tracks all the buildings within a metropolitan area in the northeast United States. The GBD maintains data about the location, size, and construction date of each building. It also keeps track of specific renovations made to each building over time, and also demolition of a building, if that occurs. For each building, the GBD keeps data about the building's lot number, which is unique, the...

  • Part I: Creating ER Diagrams PLEASE COMPLETE EVERY QUESTION Question 1 (25 points): Consider the following...

    Part I: Creating ER Diagrams PLEASE COMPLETE EVERY QUESTION Question 1 (25 points): Consider the following scenario. • A Pokémon character has a unique number; a name; stamina, attack and defense values; a date introduced; and one or more moves. • A move has a name, is either quick or special, and has an accuracy and power points. • A Pokémon type has a type name, a description and a type count (the number of characters with that type). •...

  • Create an Entity-Relationship Diagram (ERD). In the ERD include the following:

    Create an Entity-Relationship Diagram (ERD).In the ERD include the following: entities primary keys for all entities attributes - use "good" names for attributes, use only single-valued attributes relationships - use Crow's foot or UML notation; name relationships that could be ambiguous cardinality - minimum (optional/mandatory) and maximum (one or many) on both ends of the relationship - use reasonable assumptions if there is insufficient information in the descriptionStudent/Course registration system for a universityStudents have a unique identification number, first name, middle initial, last name, year...

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