Scribd
Upload
3 views3 pages

DB Lab 02 Task

This document outlines the guidelines and tasks for Lab Task 02 of the Database Systems course CL2005 for Spring 2026. Students are required to perform specific database operations on a provided SQLite database file and submit their work as a single PDF file. The document also includes submission formatting instructions and penalties for late or unethical submissions.

Uploaded by

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

DB Lab 02 Task

This document outlines the guidelines and tasks for Lab Task 02 of the Database Systems course CL2005 for Spring 2026. Students are required to perform specific database operations on a provided SQLite database file and submit their work as a single PDF file. The document also includes submission formatting instructions and penalties for late or unethical submissions.

Uploaded by

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

Lab Task: 02

Course Code: CL2005


Course Title: Database Systems - Lab
Semester: Spring 2026
Instructor: Muhammad Mehdi
Email: [Link]@[Link]
Guidelines
●​ Please review the lab manual before starting the task to ensure you fully understand the
requirements.

●​ You may use only the concepts covered in the lab manual to complete this task.

●​ Your submission must be a single PDF file that includes:


●​ The source code (in plain text)
●​ Screenshots of the corresponding outputs

●​ Name your file using the following format: rollno_name_labtasknumber.pdf​


Example: 24p-1234_ozair_labtask02.pdf

●​ Unethical use of AI tools will result in a deduction of 5 marks.

●​ Late submissions will incur a penalty of -1 mark per day.

Tasks
You are provided with a database file named tech_servey.db, which contains a simplified,
real-world subset of the Stack Overflow Developer Survey dataset.

Open the given database in SQLite and perform all the specified database operations on the given
dataset.

1.​ Add a column education_level.

2.​ Rename table developers to dev_survey.

3.​ Rename column salary_usd to annual_salary.

4.​ Drop column education_level.

5.​ Insert all columns for one record.

6.​ Insert specific columns only for one record.

7.​ Insert 3 rows in one statement.


1
Database Systems - Lab
8.​ Update salary of developers from Pakistan by +10%.

9.​ Update framework to NULL where database_used is NULL.

10.​Change the primary language of dev_id = 5 to Python.

11.​Delete developers with experience < 2 years.

12.​Delete developers whose salary is NULL.

2
Database Systems - Lab

You might also like