VU Hints is the foremost breadwinner of online homework support for university, colleges, and high school students. Obtain exercise support and answers to your hardest problems in computer sciences, mathematics, physics, chemistry, bio, engineering, accounting, English, essay writing support, business studies, humanities, and other. Master your exercise tasks with our stress-free answers to more than 250 recommended textbooks of colleges, and universities. If we don’t support your textbook, don’t worry! You can request ANY exercise inquiry and obtain professional exercise support in as 24 hours before. Our wide available study network is complete up of universities, and college’s students, professional teachers, professors, and subject fans that fund to our galactic group of study resources: textbook solutions, study guides, training tests, training problems, lecture handouts, equation sheets and other. With VU Hint’s support, your assignments will not once be the similar!

Friday, February 4, 2011

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”
SELECT EmployeeName, Designation, FROM Employees
WHERE Designation = 'Instructor'

  1. Create a view to list down employees name and designation  of Computer sciences Department 
SELECT EmployeeName, Designation, DepartmentID, FROM Employees
WHERE DepartmentID = '1'

  1. Update view to change designation from instructor to lecturer of employee “Ali hassan”
SELECT EmployeeName, Designation, FROM Employees
WHERE Designation = 'instructor' OR Designation= 'lecturer')

  1. Create a view to show number of courses student “VU001” is studying.
SELECT CourseID, StudentID, FROM Employees
WHERE StudentID IN (' VU001')
Posted by Naatc Job Solutions at 9:57 AM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)