MYSQL

In this assignment, you’ll extend the toy EMR (Electronic Medical Record) system database demonstrated in class with additional features primarily aimed at identifying Adverse Drug Reactions - also known as ADRs. These occur when two drugs taken together have an unintended and possibly serious side-effect. Over two million ADRs are reported annually resulting in more than 100,000 deaths, so avoiding ADRs is a major healthcare priority. 

1. Add a medications table and populate it with 10 made-up or real medications. The table should at minimum have the following attributes a. A unique identifier (primary key) b. Medication name c. Can be taken if under age 12? (Boolean) d. Can be taken if pregnant? (Boolean) e. Mg per Pill (Double) – milligrams per pill f. Max mg per 10kg (Double) 

2. Add a drug interaction table. If two drugs (medications) are listed together, they should NOT be prescribed together. 

Before starting any MySQL project it is necessary to install MySQL in our pc, here some instruction and link from which you can download and start MySQL.

How to download MySQL:

Please follow given below link to download MySQL.

http://www.mysql.com/downloads/

after download, it, install it and set password as per our choice.

Then go to the mysql bin directory and copy path and then open cmd and change path like:

A database is a collection of data and data is organised in the form of tables. so we can also say database is collection of tables or views or others. we can create any number of tables in the database and each table belongs to a database.

Create a database using the CREATE DATABASE statement.

It throws an error if database already exits.

To avoid the error, use the IF NOT EXISTS option with the CREATE DATABASE statement.

Syntax:

CREATE DATABASE database_name;