Design entity relationship diagram for catered accommodation

Assignment Help Software Engineering

Reference no: EM1346112

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.

Reference no: EM1346112

Questions Cloud

Explaining concept of internet-first printing presses-mass : A number of historians explain concept of the internet as parallel to concept of first printing presses - mass communication.

Group to manage the md on call system : Would be the perfect group to manage the MD on call system and what are the possible problems and solutions that group may meet during managing the MD on call system?

What is the horizontal component of the force : A 700 N car traveling at 25m/s.The breaks are applied suddenly and the car slides to a stop. The average breaking force between the tires and the road is 7100 N.How far will the car slide once the breaks are applied.

Find the investing amount : An individual who is 22 years old wins an amount of 5000$. He invests the money at 8% compounded quarterly for 43 years until he stop working. When he retires he invests the money at 7 percent compounded monthly.

Design entity relationship diagram for catered accommodation : Design an entity relationship diagram for the case, explaining any suppositions you deem essential for atered or non-catered accommodation at the centre.

Elucidate how the proposed carbon tax for australia : elucidate how the proposed carbon tax for australia would help reduce negative externalities, pollution levels in australia.

Ppp theory on the price of beef in great britain : Assume the price of beef is anticipated to rise to $3.10 in United States and to £4.65 in Britain. What should the one-year forward $/£ exchange rate be?

What positions are the intensity maximum and minimum : A wooden raft has a mass of 81 kg. while empty it floats in water (density 1000 kg/m3) with 64% of its volume submerged. What mass of sand can be put on the raft without it sinking.

Financial reporting decisions : Corporations are required to file financial reports. Explain what factors other than financial reporting and investor relations are affected by a firm's financial reporting decisions?

User Account

All Pages