Reference no: EM1321749
Develop an entity relationship diagram for the case, stating any assumptions you seem as essential.
Case: A conference centre takes the bookings from clients who wish to hold the courses or conferences at centre. When clients make bookings they state how many people are involved in booking, and of these, how many will be resident at time of booking, and how many will require catered or non-catered accommodation at the centre. The centre contains the number of facilities which may be needed by the clients making bookings as follows:
a) There are 400 bedrooms for the clients who will be resident at the time of Course or conference.
b) A maximum of the 250 catered people may be handled at any one time.
c) Six main lecture theatres offering the seating for 200 people.
d) Twenty seminar rooms each are able to accommodate 25 people.
e) Video conference facilities. The video conference facilities contains of four separate video conference networks. Every video conference network has the large screen based in one of main lecture theatres, along with the 3 satellite screens each of which is based in one of the seminar rooms.