Create the tables in a database to support information for students and their classes. The following data elements should be captured:Student First NameStudent Last NameStudent IDStudents Dorm NameStudents Room number $($at least two of your students should be roommates$)$Students MajorClass NameClass location $($room number is sufficient$)$Class start date $($month and year is sufficient$)$Class end date $($month and year is sufficient$)$Student grade in each class Some requirements for the assignment:Each table should have at least $10$ records.Design should be in $3$NFA diagram created that shows each table, the data types for each table and the relationships to other tables.Database views created that show:List of studentsList of classes for two of your studentsList of every student in three of your dorms I will need to see every SQL statement needed: all DML and DDL for everything above. Upload your solution to Canvas as two files:A text file with a $.$sql extension showing all the SQL statements.A word document with an embedded image showing the diagram.