Assignment 11 For this assignment you will create a database, tables, add test data and perform a query Create a new database that holds details for course roster information called CourseManagementDB Create 3 tables: 1. 2. a. Students: here you will have student information i. Student ID ii. First Name iii. Last Name iv. Date Of Birth b. Courses: here course information will be held i. Course ID ii. Course Name iii. Course Department iv. Course Start Date c. Course Roster: here you will link the students with the course i. Course ID ii. Student ID iii. Registration Date d. Make sure to set the proper data types, primary keys for each table and create the proper relationships between the tables 3. 4. Add test records to the tables (add at least 5 test records for each table) Run a SELECT query that uses all three tables using a JOIN, and output the following: a. Student ID, Student Full name, Course Name, Course Start Date, Registration Date Take screen shots of every step, label them and provide some explanation of the screen shots. Save it into a word document and submit to Assignment 11 Dropbox Make sure to complete your work on your VM 5. 6