Your client is the University Accommodation Office which requires
Ask Expert

Be Prepared For The Toughest Questions

Practice Problems

Your client is the University Accommodation Office which requires

Draw an ER diagram for the following requirements:

Your client is the University Accommodation Office which requires you to design a database to underpin a website needed to help with administration of the office. The requirements collection and analysis phase of the database design process has provided the following requirements specification for the Accommodation Office database: The data stored on each full-time student includes the registration number, name (first and last name), home address (street, city/town, and postcode), date of birth, gender, category of student (for example, first year undergraduate (1UG), postgraduate (PG)), nationality, smoker (yes or no), special needs, any additional comments, current status (placed/waiting), and what degree program the student is enrolled in. The Accommodation Office also stores a limited amount of information on the degree programs run by the University including the degree program title, office telephone number and department name. Each student is associated with a single degree program. The student information stored relates to those currently renting a room and those on the waiting list.

Students may rent a room in a university owned hall of residence. Each hall of residence has a name (unique), 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 and monthly rent rate. The room number within a hall is unique and is used when renting a room to a student.

A student may rent a room in a hall for various periods of time. New lease agreements are negotiated at the start of each academic year with a minimum rental period of one semester (16 weeks) and a maximum rental period of one year, which includes Semesters 1, 2, and the Summer Semester. The data stored on each lease includes the duration of the lease (given as semesters), name, and registration number of the student, hall, room number, address details of the hall, the date the student wishes to enter the room, and the date the student wishes to leave the room (if known). Some information is also held on members of staff of the Accommodation Office and includes the staff number (unique), name (first and last name), home address (street, city/town, postcode), date of birth, position (for example, Hall Manager, Administrative Assistant, Cleaner).

Hint
ComputerA database is a planned grouping of material that has been arranged and is often kept electronically in a computer system. A database management system often oversees a database (DBMS)....

Know the process

Students succeed in their courses by connecting and communicating with
an expert until they receive help on their questions

1
img

Submit Question

Post project within your desired price and deadline.

2
img

Tutor Is Assigned

A quality expert with the ability to solve your project will be assigned.

3
img

Receive Help

Check order history for updates. An email as a notification will be sent.

img
Unable to find what you’re looking for?

Consult our trusted tutors.

Developed by Versioning Solutions.