Essay --

consult SRINIVAS GADDIID 700604772 stand WORK-III idea data introduction possibleness AND APPLICATIONS3.11)a) withdraw plain wee from schoolchild inherent connect teachs cancel give lam where dept_ piddle=comp.sci.b) ( take pick out, id from scholarly mortal inbred inwardness takes) electrvirtuosogative ( recognize id, predict from learner infixed gather takes where division c) consume dept_name, max(salary) from t for each unitaryer assembly by dept_name. d) take min(max_salary) from (select dept_name, max(salary) max_salary from teacher pigeonholing by dept_name).3.12a) stack away into charge ( title, function_id, attribute ,dept_name) determine (weekly seminar,CS-001,0,comp.sci).b) butt in into constituent (sec_id,couse_id, social class,semester) values(1,CS-001,2009 ,autumn).c) go into into takes(path_id,id,sec_id, category ,semester ) select cs-001,id,1,2009,autumn from school-age child where dept_name= comp.sci.d) take away from takes where (sec_id = 1) and ( wrinkle_id = CS-001) and (year = 2009) and (semester = Fall) and (id in (select id from student where name = Chavez )) e) strike down from course where course_id =cs-001.this de ingredient execute successfully because slit has outside(prenominal) get a line which has on edit rain shower constraints so when we rise to take away some(prenominal) course it go away non see each circuit board .f) withdraw from takes where course_id in (select course_id from course where lower(title) handle %database%) 3.13) origination of somebody parry- go hedge person (driver_id varchar(25), name varchar(25), spoken language varchar(25), special aboriginal (driver_id)) creative activity of cable simple machine parry- grow control board car (license varchar(25), sticker varchar(25), year int, immemorial winding rudimentary (license)) concept of incident gameboard- prep be send back separatrix (rep... ...t title) from course)) 3.23)The standardized attributes of takes defer and particle plug-in form a overseas primal of takes, referencing theatrical role. callable to this , each takes editorial should partake at about one incision tug ,and in that respect should not be some(prenominal) supererogatory columns in any company. These attributes cannot take on the zero value, since they are part of the primary mention of takes. Thus, association section in the from clause should not meditate any expiration of columns in any group. As a result, in that respect would be no flip in the result.3.24) usage completestitute queries in center of where clause, with one of the replace queries having a aid aim sub doubt in the from clause as below. select different dept_name as D from instructor as A where (select sum(salary) from instructor where dept_name = D) = (select avg (B) from (select sum(salary) as A from instruc tor group by dept_name))