Assignment No. 03 Semester Fall 2012 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.