Database System BS 5 Semester/Term PU — University of the Punjab 2013
Discussion
Ask a question about this paper, or help someone else with theirs. Answers are emailed to whoever asked.
No questions yet — be the first to ask.
Need a paper or stuck on a question? Ask here — students reply and you get an email.
Ask about a paper-
BS ZOOLOGY first semester Animal diversity ZOOL 101 - university of Punjab 2025
0 replies Reply → -
Literary criticism
1 reply Reply → -
this paper consists of 60 marks but now we have 35 marks paper.
1 reply Reply → -
Can you please tell me more past papers please because my exams are starting from next week
1 reply Reply → -
Did you provide the past papers of the science of society uos?
1 reply Reply →
More Database System papers
See all
Database System ADS 4 Semester/Term 2021
Uploaded 11 hours ago · by Nargis
Download ↓
Database System BS 4 Semester/Term PU — University of the Punjab 2024
Uploaded 1 day ago · by Muskan
Download ↓
Database System ADP/B.Sc/BA PU — University of the Punjab 2020
Uploaded 1 day ago · by Muskan
Download ↓
Database System BS 4 Semester/Term PU — University of the Punjab 2025
Uploaded 1 day ago · by Muskan
Download ↓
Database System BS 4 Semester/Term UOS — University of Sargodha 2017
Uploaded 1 day ago · by Muskan
Download ↓
Database System BS/MPhil Computer Science/MS Computer Science 4 Semester/Term UOS — University of Sargodha 2024
Uploaded 2 days ago · by Hifza
Download ↓
Paper text
PAPER: Database Systems (CMP)
Course Code: IT-304
UNIVERSITY OF THE PUNJAB
Fifth Semester 2013
Roll NO.
Examination: B.S. 4 Years Programme
TIME ALLOWED: 2 hrs. & 30 mins.
MAX. MARKS: 50
Attempt This Paper on Separate Answer Sheet provided.
SUBJECTIVE TYPE
Q2: Answer the following short questions.
(15 marks)
IL
I1L.
Write a query to show the location & name of those whose salary is less than the salary of King.
Show the salary Grade of all employees whose salary is greater than the salary of King. Ford and Michel.
Show the name and job title of all those employees whose name is containing 2' or at fifth place having 'S'
or starting with " or having two A's in it and job title is greater than Accounts.
Display the name of all those employees who join the company after six month of King and currently
serving in Lahore.
Display the name of those employees whose salary is greater than average salary of all departments and
less than the salary of maximum salary of all departments.
Schema:
Emp (Empno, Ename, sal, comm, deptno, mgr, job, HireDate)
Dept (Deptno, Dname, Lor)
SalGrade (Hisal, Losal, SalGrade)
Q3: Normalize the relation given below in 2e4 normal form
(10 marks)
Name
Age
Student
NIC
CourseName
Grade
Skills
CourselD
