Database Management System CS403

Write SQL queries for the following relations

LANGUAGE (langNo, langName)

NATION (nationNo, nationName)

MAGAZINE (magNo, magName, startDate, langNo, nationNo)

ISSUE (readerNo, magNo, borrowDate, returnDate, comment)

READER (readerNo, readerName, deptNo, address, birthDate, phone, email)

DEPARTMENT (deptNo, deptName)

a)Add a new language with the id = 9 and name Punjabi.

b)List all the reader names in ascending order whose phone no starts with 0333.

c)List all the readers detail whose department is Management or Computer Science.

d)List all the magazines whose return date is 12/12/2016.

e)Alter deptName to Computer Science where deptNo is 2.

f)Delete ISSUE records where magNo is 111.

g)List all the READERs along with the magName they got issued.

Purposes:

oThis assignment has been designed so that you understand the concept of SQL

Before Starting:

Go through lesson 27 - 30

Note: Try to solve assignment your self if it is found that your assignment is copied with other student. Then both assignments marked as zero. Dont put assignment related question on MDB. For any further quarries about assignments mail at :

No assignment will be accepted after due date via email.