CS403 assignment no 5 fall 2010 solution on 29/01/2011

[Xpert]

Q 1: Write SQL statements/queries for each of individual scenario given below from the given tables on the next page. 15 marks (3+4+4+4)

1. Create a simple view showing the names of employees whose designation is ”Instructor”
   
2. Create a view to list down employees name and designation of Computer sciences Department
   
3. Update view to change designation from instructor to lecturer of employee “Ali hassan”
   
4. Create a view to show number of courses student “VU001” is studying.
   

Rest please download the attachment.

If any of above query cannot execute then give its reason in one line

[mrzzubair]

xpert plz upload the solution of this asignment

[mrzzubair]

hello koi hai kia yahan pe?

[mrzzubair]

hello r u there?

[mrzzubair]

hello xpert where are you man.

[Xpert]

yar i got new job am busy there.

[voice_expert84]

mileys75:hahahahahaha
000ooooppppPPPSSsssss

[Fawadvu]

Enjoy the Sol.......