i need Q1) and 3) only please .

The director of the University Accommodation Office requires you to design and implement a database system to assist with the administration of the office. The requirements collection and analysis phase of the database design process based on the Manager's view has provided the following requirements specification for the accommodation office database system: 1. Each hall of residence has a name, number, address, telephone number and a hall manager who supervises the operation of the hall. The halls provide only single rooms, which have a room number, place number and weekly rent rate. 2. The place number uniquely identifies each room in all of the halls controlled by the accommodation office, and is used when renting a room to a student. 3. Students may rent rooms throughout the academic year for various periods of time. Each individual rent agreement between a student and the accommodation office is uniquely identified using a lease number. The data stored on rooms currently rented includes the lease number, date the student started the rent period and date the student wishes to terminate the rent period (if known). 4. The data stored on each student includes: the student number, name (first and last name), home address (street, city/town, and postcode), date of birth, category of student (for example, first year undergraduate (IUG), and postgraduate (PG) and current status (placed / waiting). The student information stored relates to those currently renting a room and those on the waiting list. 5. The accommodation office also stores a limited amount of information on the courses run by the university including: course number, course title, course leader and department name. Each student is associated with a single course / 6. Whenever possible, information on a student's next-of-kin is stored, which includes the name, relationship, address (street, city/town, and postcode) and contact telephone number. Questions: 1) List out the possible Business Rules 2) Identify all the entities, attributes and data integrity from the given scenario. 3) Draw the E-R Diagram to show the relationship between the entities and attributes. 4) Create an appropriate data dictionary 5) Construct a database with appropriate Table, Relationship, form, query and report. The director of the University Accommodation Office requires you to design and implement a database system to assist with the administration of the office. The requirements collection and analysis phase of the database design process based on the Manager's view has provided the following requirements specification for the accommodation office database system: 1. Each hall of residence has a name, number, address, telephone number and a hall manager who supervises the operation of the hall. The halls provide only single rooms, which have a room number, place number and weekly rent rate. 2. The place number uniquely identifies each room in all of the halls controlled by the accommodation office, and is used when renting a room to a student. 3. Students may rent rooms throughout the academic year for various periods of time. Each individual rent agreement between a student and the accommodation office is uniquely identified using a lease number. The data stored on rooms currently rented includes the lease number, date the student started the rent period and date the student wishes to terminate the rent period (if known). 4. The data stored on each student includes: the student number, name (first and last name), home address (street, city/town, and postcode), date of birth, category of student (for example, first year undergraduate (IUG), and postgraduate (PG) and current status (placed / waiting). The student information stored relates to those currently renting a room and those on the waiting list. 5. The accommodation office also stores a limited amount of information on the courses run by the university including: course number, course title, course leader and department name. Each student is associated with a single course / 6. Whenever possible, information on a student's next-of-kin is stored, which includes the name, relationship, address (street, city/town, and postcode) and contact telephone number. Questions: 1) List out the possible Business Rules 2) Identify all the entities, attributes and data integrity from the given scenario. 3) Draw the E-R Diagram to show the relationship between the entities and attributes. 4) Create an appropriate data dictionary 5) Construct a database with appropriate Table, Relationship, form, query and report