You are doing a consulting project for an educational institution and want to convince them to utilize your software. They currently have limitations using their current software and are in search of a new course management system.

Your task is to create the following tables.

Recodrds#

1. Student 20

2. Faculty 15

3. Course 15

4. Section 25

5. Location 20

Populate each table with the records above making sure each field is unique. (Hint: Use the insert statement). TURN IN: 1. A single script file that contains all the commands used in this lab. The script file should also include a NICELY FORMATTED report for each file. The script file will be used for each subsequent. 2. In addition create at least 1 sequence and apply it to one of your tables. Feel free to use any number of sequences for your other tables as well. Also, create at least 2 indexes for your tables; choose the fields you feel will benefit most from having an index. Feel free to add more. Use the information below for the structure of your tables. Note: N is short for NUMBER, V is short for VARCHAR2, and C is short for CHAR. STUDENT StudentID N(10) FirstName VC(20) LastName VC(20) MI C(1) Address VC(20) City VC(20) State C(2) Zip VC(10) HomePhone VC(10) WorkPhone VC(10) Email VC(20) DOB DATE PIN VC(10) Status C(1) FACULTY FacultyID N(10) FirstName VC(20) LastName VC(20) MI C(1) WorkPhone VC(10) CSCI 2370 - Page 2 CellPhone VC(10) Rank VC(20) Experience VC(20) Status C(1) COURSE CourseID N(10) CourseNumber VC(20) CourseName VC(20) Description VC(20) CreditHours N(4) Status C(1) SECTION SectionID N(10) CourseID N(10) SectionNumber VC(10) Days VC(10) StartTime DATE EndTime DATE LocationID N(10) SeatsAvailable N(3) Status C(1) LOCATION LocationID N(10) Building VC(20) Room VC(5) Capacity N(5) Status C(1)