Question

Given below is a Table Patient :

        **Table : PATIENT**

| P_No | Patient Name | DocID |
| 1 | Neerj | 101 |
| 2 | Mohit | 201 |
| 3 | Ragini | 101 |
| 4 | Mohit | 102 |
| 5 | Nandini | 201 |

(i) Identify Primary key in the table given above.

(ii) Write MySQL query to add a column department with data type Varchar and Size 30 in the table Patient.

Answer 1

(i) P_No

(ii) ALTER TABLE Patient ADD (Department varchar(30));