Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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.)

Activities:

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.

Members:

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.

Bookings:

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.

Requirements:

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

A discrete elevator can sense the following information

A discrete elevator can sense the following information about its world: 1. What floor the elevator is stopped at. 2. What floors passengers in the elevator want to go to. 3. What floors passengers outside of the elevato ...

1 evaluate the worst case time-complexity of the sparse

1. Evaluate the worst case time-complexity of the Sparse Matrix ADT implemented in Programming Project 9.7. 2. Provide the code to implement the four basic operations - traversal, search, insertion, deletion - for an uns ...

A simple strategy for aborting g-machine instructions when

A simple strategy for aborting G-machine instructions when page faults occur would be simply to reset the G machine's program counter and stack pointer to the values they had when the current instruction began to execute ...

In a network using the go-back-n protocol with m 3 and the

In a network using the Go-Back-N protocol with m = 3 and the sending window of size 7, the values of variables are S f = 62, S n = 66, and R n = 64. Assume that the network does not duplicate or reorder the packets. a. W ...

1 analyze the quick sort algorithm to show the worst case

1. Analyze the quick sort algorithm to show the worst case time is O(n 2 ). 2. Analyze the mergeVirtualSeq() function and show that it is a linear time operation in the worst case. 3. Analyze the linked list version of t ...

1 how would you fi x the false sharing issue that can

1. How would you fi x the false sharing issue that can occur? 2. Consider the following portions of two different programs running at the same time on four processors in a symmetric multicore processor (SMP). Assume that ...

Research the internet to determine if there are any ddbmss

Research the internet to determine if there are any DDBMSs that follow all 12 rules. Explain on examples.

Compare the performance of shell sort implementations that

Compare the performance of shell sort implementations that use respectively the sequence of decrements n/2, n/4, n/8, ..., 1 and 2 P -1, ..., 31, 15, 7, 3, 1. Use random data sets and use the number of comparisons and mo ...

1 from the knowledge you have acquired in this chapter

1. From the knowledge you have acquired in this chapter about virtualization, discuss the future of virtualization as a business model. 2. Compare and contrast the security concerns in a virtual network infrastructure an ...

1 using the cidr notation show the ipv6 address compatible

1. Using the CIDR notation, show the IPv6 address compatible to the IPv4 address 129.6.12.34. 2. Using the CIDR notation, show the IPv6 address mapped to the IPv4 address 129.6.12.34. 3. Using the CIDR notation, show the ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen