Implement a database that meets the following data requirements for a small college Accommodation Office $.$ Students.

The data needed for each full$-$time student includes id#$,$ name $($first and last$),$ home address $($street$,$ city, postal code$),$ date of birth, sex, category $($e$.$g$.,$ sophomore, junior, graduate$),$ nationality, special needs, current status $($placed$/$waiting$)$ and which courses the student is registered for. Optionally, one may also add additional comments for a particular student.

The student information pertains to those currently renting a room and those who are on the waiting list. A particular student may rent a room either in the hall of residence or student flat.

When a student joins the college, they are assigned a member of staff who acts as his advisor. The advisor is responsible for monitoring the student welfare and academic progress throughout the student$$s time at the college. The data kept for a students advisor includes full name, position, name of the department, phone number and office location$/$number$.$ We assume that there are no two advisors in the same department will have the same name.

Halls of Residence.

Each hall of residence has a name, address, telephone number and a manager who supervises the operation of the hall. The halls provide only single rooms which have room number, place number and monthly rent rate.

The place number uniquely identifies each room in all halls controlled by the Accommodation Office and is used when renting a room to a student.

Student Flats.

The Accommodation Office also offers student flats. These flats are fully furnished and provide single$-$room accommodation for groups of two, three or four students. The information held on student flats includes a flat number, address and the number of rooms available in each flat. The flat number uniquely identifies each flat.

Leases.

A student may rent a room in a hall or student flat for various periods of time. New lease agreements are negotiated at the start of each academic year with a minimum rental period of one quarter and a maximum rental period of one year $($including the Summer quarter$).$ Each individual lease agreement between a student and the Accommodation Office is uniquely identified using a lease number.

The information pertaining to each lease includes the lease number, duration of the lease $($in number of quarters$),$ name and the id# of the student, place number or flat number, address details $($of the hall or the flat$)$ and the date the student wishes to enter the room, along with the date the student wishes to leave the room.

DBFUND $$ Final Project: Designing and Implementing a Database

Invoices.

At the start of each quarter, each student is sent an invoice for the respective rental period. Each invoice has a unique invoice number. The rest of the data include the lease number, quarter, payment due, students full name, students id#$,$ place number or flat number, and the address $($hall$/$flat$).$ Additional data is kept as a Payment, which reflects the invoice number, date of payment, method of payment $($cheque$,$ cash, credit card $($indicate type$))$ plus, if needed, the dates the first and second reminders were sent.

Students Flat Inspections.

Each flat is inspected by staff on a regular basis to ensure that the accommodation is well maintained. The information recorded for each inspection includes name of the staff member who carried out the inspection, the date the inspection was made, an indication of whether the property was found to be in a satisfactory condition $($yes$/$no$),$ plus additional comments, if needed.

Accommodation Staff.

Some information needs to be held for the staff members too, and it includes name $($first and last$),$ home address $($street$,$ city, zipcode$),$ date of birth, sex, position, $($e$.$g$,$ Hall Manager, Administrative Assistant, Cleaner$)$ and Location $($e$.$g$.,$ Accommodation Office or Hall$).$ Here we assume that there are no two staff members having the same name.

Courses.

The Accomodation Office also stores a limited amount of information on the course run by the college course number, course title, year, instructor, room number, and department name. Each student is associated with the courses he is registered for. Here we assume that the course number and the department name can uniquely identify a course.

Contacts.

For each student, the office keeps a record of a contact person, which includes SIN, name $($first and last$),$ relationship with the student, address $($street$,$ city, postal code$)$ and the contact phone number