Scribd
Upload
8 views1 page

DBMS Assignment 2

This document outlines an assignment for the DBMS subject at SRTCT's Faculty of Engineering for the academic year 2025-26. It includes various questions related to SQL architecture, SQL queries for a company database, embedded SQL, and explanations of DDL, DML, DCL, TCL commands, joins, and views in SQL. The assignment is to be submitted by August 11, 2025, and is overseen by Ms. Anushka Joshi.

Uploaded by

renughewande2004
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
8 views1 page

DBMS Assignment 2

This document outlines an assignment for the DBMS subject at SRTCT's Faculty of Engineering for the academic year 2025-26. It includes various questions related to SQL architecture, SQL queries for a company database, embedded SQL, and explanations of DDL, DML, DCL, TCL commands, joins, and views in SQL. The assignment is to be submitted by August 11, 2025, and is overseen by Ms. Anushka Joshi.

Uploaded by

renughewande2004
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
You are on page 1/ 1

SRTCT’S

SUMAN RAMESH TULSIANI TECHNICAL CAMPUS – FACULTY OF ENGINEERING,


KHAMSHET
An ISO 9001:2015 Certified Institute
DEPARTMENT OF ARTIFICIAL INTELLIGENCE & DATA SCIENCE

APF-9C Academic Year: 2025-26


Issue No.:02
Revision No: 0 Assignment No- II Semester: I
Rev. Date: 15/06/2018

Class TE Date of Issue 09/8/25

Subject DBMS Date of submission 11/8/25

Topic UNIT II- SQL and PL/SQL Name of Faculty Ms.Anushka Joshi

Q.1 Draw and explain SQL architecture with its characteristics and advantages.
Q.2 Consider following company database :
EMP(Name, SSn, Salary, Supersn, dno)
DEPT (dnum, dname, mgrssn)
DEPT_LOC (dnum, dlocation)
PROJECT(Pname, Pnumber, Plocation, dnum)
WORKS_ON(Essn, dept_name, gender)
Write SQL queries for the following:
i) Retrieve the names of all employees who work in the department that has the employee
with the highest salary among all employees.
ii) Retrieve the names of employees who make atleast 10000 more than the employee who
is paid the least in the company.
iii) A view that has the employee name, supervisor name and employee salary for each
employee who works in the Research' department.
iv) A view that has the project name, controlling department name, number of employees
and total hours worked per week on the project for each project with more than one
employee working on it.

Q. 3 Write short note on embedded SQL along with its applications.

Q.4 Explain DDL and DML,DCL,TCL commands with syntax and example.

Q.5 Explain joins and views in SQL with Examples.

Ms.Anushka Joshi
Subject Incharge

You might also like