Scribd
Upload
80 views6 pages

Database Management Lab Journal 7

The document is a lab journal describing tasks completed in a database management systems lab. The tasks included: 1) Creating a Student table with fields for ID, name, program, and semester; 2) Adding a CGPA column; 3) Inserting at least 8 records; 4) Updating a program field; 5) Renaming the table; 6) Deleting a column; and 6) Performing various operations on a bonus table including deleting rows based on department number criteria.

Uploaded by

Arsalan Ishtiaq
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
80 views6 pages

Database Management Lab Journal 7

The document is a lab journal describing tasks completed in a database management systems lab. The tasks included: 1) Creating a Student table with fields for ID, name, program, and semester; 2) Adding a CGPA column; 3) Inserting at least 8 records; 4) Updating a program field; 5) Renaming the table; 6) Deleting a column; and 6) Performing various operations on a bonus table including deleting rows based on department number criteria.

Uploaded by

Arsalan Ishtiaq
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

Data Base and Management System Lab

CSL-220
 

Lab journal 7
 

Student’s Name: Arsalan Ishtiaq


Enrolment number(s): 01-134182-013
Class: BS (CS) – 4B
 
 
 
 
 

Department of Computer Sciences


BAHRIA UNIVERSITY, ISLAMABAD
Lab #7

Lab Tasks

1. Create a Table Student, it should have the following fields, choose appropriate DATA
TYPES.
 Std_id
 Std_name
 Std_program
 Std_current_semester

Q: Add a new column , cgpa.

2. Insert few records at least 8


3. Update bscs to BS(COMPUTER SCIENCE) in Student Table.
4. Rename table to student_bahria.

5. Delete Std_current_semester column from table.

6. Create a table bonus, delete row when department no is equal to 20, increment bonus
when department no is equal to 10 , delete row where department is between 10 and
20. Delete rows where department number is greater than 20

You might also like