Ask Question, Ask an Expert


Ask Computer Engineering Expert

Sports Centre

You are needed to develop an advanced system for a Sports Centre, you are concerned only with representing data discussed below about bookings and members. (The complete system might consists other data and other aspects of the organisation, if you think other aspects are suitable to your design of this part include that information in the discussion section.)


There are a range of activities available like treadmills, rowing machines, weights, static cycles and games rooms like squash courts, badminton courts, table tennis rooms.


We require to keep names, addresses and contact numbers and each member has a unique id allocated to them. We also require to record how long they have been a member ( extra benefits or discounts might be made available on the basis of length of membership). There are two types of members:

• Basic: who have access to 3 activities which they have signed up for. Basic membership only permits you to use the facilities at off peak times.

• Full: who could use any facility at any time. These members might have specified particular activities that they are interested in and which they might be offered special promotions in.


Facilities could be booked for hour slots from when the centre opens 8:00 AM till when it closes at 9:00 PM. Suppose that we are only concerned with bookings for the next week i.e. Monday to Saturday, shut on Sunday. Peak periods are currently 12:00 to 2:00 and 5:00 to 7:00.


The system must be able to produce reports such as:

• a listing of all empty badminton courts on Friday.

• when a basic member can book weights.

answer queries such as:

• Who are the full members with an interest in table tennis?

• Who has been a member longer than 3 years and will be in on Friday?

• Who has booked a particular squash court at 4:00 on Saturday?

and perform functions like:

• transfer a member from basic to full status.

For this coursework you may ignore non-essential attributes and other tables/structures that would be present for other uses of the database.

The project will cover:

• the analysis

• design and implementation in an Object/Relational system

• and issues for implementation in a different type of advanced system. e.g. Object or XML.

The implementation must include suitable use of the advanced features of PostgreSQL (a normal relational solution is not acceptable).

• A diagrammatic representation of the entities in the system and their relationships (E/R diagram or UML class diagram).

• Details of tables/structures etc. which you implemented including appropriate types, details of your test data (you must supplement any data given with additional material), and screen shots to demonstrate how your system answered the requirements. (This could be from psql (or other simple terminal monitor type interface) you are not needed to build any particular interface to the system.)

• Alternative definitions of entities for the Object or XML based solution and a discussion of the advantages and disadvantages of these and the solution you implemented. One topic to be addressed is whether your solution works if the last query had been "Who is playing on a particuar squash court at 4:00 on Saturday?".

• Any assumptions you have made.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M91730

Have any Question? 

Related Questions in Computer Engineering

For the three clusters of fig 78a compute the

For the three clusters of Fig. 7.8: (a) Compute the representation of the cluster as in the BFR Algorithm. That is, compute N, SUM, and SUMSQ. (b) Compute the variance and standard deviation of each cluster in each of th ...

Createnbspan 8- to 12-slide Create  an 8- to 12-slide Microsoft ®  PowerPoint ® training

Create  an 8- to 12-slide Microsoft ®  PowerPoint ® training presentation that would be used to educate new members of your company's desktop support team about their role and their responsibilities related to appropriat ...

From an investors point of view there are tow types of risk

From an investor's point of view there are tow types of risk that exist in the stock market. One is market risk and the other is company specific risk. Can anyone tell me which one can be reduced by diversification? Plea ...

This is the assignmentthere is a diagnosis of a bad video

This is the assignment: There is a diagnosis of a bad video card on a client's computer made by another technician. The client would like to have a new video cardinstalled on the desktop. How would you ensure that the di ...

Create a 7-10-slide powerpoint presentation on the

Create a 7-10-slide PowerPoint Presentation on the challenges of securing information, and list some of today's information security attacks. You may use various sources (scholarly). Be sure to cite any sources used in a ...

Based on your opinion and internet search respond to the

Based on your opinion and Internet search, respond to the following: Research the latest trend of Web technologies and identify one of the two of them. Introduce the technology(ies) you identify to your classmates, discu ...

Suppose we wish to store an n times n boolean matrix 0 and

Suppose we wish to store an n × n boolean matrix (0 and 1 elements only). We could represent it by the bits themselves, or we could represent the matrix by listing the positions of the 1's as pairs of integers, each inte ...

Choose one of the following and write 250 words in your own

Choose one of the following and write 250 words in your own words. Explain changes in management practices related to business processes. Explain changes in management practices related to business roles.

An extreme method of spooling known as staging a tape is to

An extreme method of spooling, known as staging a tape, is to read the entire contents of a magnetic tape onto disk before using it. Discuss the main advantage of such a scheme

Give an application example where global outliers

Give an application example where global outliers, contextual outliers, and collective outliers are all interesting. What are the attributes, and what are the contextual and behavioral attributes? How is the relationship ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate