Design entity relationship diagram for catered accommodation- Software Engineering
Q1) Design an entity relationship diagram for the case, explaining any suppositions you deem important.
Case: A convention centre takes bookings from shoppers who want to maintain programs or conferences on the centre. When shoppers make bookingsthey specify how many individuals are included within the reserving, and of those, what number of shall be resident in the course of the reserving, and what number of would require catered or non-catered lodging on the centre.
The centre comprises quite a few services which can be required by shoppers making bookings as follows:
A. There are 400 bedrooms for shoppers who shall be resident in the course of the Course or convention.
B. A most of 250 catered individuals might be dealt with at anyone time.
C. Six principal lecture theatres offering seating for 200 individuals.
D. Twenty seminar rooms every in a position to accommodate 25 individuals.
E. Video convention services. The video convention services consist of 4 separate video convention networks. Every video convention community has a big display screen primarily based in one of many principal lecture theatres, together with three satellite tv for pc screens every of which relies in one of many seminar rooms
