MySQL Class XI Practical Worksheets
Worksheet 1 (Database Related Commands)
1. Q1.
ALTER TABLE table_name ADD column_name datatype(size);
2. Q2.
ALTER TABLE Customer ADD PRIMARY KEY (CustID);
3. Q3.
ALTER TABLE Hospital ADD Address VARCHAR(100);
4. Q4.
ALTER TABLE Student DROP COLUMN Hobbies;
5. Q5.
ALTER TABLE Student ADD Game_Played VARCHAR(30);
6. Q6.
ALTER TABLE Friends DROP COLUMN Hobbies;
7. Q7.
ALTER TABLE Student ADD Hobbies VARCHAR(50);
8. Q8.
ALTER TABLE Employee ADD empid INT PRIMARY KEY;
Primary key helps uniquely identify records.
9. Q9.
ALTER TABLE Customer DROP PRIMARY KEY;
10. Q10.
ALTER TABLE employees MODIFY name VARCHAR(50);
11. Q11.
A = 4 characters
B = 20 characters (padded with spaces)
12. Q12.
i) Valid attributes: a) RollNo, c) Name
Invalid: b) "Amit" (value), d) 25 (value)
ii) Primary key: RollNo, as it uniquely identifies each student.
Worksheet 2 (Table Related Commands)
13. Q1.
ALTER TABLE table_name ADD column_name datatype(size);
14. Q2.
ALTER TABLE Customer ADD PRIMARY KEY (CustID);
15. Q3.
ALTER TABLE Hospital ADD Address VARCHAR(100);
16. Q4.
ALTER TABLE Student DROP COLUMN Hobbies;
17. Q5.
ALTER TABLE Student ADD Game_Played VARCHAR(30);
18. Q6.
ALTER TABLE Friends DROP COLUMN Hobbies;
19. Q7.
ALTER TABLE Student ADD Hobbies VARCHAR(50);
20. Q8.
ALTER TABLE Employee ADD empid INT PRIMARY KEY;
Primary key helps uniquely identify records.
21. Q9.
ALTER TABLE Customer DROP PRIMARY KEY;
22. Q10.
ALTER TABLE employees MODIFY name VARCHAR(50);
23. Q11.
A = 4 characters
B = 20 characters (padded with spaces)
24. Q12.
i) Valid attributes: a) RollNo, c) Name
Invalid: b) "Amit" (value), d) 25 (value)
ii) Primary key: RollNo, as it uniquely identifies each student.
25. Q13.
CREATE TABLE Player (
PlayerID INT PRIMARY KEY,
Name VARCHAR(30),
Age INT,
Game VARCHAR(20)
);
26. Q14.
(i) OrderId: INT, OrderDate: DATE
(ii) Yes, if datatypes match and no constraints are violated.
27. Q15.
CREATE TABLE Event (
EventId VARCHAR(5) PRIMARY KEY,
EventName VARCHAR(30) NOT NULL,
Location VARCHAR(50),
ClientID INT,
EventDate DATE
);
28. Q16.
i. EventId (Primary Key: unique for each event)
ii. ClientID (can be UNIQUE if clients are not repeated)
29. Q17.
CREATE TABLE Event (
EventID VARCHAR(5) PRIMARY KEY,
EventName VARCHAR(30) NOT NULL,
Location VARCHAR(50),
ClientID INT,
EventDate DATE
);
30. Q18.
SHOW DATABASES;
USE City;
DROP DATABASE Clients;
DROP TABLE Club;
31. Q19.
Use VARCHAR for EName because it saves space with variable-length data like names.
Worksheet 3 (Alter Table Commands)
32. Q1.
ALTER TABLE table_name ADD column_name datatype(size);
33. Q2.
ALTER TABLE Customer ADD PRIMARY KEY (CustID);
34. Q3.
ALTER TABLE Hospital ADD Address VARCHAR(100);
35. Q4.
ALTER TABLE Student DROP COLUMN Hobbies;
36. Q5.
ALTER TABLE Student ADD Game_Played VARCHAR(30);
37. Q6.
ALTER TABLE Friends DROP COLUMN Hobbies;
38. Q7.
ALTER TABLE Student ADD Hobbies VARCHAR(50);
39. Q8.
ALTER TABLE Employee ADD empid INT PRIMARY KEY;
Primary key helps uniquely identify records.
40. Q9.
ALTER TABLE Customer DROP PRIMARY KEY;
41. Q10.
ALTER TABLE employees MODIFY name VARCHAR(50);
