Pages

Thursday 7 June 2012

cs403 Assignment no 3 Spring 2012 Idea Solution


Total Marks: 10
Due Date: 12-06-2012
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
ParisIn 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
ParisIn 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
Parisof 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’;