1. Create the table used in the video - Phonebook (LastName,FirstName,PhoneNumber) Video link :https://www.youtube.com/watch?time_continue=1&v=ITcOiLSfVJQ&feature=emb_logo 2. Add at least 5records to...

1. Create the table used in the video -Phonebook(LastName,FirstName,PhoneNumber)

Video link :https://www.youtube.com/watch?time_continue=1&v=ITcOiLSfVJQ&feature=emb_logo

2. Add at least 5records to the table

3. Create a Clustered Index

3. Create a Non Clustered Index

What to submit:

a. A single query filewith all SQL queries written - Create + Indexes

b. Be sure to addthe appropriate header details as comments

c. Be sure to comply with the correct naming convention of the file - firstnameLastname_Module9Assignment.sql