PDA

View Full Version : CS403 assignment no 5 fall 2010 solution on 29/01/2011



Xpert
01-29-2011, 03:55 PM
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)




Create a simple view showing the names of employees whose designation is ”Instructor”
Create a view to list down employees name and designation of Computer sciences Department
Update view to change designation from instructor to lecturer of employee “Ali hassan”
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
02-03-2011, 07:26 PM
xpert plz upload the solution of this asignment

mrzzubair
02-03-2011, 07:27 PM
hello koi hai kia yahan pe?

mrzzubair
02-04-2011, 02:18 AM
hello r u there?

mrzzubair
02-04-2011, 02:22 AM
hello xpert where are you man.

Xpert
02-04-2011, 04:00 AM
yar i got new job am busy there.

voice_expert84
07-07-2011, 10:30 PM
:smileys75:hahahahahaha
000ooooppppPPPSSsssss

Fawadvu
07-08-2011, 01:11 AM
Enjoy the Sol.......