Q1) Design a simple database using relational model for Pharmacy medicine management system. The pharmacy contains Medicine (name, product date, expiry date, company, price, quantity). Similar medicine can be manufactured by more than one companies(name, country ). One or more medicine can be used for the treatment of a range of diseases (name, Symptoms of the disease). Q1) Design a simple database using relational model for Pharmacy medicine management system. The pharmacy contains Medicine (name, product date, expiry date, company, price, quantity). Similar medicine can be manufactured by more than one companies(name, country ). One or more medicine can be used for the treatment of a range of diseases (name, Symptoms of the disease)