CS403 Assignment No. 5 Announced

Assignment No. 05 

Semester Fall2010

Database Management Systems-CS403

Due Date: 03/02/2011

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.