Subject Area Analysis

In this first stage of our database creation, we have described all the work that we must carry out (from what will be our base and limit what he has, what requests we will be able to perform). At this stage, the construction of the database, we studied: each base consists of entities and attributes, and entities that are related to each other and in the future it using attributes.

The database was created for the Pharmacy. As for the players and for the fans of different teams. The database information necessary for the preparation, annotation, storage, date of receipt, the parish, the balance at the end of the month, manufacturer, supplier.

I was amounted on the following specific criteria my database:

- Some drugs are not sold without a doctor's prescription.

- Subsidized medicines is released with a medical prescription.
My database consists of the following entities and attributes:

· Medications - (med_id, name the drug, brief abstract, the manufacturer, storage)

· Parish (med_id, date of receipt, quantity, supplier, purchase price)

· Flow (med_id, preparation date sale, quantity, selling price)

· Manufacturers (med_id, name, city)

· Suppliers (med_id, name, city)

· Orders (ord_id, name, order, period end)

· Employees (emp_id, name, position)

· Address employees (emp_id, name, address, phone, email)

· Ingredients (ing_id, name, ingredient)

· Customer (cust_id, name, date order, date completion, telephone)

I can derive the following requests from the database:
• Get a list of all anatotsy;
• Get a list of the date of receipt of the drug;
• to obtain complete information balance at the end of the month;
• Get a list of all suppliers;
• Get a list of companies-producers;