Based on the database design and report information from previous project sections, explain how you would use SQL commands to generate those reports.

Provide at least $7$ examples of SQL statements that you would use to either pull data from your tables or statements to modify data to a specific format such as date$/$time$.$

Assignment requirement:

The assignment will need to be in an APA format

Assignment length should be $1-2$ pages long, not including the cover and reference page$($s$)$

The assignment should have an explanation of SQL statements and examples of various statements that would be used to generate queries$/$reports for the project.

This content should be added to the paper that was created in Weeks $1,2,3,$ and $4$ Here are the reports. Step $2$: Determining the Fields for Reports

Based on the given reports, we need to determine the fields required to generate those reports.

a$.$ Student Transcript Report: The following fields are needed to generate the Student Transcript Report

StudentID

Name

DOB

Major

CourseID

Title

Credits

Grade

Semester

b$.$ Course Enrollment Report: The following fields are needed to generate the Course Enrollment Report

CourseID

Title

Name $($Student$)$

Semester

Step $3$: Designing the Report Tables

We can create a table to determine which items will be manually typed $($report design$)$ and what fields we want to pull from our tables.

a$.$ Student Transcript Report:

Fields

Description

StudentID

The primary key of the Student table

Name

The Name of the student

DOB

The Date of Birth of the student

Major

The Major of the student

CourseID

The primary key of the Course table

Title

The Title of the Course

Credits

The Credits of the Course

Grade

The Grade of the student in the Course

Semester

The Semester of the Enrollment

b$.$ Course Enrollment Report:

Fields

Description

CourseID

The primary key of the Course table

Title

The Title of the Course

Name

The Name of the student

Semester

The Semester of the Enrollment The picture is of my design.