Design entity relationship diagram for catered accommodation- Software Engineering
Q1) Design an entity relationship diagram for the case, explaining any suppositions you deem essential.
Case: A conference centre takes bookings from clients who wish to hold courses or conferences at the centre. When clients make bookingsthey specify how many people are included in the booking, and of these, how many will be resident during the booking, and how many will require catered or non-catered accommodation at the centre.
The centre contains a number of facilities which may be required by clients making bookings as follows:
A. There are 400 bedrooms for clients who will be resident during the Course or conference.
B. A maximum of 250 catered people can be handled at any one time.
C. Six main lecture theatres providing seating for 200 people.
D. Twenty seminar rooms each able to accommodate 25 people.
E. Video conference facilities. The video conference facilities consist of four separate video conference networks. Each video conference network has a large screen based in one of the main lecture theatres, along with 3 satellite screens each of which is based in one of the seminar rooms