Scribd
Upload
195 views6 pages

Database Management Lab Guide

This lab journal entry summarizes the first lab for the Database and Management Systems course. [1] The lab introduced databases and database management systems. [2] It covered installing and configuring database software. [3] The lab also discussed the importance of the course and its outcomes, and included basic data retrieval queries using SELECT, DISTINCT, AS, concatenation and arithmetic operations.

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
195 views6 pages

Database Management Lab Guide

This lab journal entry summarizes the first lab for the Database and Management Systems course. [1] The lab introduced databases and database management systems. [2] It covered installing and configuring database software. [3] The lab also discussed the importance of the course and its outcomes, and included basic data retrieval queries using SELECT, DISTINCT, AS, concatenation and arithmetic operations.

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 1
 

Student’s Name: Arsalan Ishtiaq


Enrolment number(s): 01-134182-013
Class: BSCS-4B
 
 
 
 
 

Department of Computer Sciences


BAHRIA UNIVERSITY, ISLAMABAD
Lab # 1:
 Introduction to Database and Database Management System
 Installation and Configuration
 Course Outcome and Importance
 Basic Data retrieval queries(Select, Distinct, As, Concatenation and Arithmetic Operations)

1. List all information of ‘Emp’ and ‘Dept’ tables.

Employee table (with name eoe02):

Department table (with name department02):


2. List the empno,ename,jobtitleand hiredate of employee from the employee
table.

3. List the name,salary of the employees who are doctors.

4. List the name,job,salary of every employee joined on ‘December 17,1980’.


5. List name and annual salary of all the employees.

6. List the department name & deptno for departments having deptno.>=10

7. Display employees’ names, salary and manager values of those employees


whose salary is 5000 from EMP table using SELECT statement.
8. Select dname from DEPT table where location is Lahore.

9. Increment the salary of each employee 10 times and then display the annual
salary along with emp#, employee names and dept# from EMP table.

[Link] the employees who have salary between 1000&2000.


[Link] the name,salary, commission of the employees where commission is greater
than their salary.

[Link] the employees who have salary between 1000&2000 (using AND Operator)

If no row is found, try fetching data using different condition.

[Link] the name,monthly salary and daily salary and hourly salary for employee;
assume that there are 22 working days in a month,8 working hours in a day.
Display the rows with column names as monthly,daily &hourly sal.

You might also like