Scribd
Upload
7 views7 pages

DBMS1

The document outlines a lab work assignment for a Database Management System (DBMS) course at Trinity International School & College in Kathmandu, Nepal. It includes practical sessions where students are required to create, manipulate, and manage databases and tables, specifically focusing on an 'EMPLOYEE' and 'student' database. The tasks involve creating tables, inserting records, querying data, updating records, and altering table structures.

Uploaded by

95tfyfrgy9
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views7 pages

DBMS1

The document outlines a lab work assignment for a Database Management System (DBMS) course at Trinity International School & College in Kathmandu, Nepal. It includes practical sessions where students are required to create, manipulate, and manage databases and tables, specifically focusing on an 'EMPLOYEE' and 'student' database. The tasks involve creating tables, inserting records, querying data, updating records, and altering table structures.

Uploaded by

95tfyfrgy9
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 7

TRINITY INTERNATIONAL SS & COLLEGE

Dillibazar Height, Kathmandu, Nepal

LAB WORK #1: DBMS

(COMPUTER SCIENCE)

SUBMITTED BY: SUBMITTED TO:

NAME: AFSAR KAMAL

GRADE: XII (MD2)

DATE : 2081/05/01 PRAVEEN KOIRALA

Faculty of Computer Science

KATHMANDU, NEPAL
2024
WORK DONE
A. Database practical session-1

a) Create a database named ‘EMPLOYEE’.

b)
Get inside the database.

c) Create a table named ‘employee’ with following fields.

d.
Delete the table.

e. Know whether that deleted table exists or not.

f. Delete the database which you have created.


g. Know whether that deleted database exists or not.

B. Database practical session-2

a. Create a database named ‘student’.

b. Create a table ‘student’ with following fields.

Student_id--------------integer not null primary key auto increment

Student_name---------varchar(100)

Student_address-------varchar(100)

Student_grade----------integer(int)
c. Insert any 6 records using ‘insert’ and ‘values’ command.

d. Display all the records of all fields. (Use select *)

e. Display all the records of fields’ student_id and student_name.


f. Display records of students whose name starts with letter ‘a’.

g. Display records of students whose name ends at letter ‘y’.

h. Display all the records of students whose grade is 12. Use ‘where’ command.

i. Display all the records of students whose grade is 12 and who are from address
“Kathmandu”. Use ‘and’ operator.
j. Update the student’s name with any other name who has id 1.

k. Delete the record of student whose id is 3.

l. Display the records of students in sorted order using field ‘student_name’. Use
‘order by field name asc/desc’.
m. Alter the table with following fields.

Add one more field student_section---varchar(100). [Use alter and add command]

Change the size of field student_address--200 [Use alter and modify command]

You might also like