Assignment 1 Distributed Database

GOVT. MUNICIPAL POSTGRADUATE COLLEGE, FAISALABAD. [email protected]

Assignment 1 Assignment Title : Relational Algebric and SQL Queries Assignment Marks Max Marks : 3 x 5 = 15 Pre Requisite: you should have good understanding of Relational Algebric Operators Task :

si

sna

STUDEN T

ci M

enrol ls

M

age

cna

COURS E

cr_

Write Relational Algebric and SQL Queries of the following queries

List of all Employees who are older than 50 List of all 4 credit hrs courses List of Student names whose age are from 16 to 20 List of Student names who are enrolled in 4 credit hour course Write equivalent algebric query of following query Select sname as ‘Name’

Submission Guideline:

from STUDENT

● Submission Deadline 8th April 2019. ● Zip the entire assignment with above mentioned format. ● You have to submit the hardcopy of this assignment as well. ● The format of Hardcopy template is available here (Take PDF for printing) References: