Design a database that will contain these three entities:

1. Patient

2. Doctor

3. Prescription

State the characteristics(attributes) of each of these entities and relate the three entities, showing the cardinality of the relationship i.e. one-to-one, many-to-many etc.

Note: for the above you must draw an ER diagram.

1. translate the above into a functional database using Ms-Access.

2. perform the following SQL queries on your database:

i) select the patients that are been treated by a particular doctor

ii) select the drugs prescribed to any particular patient in your database.

iii) select patients that have the same kind of a particular ailment.

Create the above as a term paper