6. Queries
Retrieve a list of all commands;
select * from Medications;
Here we selected list of all Medications;
Retrieve a list of players of a certain team;
select
name_drug || ' ' ||brief_abstract as astr, manufacturer
from Medications
where med_id = '003';
Receive full information about a particular player (coach, judge);
select *
from Medications
where Medications.brief_abstract like 'ot%';
Obtaining statistics of a particular player;
select
name_drug|| ' ' ||brief_abstract as manufacturer
from Medications
where name_drug like 'an%';
Receipt of the standings;
select
med_id ,
name_drug ,
brief_abstract,
manufacturer
from Medications
where Medications.med_id = Medications.med_id;
Obtain information about a tours particular year;
select *
from Parish
where quantity like '5%';
Getting table matches;
select
t.city,
i.name as first_m
from Manufacturers t, Flow m, Suppliers i
where t.med_id = m.med_id and m.med_id = i.med_id
Conclusion
Database is useful in various organizations, and pharmacy - is no exception. For the pharmacy as a trading institution is characterized by a high degree of accountability. Considering the large amount and rate of turnover, the specific requirements for its storage and sale, it is very important to establish a fast and high-quality data collection, processing and analysis of information relating to the business of pharmacy. Creating a database will allow the pharmacy to collect all the data in one place and provide access to them to all employees as well as customers and suppliers, would allow for a clear-structured account of all the information to provide fast access to it will help to automate standard processes and as a result all optimizes all pharmacies. The introduction of computer systems in pharmacies has become necessary in view of the ever increasing flow of information, in which all employees are obliged to navigate in order to qualitatively carry out their duties. And to do it is becoming increasingly difficult, given the ever-expanding and renewed range of drugs and parapharmacy, not to mention such factors as the presence in the domestic pharmaceutical market a huge number of intermediary firms, effective interaction which can not be achieved without the use of computer technology.
As a result, on the basis of the problem posed in the work, developed a database Pharmacy, ready for use. But, as with any other software tool, it can be added and edited.