CBSE · 083Class XII · 2024Section C3 marks
Question 29
2 April 2024 · Computer Science (083)
Consider the table Projects given below :
Table : Projects
| P_id | Pname | Language | Startdate | Enddate |
|---|---|---|---|---|
| P001 | School Management System | Python | 2023-01-12 | 2023-04-03 |
| P002 | Hotel Management System | C++ | 2022-12-01 | 2023-02-02 |
| P003 | Blood Bank | Python | 2023-02-11 | 2023-03-02 |
| P004 | Payroll Management System | Python | 2023-03-12 | 2023-06-02 |
Based on the given table, write SQL queries for the following : (i) Add the constraint, primary key to column P_id in the existing table Projects. (ii) To change the language to Python of the project whose id is P002. (iii) To delete the table Projects from MySQL database along with its data.
Answer
(i) ALTER TABLE Projects ADD PRIMARY KEY (P_id);
(ii) UPDATE Projects SET Language='Python' WHERE P_id='P002';
(iii) DROP TABLE Projects;
Explanation
(i) Adds the PRIMARY KEY constraint to P_id. (ii) Updates Language to 'Python' for P002. (iii) Drops the entire table along with its data.