Database Management System

The Assignment:

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)

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

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

List all the reader's detail whose department is Management or Computer Science.

List all the magazines whose return date is '12/12/2006'.

Alter deptName to "Computer Science" where deptNo is 2.

Delete ISSUE records where magNo is 111.

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

Purposes:

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