Please assist me with this, I need a SQL statement and how would I do it in MS A
ID: 3561134 • Letter: P
Question
Please assist me with this, I need a SQL statement and how would I do it in MS Access also? Thanks
4. Create the following indexes. If it is necessary to name the index in your DBMS, use the indicated name.
a. Create an index named BoatIndex on the BoatName field in the MarinaSlip table.
b. Create an index named BoatIndex2 on the OwnerNum field in the MarinaSlip table.
c. Create an index named BoatIndex3 on the Length and BoatName fields in the MarinaSlip table and list the lengths in descending order
Explanation / Answer
create index BoatIndex on marinaslip(BoatName);
create index BoatIndex2 on marinaslip(OwnerNum);
create index BoatIndex3 on marinaslip(Lenght desc, BoatName);