Use the diagram below to write SQL statements for each of the following below an

Question

Use the diagram below to write SQL statements for each of the following below and create sentence along with the SQL statements.

For example:

SENTENCE: List employee hire dates and first and last names in that order.
SQL Statement:

Select HireDate, FirstName, LastName
From Employees
Order by HireDate, FirstName, LastName

1. Process applications

2. Review applications

3. Deny license request

4. Approve license request

5. Renew license

6. Submit application

7. Upload supplement documentation

8. Answer applicant questions/emails

9. Create user profile

10. Send out decision letters

11. Professional complaints

12.CE Providers accreditation

13. Updated government regulations/statues

14. Licensure statistics

15. Number of denials

16. Number of approvals

17. Applications received

18. Number of facilities accredited by National Organizations

19. Disciplinary actions per licensure type

20. suspensions, probation,dismissals

21. Most frequent and most important reports.

22. Licensure statistics (BY MONTH?)

23. Number of disapproved applications

24. Number of approvals

25. Applications received (BY MONTH/YEAR?)

26. Number of licenses renewed (BY MONTH/YEAR?)

27. Less frequent and important reports

28. Professional complaints (qualitative data)

29. CE Providers accreditation (qualiftative data)

30. Updated government regulations/statues (qualitative data)

31. Number of facilities accredited by National Organizations

32. Disciplinary actions per licensure type

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)Sentence: List the people based on License Type
SQL Statement: Select p.SSN, p.FirstName , p.LastName , l.Name as LicenceName

from
Professional p JOIN Application a ON p.SSN = a.SSN

Application a JOIN LicenseType l ON a.LiecenseTypeID = l.LiecenseTypeID where LiecenseTypeID = 'here we need to give the liecense type id'
=============================================
2)Sentence : list the people or application based on entrollment status
SQL Statement : Select p.FirstName ,p.LastName, P.SSN ,e.EntrollmentStatusID,
from Professional p JOIN Enrollment e ON p.SSN = e.SSN where EntrollmentStatusID = 'here we need to give etrollmentstatus id'
=============================================================================
3)Sentence :list the liceses and people whose license expirationDate is today
SQL Statement : Select a.LicenseTypeID,l.LicenseName,p.FirstName,p.LastName
licensing.ExpirayDate from
Professional p JOIN Application a ON p.SSN = a.SSN
Aplication a JOIN LicenseType l ON a.LicenseTypeID = l.LicenseTypeID
Application a JOIN Qualification q ON a.AppicationID = q.ApplicationID
Qualification q JOIN Licensing license ON q.QualificationID = license .QualificationID where license.Expiration = getDate() OR give todays date here
=======================================================================

4) Sentence : List Applications ORDER By decision date

SQL Statement : select ApplicationID,SSN,LicenseTypeID,RenewLicenseID,DecisionDate from Application Order by DecisionDate

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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