We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>
Assignment No. 05
Total Marks: 15
Due Date: 03/02/2011
To learn and understand basic concepts of “creation and updating” of views.
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit (zero marks) if:
o The assignment is submitted after due date.
o The submitted assignment does not open or file corrupt.
o The submitted assignment is in the format other than MS Word (doc).
o The assignment is copied (from other student or copy from handouts).
o Student ID is not mentioned in the assignment File or name of file is other than student ID.
For any query about the assignment, contact at email@example.com
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)
If any of above query cannot execute then give its reason in one line
Guidelines / Instructions
“Try to upload the assignment before BONUS day”
.+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)
if any one have solved this assignment pl upload it
IN my Opinion, Before doing part 3 write WITH CHECK OPTION below code of part 1 then write the 3rd sloution
as i did in my assignment
aur part 4 ma confusion t wo tariq bhai ne likha he nahi
CS 403 ASSIGNMENT NO = 5
1-CREATE VIEW employee_view1
AS (SELECT Employee Name,Designation FROM Employee
WHERE Designation = ‘Instructor’);
2- CREATE VIEW employee_view2
AS (SELECT Employee Name,Designation From employee
WHERE Department ID = ‘1’);
Set Designation = ‘Lecturer
WHERE Employee Name = ‘ALI’;
4-CREATE VIEW employee_view3
AS(SELECT Student ID,Course Name FROM student
WHERE student ID=VU001);
dear app ny
Student ID and Course Name ko Student table sy call kiya hai think this is worng because Student table main tu Course name attribute hai hi nai.
CREATE VIEW Course_view4 AS (SELECT Student ID, Couse Name FROM Course WHERE Course Name = ‘Vu001')