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
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