Create a e-r diagram or uml class diagram, Database Management System

Assignment Help:

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

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

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

  • Basic: who have access to 3 activities that that they have signed up for. Basic membership only allows you to use the facilities at off peak times.
  • Full: who can use any facility at any time. These members may have specified particular activities that they are interested in and which they may be offered special promotions in.

Bookings:
Facilities can be booked for hour slots from when the centre opens 8:00 AM till when it closes at 9:00 PM. Assume 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 should 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 such as

  • 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 submission 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 should include appropriate use of the advanced features of PostgreSQL (a normal relational solution is not acceptable). Please discuss with me if you intend to use a system other than PostgreSQL. Because of the practical nature of the work, databases being identifable in screenshots and possible discussion of systems this will not be an anonymous submission. Your submission should include:

  • A diagrammatic representation of the entities in the system and their relationships (E/R diagram or UML class diagram).
  • Details of the tables/structures etc. that you implemented including suitable types, details of your test data (you should supplement any data given with additional material), and screen shots to show how your system answered the requirements. (This can be from psql (or other simple terminal monitor type interface) you are not required to build any particular interface to the system.)
  • Alternative definitions of the entities for an 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.

Related Discussions:- Create a e-r diagram or uml class diagram

Explain authorization and integrity manager, Explain Authorization and Inte...

Explain Authorization and Integrity Manager ? Authorization and Integrity Manager: Tests for the satisfaction of integrity constraints and checks the authority of users to acce

Structure of the ldb, Though all the ABAP/4 Dictionary Structures that exis...

Though all the ABAP/4 Dictionary Structures that exists in the structure of the LDB, being described in Database Program, we are explaining the Dictionary Structures in the Report.

What is boyce-code normal form, Boyce-Code Normal Form (BCNF) A relatio...

Boyce-Code Normal Form (BCNF) A relationship is said to be in BCNF if it is already in 3NF and the left hand side of each dependency is a candidate key. A relation who is in 3N

Define null value, Define NULL value NULL value NULL means something is...

Define NULL value NULL value NULL means something is unknown. It does NOT mean null (the digit 0). Null is as well employed as attribute value for a particular entity in which

What is a recovery scheme, What is a recovery scheme? An integral part ...

What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.

Define query optimization, Define query optimization. Query optimizatio...

Define query optimization. Query optimization refers to the process of search the lowest -cost method of evaluating a given query.

Distributed transaction atomic-consistent-isolated, A distributed transacti...

A distributed transaction consists of subtransactions that execute at different sites and access local DBMSs at those sites. For example, a distributed transaction that transfers m

Lack of redundancy, Lack of Redundancy We have talked about the problems o...

Lack of Redundancy We have talked about the problems of repetition of information in a database. Such repetition should be stay away as much as possible. Let us state once again t

Describe the algorithm for updating indices, Describe the algorithm for upd...

Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in

Need database normalization and database analysis, Developer is required to...

Developer is required to do a task including: - Database Normalization - Database Analysis - ERM Diagram Details can be provided and then you can change your bid accord

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd