State whether the following below are CLUSTERED INDICES or NON CLUSTERED INDICE

Question

State whether the following below are CLUSTERED INDICES or NON CLUSTERED INDICE by using the following diagram below.

1. Application:

2. CECourse:

3. CEProvider:

4. DMQAStaff:

5. DocumentID

6. DocumentStatus

7. Enrollment

8. Instructor

9. InstructorEmployment

10. License

11. License Type

12. Professional

13. Qualification

14. QualificationType

15. Section

For example:

TABLENAME   
(IndexColumnList)    Order (ASC or DESC)    Cluster Status ("Clustered" or "NonClustered")

e.g.

PRODUCTS    
ProductID               ASC    Clustered
ProductName             ASC    NonClustered

ORDER DETAILS
OrderID, ProductID      ASC    Clustered

Professional CE Provide FEN stName stName Provider LastName LastName submit Gende starte Date Address Main Ph ane Numbe Application Enrollment quellifies lment SSN Enrollment Status ioense Type ID Code Renevu License ID Nur Decision Date SectionID Term Qual SSN ApplicationID License Ty Qual Name Section Section structor Provider ID CECourselD Section Number License Degree Type SSN Term School sue Date Null Room icenseTypeID Graduation Date Expiration Date Decision Date Approve dByID ExpirationDate ApplicationID Document Title QualificationType Submission Date Review ByID ApplicantFirst Name Qual cationName ApplicentLast Name DocumentDescription Received From Received Date QualificationID Docume nt Status DMQAStaff DocumentStatusID Received Date Staff ID Not eviewedD Staff FirstName ApprovedDate ines StaffLast Name DisapprovedDate rtmentID pal License ID Renew allD Hire Date Position ID Staff need to relate to LoginID document or qua cation because they approve. One staff member per document. *Determines status Received, ApprovedDate, DisapprovedDate. If the last two are null, then it has been received nstructorEmployment FEI Employment Division cto Instructor1 SSN Instruct arStartDate CE Course QualificationTypeID ourse Name ourse Hou Doc and Qualification License Type Qual Qual nName particular type of license. For that license type, here are the things you have to do.

Explanation / Answer

1. Application:
   ApplicationID        ASC     Clustered
   SSN                   ASC       NonClustered

2. CECourse:
   CECourseId           ASC       Clustered
   CourseNumber       ASC       NonClustered

3. CEProvider:
   FEIN               ASC    Clustered
   ProciderFirstName    ASC    NonClustered
  
4. DMQAStaff:
   StaffId            ASC       NonClusteredClustered
   since there is no primary key for the table DMQAStaff so there will be no clustered index.
  
5. DocumentID
   DocumentID           ASC       Clustered
   QualificationId       ASC    NonClustered

6. DocumentStatus
   DocumentStatusId   ASC       NonClustered
   since there is no primary key for the table DocumentStatus so there will be no clustered index.

7. Enrollment
   EnrollmentId       ASC       Clustered
   Code               ASC       NonClustered

8. Instructor
   InstructorId       ASC       Clustered
   SSN                   ASC       NonClustered

9. InstructorEmployment
   EmployMenId           ASC       Clustered
   FEIN               ASC       NonClustered

10. License
   LicenseId           ASC       Clustered
   SSN                   ASC       NonClustered

11. License Type
   LicenseTypeID       ASC       Clustered
   Name                ASC       NonClustered

12. Professional
   SSN                   ASC       Clustered
   FirstName            ASC       NonClustered

13. Qualification
   QualificationId       ASC       Clustered
   QualificationTypeId   ASC       NonClustered

14. QualificationType
   QualificationTypeId   ASC       Clustered
   QualificationName   ASC       NonClustered

15. Section
   SectionId           ASC       Clustered
   InstructorId       ASC       NonClustered

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.