I need my assignment completed transferring from the PDF to Word document. First 3 questions is answering in 1-3 sentences. 4-7 is writing SQL queries to each question.

 

ISM 218 - Database SystemsAssignment #10Questions 1-3 are worth 3 points each and should be answered in 3-5 sentences.1. What is an index? How is used in a database? Which type of column would make an ideal index?2. Can an index be created in any table? Why would you NOT want to create an index in a table?3. What is a sequence? Why are sequences used? What are some issues that occur when using sequences?Questions 4-7 are worth 4 points each.4. Write the code to create a new table as shown below and create an index on the Project_Name column.Table Name:ManagerColumn Name: ManagerIDManager_NameProject_IDProject_NameKey Type:Primary KeyNull/Unique:Not NullNot NullNot NullFK Table:FK Column:Data Type:INTEGERVARCHARINTEGERVARCHARMax Length:7307305. Write the code to create an index on the Project_ID column of the Manager table.6. Write the code to remove the index on the Project_Name column of the Manager table.7. Write the code to create a new table as shown below and create a sequence on the Patient_ID column.Table Name:PatientColumn Name:Patient_IDP_NameKey Type:Primary KeyNull/Unique:Not Null, UniqueNOT NULLFK Table:FK Column:Data Type:INTEGERVARCHARMax Length:730

Attachments:

• 1492958751-ISM218_Assignment-10.pdf