please help me solve for them please using the sql

Using the diagram below and the questions, create the T-SQL Statements (or MySQL if you are using that database) that will create the artifacts in the database described. Write your answers as a T-SQL script in SSMS (or equivalent tool) and submit to Blackboard. For inserting the data, you do not have to be meticulous or perfect. Just put the correct data so that the statement will in fact insert data into the table. All the statements below add up to 230 total points. The bonus question is worth 20 points. Department DepartmentID Name Budget StartDate Administrator StudentGrade EnrolmenkID CourseID OnlineCourse CourselD Grade Course URL CourseID Tele Credits DepartmentID OnsiteCourse Person CoursetD Location Days Time LastName HireDate CourseInstructor PersonID OfficeAssignment InstructorID Timestamp 1. 2. 3. Write the statement to create the university database. (5 points) Write the statement to create the Department table. (15 Points) Write the statement to create the Person table. (15 points)