-Build the relational model of the database. -Write CREATE TABLE statements and prepare INSERT statements to populate tables with data. -Add cardinalities if possible.

Thank you in advance.

Students The data stored on each full-time student includes: the matriculation number, name (first and last), home address (street, city, state, zip), data of birth, sex, category (e.g. undergraduate, postgraduate), nationality, smoker (yes, no), special needs, additional comments, current status (placed/waiting), and what department the student is studying in. The information relates to the students who are currently renting a room or are on the waiting list. When a student joins the College, he or she is assigned to a member of staff, who acts as his or her advisor. The data held on advisor includes name, position, name of department, phone, and room number Students may or in a flat. rent a room in a hall of residence Halls of Residence Each hal of residence has a name, address, phone number, and a manager, who supervises the hall. The halls provide single rooms, which have a room number, place number, and monthly rent rate. The place number uniquely identifies each room. Student Flats The flats provide single-room accommodation for groups of 3, 4, or 5 students. The information on flats includes a flat number, address, and the number of single bedrooms available in each flat. The flat number uniquely identifies each flat