[Solved]1 Sql File Sql Script Executed Requirements Noted 2 Word Document Contains Translation Req Q37298404
1. .sql file with SQL script that executed the requirementsnoted below
2. The Word document that contains the translation of therequirement to the SELECT statement that executes the requirementsnoted below
1. Use the schoolscheduledb database schema
2. Copy this assignment into a Word Document and provide theTranslation, Cleanup, and SQL that accomplishes the followingrequirements:
– a. “The Dean has received a request from the registrarto provide (for statistical purposes) the marital status of allstudents. This output will provide initial statistical data forfocusing email specific to each marital status group.”. Make sureit looks exactly like the example output (at the back of thisassignment). Hint: CASE condition. 18 rows returned. –
4. Apply the SELECT statements to the MySQL Workbench toaccomplish the requests noted.
5. Be sure and meet both explicit requirements as noted in therequirements statement as well as implicit requirement that areprovided in the output grid.
6. As noted above, post both the Word document with thetranslation statements and the SQL (sql) file that executes therequired query. Both files (only 2 files submitted) must besubmitted into the dropbox by the due date to receive full credit.Note that the one (1) sql file will have all queries (sql)contained in it. There should not be more than one sql fileposted.
7. Outputs for each requirement (request) is shown below.Remember, your query should generate the exact same output(including headers) as shown below. a. Translation: TRANSLATION:CLEANUP: SQL
StudentID FirstName LastName Status 1001 Patterson Single Hamilton Single Stadick Widowed 1002 1003 David Betsy Janice in Single Hartwig Divorced Bishop Single 1005 Scott Elizabeth Hallmark Single Sara Karen 1007 Sheskey Married Smith CLASSES. PK STUDENT SCHEDULES FACULTY CLASSES Staffo PK Status Tenured CPK StartTime FACULTY SUBJECTS STUDENTS…. PK STAFF CPK StFirstName StfState SUBJECTS SttAreaCode Category D FK BuildingCodeK STUDENT CLASS STATUS PK CATEGORIES CategorylD PK MAJORS FACULTY CATEGORIES ElevatorAccess PK CategorylD CPK DEPARTMENTS DepartmentiD PK FK Show transcribed image text StudentID FirstName LastName Status 1001 Patterson Single Hamilton Single Stadick Widowed 1002 1003 David Betsy Janice in Single Hartwig Divorced Bishop Single 1005 Scott Elizabeth Hallmark Single Sara Karen 1007 Sheskey Married Smith
CLASSES. PK STUDENT SCHEDULES FACULTY CLASSES Staffo PK Status Tenured CPK StartTime FACULTY SUBJECTS STUDENTS…. PK STAFF CPK StFirstName StfState SUBJECTS SttAreaCode Category D FK BuildingCodeK STUDENT CLASS STATUS PK CATEGORIES CategorylD PK MAJORS FACULTY CATEGORIES ElevatorAccess PK CategorylD CPK DEPARTMENTS DepartmentiD PK FK
Expert Answer
Answer to 1. .sql file with SQL script that executed the requirements noted below 2. The Word document that contains the translati… . . .
OR
