KS3111 Final Whrd Snhail, Muhammad Insert Draw Design Layout Reterences Mailings
ID: 3717500 • Letter: K
Question
KS3111 Final Whrd Snhail, Muhammad Insert Draw Design Layout Reterences Mailings Review View Tell me what you want to de File Home Share cut Cupy Fnrmat Painter Fin Replace Select Edr.ng Camibria ab Pasto Dudy Text Ileading 1 Tlleading 2 T List Para.... No Spac. Navigation Given the following schema Primary keys are underlined and highlighted Foreign keys are bold. The meanig of the relations is straighttorward. Search dccument Class[snamctimrogufid Hcadings PgResults Facultyid tname dsptid) ICS 211 Final Fxam Write SQL.queries to answer the following questions: Ouestion 1 (Total 10 Points): Multiple Circle ONLY ONE corract answer. Question ? Tetal 10 Points: TrueFals 5.113 Points) Find the names of all juniors (level JR) who are enrolled in a class taught by faculty 'Sa Eric' Tur each ef the following statee.. 5.2)3 Points) Find the name of the youngest student. Question 4 (lotal 8 Points): Schema A... Qucstion 5 Total 22 Points):SC 5.33 Points) For each instructor, list the instructor name, and the number of classes each instructor leaches Question 6 Tatal 13 Pints: Crash R... 5.4)3 Points) Create a view to include a list of all course names along with the name of the faculty who teaches this course. [i.e., view output includes cname and fname). 4 Question 7 (Total 10 points: Termino... bxclain cleany the tollowinq terms: Qurstinn (Total 9 points: Normali- Questiun 9 (Tatal 10 points Nurnali... 5.53 Points) Find names of students who are not enrolled in any class. (Hint: use NOT IN) 5.6) (1 Points) Create a stored procedure that takes two inputs: a faculty identifier (fid) and number of bonus points. The procedure then updates the Enrolled table by adding the bonus points to the grades of all courses that are taught by faculty with the input fid. 7) (3 Points) Create a trigger to increment the numtaculty attribute ofthe Department table when a new row is inserted in the Facultytable O Type here to search 4/26/2018Explanation / Answer
5.1 :- select sname from Student s,Class c,Enrolled e where s.snum=e.snum and e.cname=c.cname and c.fid='San Eric';
5.2:- select sname,max(date_of_birth) from Student;
Max function will select the date which is recent among the dates. The most recent date is the one who is having youngest age.
5.3:- select cname,fname,count(cname) from Class c,Faculty f where c.fid=f.fid group by fname;
The above query gives the course name, count and the faculty name who teach the course.
5.4:- create view coursefaculty as select cname,fname from Course c,Faculty f where c.fid=f.fid;
The above query will create the view with course details and the faculty name who teach that course.
According to the chegg I am not allowed to answer more than 4 parts please post the remaining as new post.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.