Answered step by step
Verified Expert Solution
Question
1 Approved Answer
For the business scenario given below, write business rules that describe all entities given in the problem, relationships, and constraints using the format used in
For the business scenario given below, write business rules that describe all entities given in the problem, relationships, and constraints using the format used in class. Then, draw a fullylabeled ERD in NF that includes the following:
entities
attributes attributes per entity
primary keys
foreign keys
labeled relationships: indicate whether each relationship is mandatory or optional, strong or weak
cardinalities
Write your business rules, Explain your assumptions if any
Create an ERDEERD Then, copy and paste the diagram into this document, Follow the format Crows Foot notation and naming conventions.
Business Scenario:
You were asked to design a database for the business scenario given below:
ABC is a pharmaceutical company that manufactures a large variety of drugs that are sold in pharmacies all across the US
For each drug, the name and the formula must be recorded. In addition, a list of drugs that may cause severe side effects and should not be taken along with it must be provided.
Drugs are categorized or classified according to certain shared effects. The categorization process is premised on these longstanding, medically accepted facts. There are three categories of drugs. Drugs from each of these categories can affect a person's central nervous system and impair a person's normal faculties, including a person's ability to safely operate a motor vehicle.
For all ABC drugs sold at the pharmacies, the sales are recorded to keep track of the prescription that includes the name of the drug, physician's name, patient's name, and the date it was filled. Not all drugs are available in each pharmacy.
A doctor may prescribe the same drug for the same patient many times.xcdcdc
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started