I need help with questions c & d of #1 in the homework.  Also if you could give the answer to number 2 part d. That would be helpful as well

CISC437 Spring 2016, Homework 5Due Monday, May 9, at 11:55pm on Sakai.AssignmentThis assignment uses the University database schema; see page 4 for the diagram.1.[60 pts]The tables below show the (abridged) output of MySQLEXPLAINfor three differentSQL queries. For each one,•describe the evaluation plan in words, using phrases like “full table scan”, “scan of pri-mary index”, “scan of secondary index on [fields]”, “primary index lookup”’, “secondaryindex lookup on [fields]”, “block nested-loop join”, “indexed nested-loop join using pri-mary index”, “indexed nested-loop join using secondary index on [fields]”, “externalmergesort”.•write out the relational algebra expression implied by the given evaluation plan.•draw the annotated evaluation tree that matches the evaluation plan (as closely aspossible with the provided information). See Problem 2 for examples of annotatedevaluation trees.(a)EXPLAIN SELECT * FROM student S WHERE S.ID=10+-------------+-------+-------+---------+-------+------+-------+| select_type | table | type| key| ref| rows | Extra |+-------------+-------+-------+---------+-------+------+-------+| SIMPLE| S| const | PRIMARY | const |1 ||+-------------+-------+-------+---------+-------+------+-------+(b)EXPLAIN SELECT S.name, I.name FROM student S JOIN advisor A ON S.ID=A.sIDJOIN instructor I ON I.ID=A.iID WHERE S.deptname=’MATH’+-------------+-------+--------+-----------+--------+------+-------------+| select_type | table | type| key| ref| rows | Extra|+-------------+-------+--------+-----------+--------+------+-------------+| SIMPLE| S| ref| dept_name | const|106 | Using where || SIMPLE| A| eq_ref | PRIMARY| S.ID|1 ||| SIMPLE| I| eq_ref | PRIMARY| A.i_ID |1 ||+-------------+-------+--------+-----------+--------+------+-------------+(c)EXPLAIN SELECT S.name, COUNT(courseid) FROM student S JOIN takes T on S.ID=T.IDJOIN course C ON T.courseid=C.courseid WHERE C.deptname=’CISC’ GROUP BYS.ID+-------------+-------+--------+-----------+-------------+------+----------------+| select_type | table | type| key| ref| rows | Extra|+-------------+-------+--------+-----------+-------------+------+----------------+| SIMPLE| C| ref| dept_name | const|13 | Using filesort || SIMPLE| T| ref| course_id | C.course_id |136 | Using index|| SIMPLE| S| eq_ref | PRIMARY| T.ID|1 ||+-------------+-------+--------+-----------+-------------+------+----------------+(d)EXPLAIN SELECT title, credits FROM Course WHERE courseid LIKE ’CISC%’1

ComputerScienceExpert

(11)

Status NEW Posted 25 May 2017 04:05 AM My Price 9.00

-----------

Attachments

file 1495688768-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer