Assignment 11 For this assignment you will create a database, tables, add test data and perform a query.

1. Create a new database that holds details for course roster information called CourseManagementDB

2. Create 3 tables:

a. Students: here you will have student information

i. Student ID

ii. First Name i

ii. 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. Add test records to the tables (add at least 5 test records for each table)

4. 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

5. 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. 6. Make sure to complete your work on your VM