IEE 305 Homework #3 Implement the relational model of the following project into a database using Microsoft Access. The relational model is given below (Page 2). The report should include screenshots of the following information. (25 points) The datasheet view of every table in your Access database о ○ ○ Name the tables using the relation names in the solution. Create and show at least five data records for each table. Put the screenshots in alphabetical order of the table names, or points will be deducted. (15 points) The Relationships view of the Access database. ○ Show the primary key(s) and the foreign key(s) of each table (if any). о Show the relationships between the tables. (60 points) The design view and the query result of every query in the Access database Implement the queries given below (Page 3). о ○ For the design view of each query, present the Table pane and the Design grid. ○ The screenshots must be legible and clearly show your work. ○ Please place the screenshots in the same order of the queries, or points will be deducted. You MUST submit a Word/PDF that includes all screenshots necessary for grading. You also MUST submit your Access file. Relational Model: Instructor InstructorID Name Address Department College Specialty Student StudentID Name Address Birthday Gender Department College Course CourseNo InstructorID Course Title Prerequisites CreditHours CourseLevel NewOffer Register CourseNo StudentID Room RoomNo Location Capacity Featured Desprition Period PeriodNo StartTime EndTime Assign PeriodNo RoomNo CourseNo Queries: 1. Professors are interested to know their weekly schedule. Create a query that prompts for the professors' name and returns their weekly schedule. 2. Create a query that prompts for students' identification numbers and returns their timetables for the current semester. 3. Create a query that prompts for the name of a course and returns its current schedule. 4. For each course offered in the current semester, present the total number of students registered, the classroom capacity, and the classroom description. This query will help to identify possible changes to the timetable due to the class capacity or equipment (computers, video, etc.) availability. 5. Every semester there are a number of new courses offered that have to be assigned to a period/room. a. List all the courses offered for the first time. b. List the eligible periods/classrooms for an unassigned course. This list should adhere to all the business rules given above. 6. For each time period, list the addresses of the classrooms that are available. This list will be given to the professors. In the case that professors do not like their current schedules, they can re-allocate the class in one of the available period/classroom combinations. 7. Create a query that prompts for the name of a department and course level (freshmen, ..., senior) and returns the timetable of the courses for this particular group. The results from this query are used to check whether the courses belonging to this particular group are assigned to the same class period.