Assume the following tables are used in a university database.

Student

Course

Grades

Write necessary SQL commands to create the tables. Make valid assumptions about the domains of the attributes, and constraints. Choose appropriate primary and foreign keys.

Write queries to add a few records to each table (at least 2 students, 4 courses, and 3 grades for each student)

Write a query to find all students that failed a specific course (choose a course form your list) in 2021-spring

Given the student ID of a student, print his/her transcript

Deliverables

A report that includes the followings: The SQL queries Screenshots of the outputs of running the SQL commands

Please follow the all instructions carefully