Case Study The UniPharma chain of pharmacies has offered to give you a free lifetime supply of medicine if you design its database. UniPharma is a small medium enterprise (SME) in terms of company...

Case Study
The UniPharma chain of pharmacies has offered to give you a free lifetime supply of medicine if you

design its database. UniPharma is a small medium enterprise (SME) in terms of company structure

and has four (4) pharmacies in the Auckland region. Being an SME, they would like to keep their

costs down but also to have an efficient solution to manage their back office administration.
Task 1: Business Concepts (Total 30 Marks) 1. What systems could you choose from to store the data? If you prefer one over the

other give at least five (5 ) advantages to support your choice keeping in mind the

company structure.  (10 Marks) 2. Considering the dynamics of managing this  IT project do a comparative analysis of

the three (3) types of DBMS and choose the most suitable option. (10 Marks) 3. After selecting a DBMS, what are the software development life cycle steps to be

taken to start building a DBMS based software application? (10 Marks)
Task 2: Database Design (Total 30 Marks)

Here is some more information to help you out with the case study: • Patients are identified by a Social Security Number (SSN), and their names, addresses, and

ages must be recorded.

• Doctors are identified by an SSN. For each doctor, the name, speciality, and years of

experience must be recorded.

• Each pharmaceutical company is identified by name and has a phone number.

• For each drug, the trade name and formula must be recorded. Each drug is sold by a given

pharmaceutical company, and the trade name identifies a drug uniquely from among the

products of that company. If a pharmaceutical company is deleted, you need not keep track

of its products any longer.

• Each pharmacy has a name, address, and phone number.

• Every patient has a primary physician. Every doctor has at least one patient.

• 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 prescribe drugs for patients. A doctor could prescribe one or more drugs for several

patients