(Solved) : General Information Dataset Shared Brightspace Dataset 1 Ch10salecosqltxt Ch10salecooratxt Q33299660 . . .
A2
General Information: Dataset is shared on Brightspace Dataset 1: Ch10_SaleCo_SQL.txt/ Ch10_SaleCo_ORA.txt/ Ch10 SaleCo_SQLtxt Marking scheme: (Total 50) Q1:4 +2+2+10 +4-22 points Q2: 5 points Q3: 13 points Q4: 10 points 01. Consider the ERD and the SQL Query. Then answer the questions (i-v) CUSTOMER PK CUS LNAME CUS FNAME CUS INITIAL CUS AREACODE CUS_PHONE CUS BALANCE FK1 CUS CODE NV DATE FK2 P CODE LINE UNITS LINE PRICE is found in V_NAME V CONTACTF V AREACODE Y PHONE V STATE V ORDER P DESCRIPT P INDATE P.Q0H P MIN P PRICE Fig. 1.1: ERD of SaleCo SELECT FROM WHERE ORDER BY CODE, V-NAME, V-CONTACT, V-STATE VENDOR V-STATE = ‘TN’ V NAME; i. What indexes should you create and why? Write the SQL command to create the indexes Show transcribed image text
Expert Answer
Answer to General Information Dataset Shared Brightspace Dataset 1 Ch10salecosqltxt Ch10salecooratxt Q33299660 . . .
OR