Activity: DB Design and E-R diagram

(no submission)
Purpose:

Consider the following scenario for Prescriptions-R-X

The Prescriptions-R-X chain of pharmacies has offered to give you a free lifetime supply of medicine if you design its database. Given the rising cost of health care, you agree. Here's the information that you gather:


  1. Draw an E-R diagram that represent the database scenario. Include an indication of the cardinality of relationships and specify any mandatory relationship (total participation). State any assumptions that you make.
  2. Convert the E-R diagram to tables, using schema statements



Copyright © 2022 Upsorn Praphamontripong

Released under the Creative Commons License CC-BY-NC-SA 4.0 license.

Last updated 2022-08-31 13:04