Project Outline The database design project will be significantly important to your final grade, so you should plan to devote sufficient time to warrant the credit for this project. While some flexibility will be allowed, the following components should generally be included. Features, Forms and Reports. The features included in the project will, of course, relate somewhat to student creativity and effort. However, the following items should be included: tables $($provided$),$ queries, customized reports $($typically with embedded queries$),$ customized forms $($typically with embedded queries$),$ appropriate graphic on the reports$/$forms$,$ a switch board $($navigation system with menu items using command buttons$).$ Forms and reports should be attractive $($possibly with some matching graphics$)$ and functional. Database Design Project Prestige College wants you to develop a database to maintain information about its operation and programs. Based on initial interviews, the following reporting requirements were established as a starting point for database development. The reporting requirements are specified in terms of views that can be implemented as either reports or forms. From the tables in the Access database provided, you need to create a report or form to provide the information in a view. You can create a form or report simply based on a table in the Access database $($e$.$g$.$ View $1),$ but mostly, you need to use JOIN operation for multiple tables by first creating a required query for JOIN operation and then creating a form or report based on the query $($result$).$ For example, for the course information in View $2,$ the course table does not have "Department Name," column, but only "Department Number." So$,$ you need to first create a query $($result$)$ by using JOIN operation between "Course" table and "Department" table and creating a report based on this query $($result$).$ The last thing you may want to do is to simply create an additional table for each of the views presented below. In other words, you should not create any other tables besides the provided tables in the Access database. View $1($form$)$: Information is needed about each department to include the following: Department Number and Department Name, Office Number, and Chairperson $($first and last names only$)$ View $2($report$)$: Information is needed about each course to include the following: Course Number, Course Title, Number of Credits, Department Number $($department number where the course is offered$)$ and Department Name $($department where the course is offered$).$ View $3($form$)$: Information is needed about each major to include the Major Number, Major Name, Department Name $($housing the major$),$ Department Number $($housing the major$),$ Number of Required Credits, Number of Required Semesters, and Minimum GPA to complete. View $4($report$)$: Information is needed about each student to include the Student Number, Student Name, Student Address $($street#$,$ street name, apt #$.$ city, state, and ZIP code$),$ Start Date $($Semester$,$ Year$),$ Major Name $($or Title$),$ Department Number $($housing the major$),$ Department Name $($housing the major$),$ Advisor Name, Advisor Office Number and Advisor Office Phone Number. View $5($report$)$: Information is needed about student past summary records to include the Student Number, Student Name, Number of Courses Taken, Number of Credits Taken, and Grade Point Average. View $6($report$)$: Information is needed about current student schedules to include Student Number, Student Name, and Course Schedule $($to include Course Number, Course Title, and Number of Credits$).$ Assume that the current semester is $"$FA$17"$ View $7($report$)$: Information is needed to show courses that have been completed by the student to include Student Number, Student Name, Course Number, Number of Credits, and Grade for each course attempted by the student. Courses should be grouped by the semester $($or date$)$ that the course was completed. Assume that the current semester is $"$FA$17"$ and you need to display courses completed before $"$FA$17"$ as the grades for the courses currently taken are not known. View $8($form$)$: Information is needed about advisors to include the Advisor Number, Advisor Name, Supervisor's name, Advisor Office Number, Advisor Phone Number, and Advisee List $($list of students being advised by the advisor$),$ Department Number $($the advisor is assigned to$),$ and Department Name $($the advisor is assigned to$).$ View $9($report$)$: Information is needed about each department to include the Department Number, Department Name, Office Number, Office Location $($to include Building Name and Floor$)$ and List of Majors housed in the department, List of Course Numbers and Course Names offered in the department. View $10($form$)$: Information is needed about each office to include the Office Number, Location $($Building Name and Floor$),$ Size $($in sq ft$),$ Capacity $($Max # of Occupants$),$ and List of Occupants $($to include Advisor Names, or Department Name$).$ Students may take more than one course. $1\mathrm{.}1.$ Students can retake a sa Is there a way i couod see views $1-10$ in SQL$/$Query Design using the tables i have provided. Thank you.