INTRODUCTION. Student: Bazarbekova M.O. Group: CSSE-131k Accepted: Senior – lecturer Kozina L

COURSE WORK

Topic: Pharmacy

 

Student: Bazarbekova M.O. Group: CSSE-131k Accepted: Senior – lecturer Kozina L. A.

 

Almaty 2014

CONTENTS

INTRODUCTION…………………………………………………………….. 3

Database Design…………………………………………………………….…5

1 SUBJECT AREA ANALYSIS.…………………………......... 4

2 CONCEPTUAL MODELING ……………………………...... 6

3 LOGICAL MODELING..……………………………………. 7

4 PHYSICAL MODELING …………………………………… 12

5 CONTENT …………………………………………………… 12

6 QUERIES …………………………………………………...... 13

CONCLUSION ……………………………………………………………… 17

REFERENCES……………………………………………………………… 18

INTRODUCTION

The theme of my course work Pharmacy. I chose this topic because I considered it most interesting to study. Pharmacy is a special specialized organization of the health system, a producer, packaging, analysis and sale of drugs.
The purpose of my work - the creation of a database pharmacy dosage forms to enhance the effectiveness of its work. Pharmacy - is an important element of drug supply. Pharmacies finished dosage forms involved in selling drugs made at factories manufacturers. Each drug has its own purpose, the entire range of drugs classified into groups: antipyretics, analgesics, cardiovascular, etc.
Pharmacy database should include eight tables, designed for enterprise performance and automate the processing of the results of its activity: drugs prescribed, Income, suppliers, customers, employees and Treatment. The tables are linked, which provides data integrity. The database is intended primarily for employees - a full accounting of goods pharmacy, control of the pharmacy as a whole; for customers - easy to find the right drug; for suppliers - contact each employee.

Developed database includes the following subsystems:

- Medications

- Parish

- Flow

- Manufacturers

- Suppliers

- Orders

- Employees

- Address employees

- Ingredients

- Customer