Question: Hello, I need help with the next exercise of SQL. Concept Question 1- Index Placement Consider the following ERD in Figure 1 ITEM RENTAL TAPE
Hello, I need help with the next exercise of SQL.

Concept Question 1- Index Placement Consider the following ERD in Figure 1 ITEM RENTAL TAPE FK1 CUS NUM FK2 TAPE CODE CUS UNAME TAPE COPY TAPE NAME TAPE CHARGE RENT DATE OUT RENT COPY RENT CHG DAY RENT DATE RETURN RENT CHARGE Figure 1 Also, assume the following query is frequently run... SELECT CUS NUM, RENT NUM FROM ITEM JOIN RENTAL ON ITEM.CUS NUM = RENTAL. CUSNUM WHERE CUS LNAME = 'SMITH' - ept Ouesti Specify where indexes should be placed and if the index should be a unique or non-unique index. Explain your response
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
