Individual Assignment (10%)

In this assignment, you create a database in SQL that holds three tables:

Create a table that holds minimum 10 records on student information including FirstName, LastName, Date of Birth, StudentID, and City. Your information should be entered as the first record of this table.

Create a table of MBA courses in all 4 tiers that UCW offers. This table should have the following fields: CourseTitle, CourseCode, TierNumber, and Credits

Create a table for courses completed by students that that holds data for 5 students who have completed minimum 3 course each. The table should include: StudentID, FirstName, LastName, CourseTitle, CourseCode, Semester, Year, Grade

For each table decide on a Primary key and link tables by a foreign key.

Write scripts for a query that reports a transcript for one of the students (preferably yours) in your database with all the courses that he/she (preferably you) completed in Spring 2022. Save your database with your first name as the file name and upload it on the course page at the end of week 3 before the deadline.