The Maisha bora Pharmacy have contracted you as a database developer for their integrated stock management systems with those of their suppliers to ensure that every drug has a reorder level upon which the supplier replenishes the stock. They get referrals from hospital for patients to purchase the drugs upon which the pay commissions to the hospital. They require the following reports per month

1. Commission reports to facilitate payments to hospitals

2. Sales reports

3. Stock level reports

4. Stock profitability reports

5. Stock expiry reports

Required:

a) To identify the data will be necessary and sufficient to provide the above reports.

(10 Marks)

b) Draw the ER diagram (5 Marks)

c) Give a criteria that will assist you in purchasing the DBMS (10 Marks)
Using the scenario in question one how would you undertake the following in MySQL
a) create the Maishabora database (2 Marks)
b) create the tables above (5 Marks)
c) Write a function to increase prices of the items that they sell by 5% (4 Marks)
d) Write a trigger to give an alert when the price of a product or quantity is changed in the database (4 Marks)
e) Identify the risks/threats and mitigation measures if the system is web-based
(10 Marks)

Data is processed, stored, and transmitted as a series of 1s and 0s. each 1 or 0 is called a(n) . a series of eight 0s and 1s, called a(n) , represents one character—a letter, number, or punctuation mark. data becomes when it is presented in a format that people can understand and use. digital signals are represented by two different , such as +5 volts and +.2 volts. digital data can also take the form of light and dark spots etched onto the surface of a cd or the positive and negative orientation of particles on the surface of a hard disk. data consists of numbers that might be used in arithmetic operations. it can be represented digitally using the number system. data is composed of letters, symbols, and numerals that are not used in arithmetic operations. computers represent this type of data using , ebcdic, unicode, or utf-8. data is quantified using terms such as or kibibyte (1024 bytes), and prefixes such as or mebi (1,048,576), and giga or (1,073,741,824). to reduce file size and transmission times, digital data can be compressed. compression provides the means to compress data and reconstitute it into its original state. compression throws away some of the original data during the compression process. compressed files usually have at the end of the file name and are represented with special icons. these files have to be or unzipped before you can view the data they contain.

Which of the following has not been attributed at least in part to social media a. drug addiction b. depression c. kidnapping d. murder

Consider the following statements, then select one of the answers below: the signal() function shown below registers "sig_handler()" as the signal handler function for the sigkill signal, without the complexity of using when the sigkill signal is sent to a process running this code, by a user typing "kill -kill ", where the correct process id is used for to target the process, sig_handler() will be executed.