Database Management Systems-CS403

Assignment No. 03
Semester Fall 2012
Database Management Systems-CS403
Total Marks: 10
Due Date: 12-06-2012
Objective:
To learn and understand basic concepts of SQL.
Instructions:
Please read the following instructions carefully before solving & submitting assignment:
Assignment should be in your own wordings not copied from net, handouts or books.
It should be clear that your assignment will not get any credit (zero marks) if:
o The assignment is submitted after due date.
o The submitted assignment does not open or file corrupt.
o The assignment is copied (from other student or copy from handouts or internet).
o Student ID is not mentioned in the assignment File or name of file is other than student ID.
o Assignment is not submitted in DOC file.
For any query about the assignment, contact at cs403@vu.edu.pk
GOOD LUCK
1(a). Consider the table below: Marks: 5
Documentary Table
Doc_No Title Ranking YearReleased
1 Hoop Dreams A 1994
2 The Thin Blue Line B 2000
3 Surprise Me A 2004
4 Trouble the Water C 2008
5 Dark Days B 2000
6 Paris In Burning B 1991
You are required to write an SQL statement using SELECT operator, which will give the following resultant
table.
Title YearReleased
The Thin Blue Line 2000
Dark Days 2000
Paris In Burning 1991
1(b). Consider the table below: Marks: 5
Documentary Table
Doc_No Title Ranking YearReleased
1 Hoop Dreams A 1994
2 The Thin Blue Line B 2000
3 Surprise Me A 2004
4 Trouble the Water C 2008
5 Dark Days B 2000
6 Paris of Burning B 1991
7 Man on Wire A 2008
You are required to show the resultant relation that will be produced by the following SQL SELECT statement.
SELECT Doc_No, Title, YearReleased
FROM
Documentary
WHERE YearReleased <>‘2000’;
Upload Instructions:
Please view the document related to assignment submission process provided to you by the Virtual
University to upload the assignment.