Ask Question, Ask an Expert


Ask DBMS Expert

Home >> DBMS


To give learners opportunities to develop an understanding of the concepts and issues relating to databases and database design as well as the practical skills to translate that understanding into the design and creation of complex databases.

Learning Outcomes

The assessment offers you an opportunity to demonstrate ability to:

• Understand databases and data management systems
• Understand database design techniques.
• Be able to design, create and document database.


An old-fashioned tennis club in South Manchester, the Southern, has received a cash injection by a group of entrepreneurs.  The facilities have been updated and now include a trendy café-bar, state-of-the art fitness rooms, tennis courts (grass, artificial grass and indoor) and squash courts.  There is now a need to update the club’s computer system, in particular the functions associated with membership and court bookings.

You are to adopt the role of a system developer to produce the deliverables specified in the assignment brief. 

You should however investigate court bookings and membership arrangements at a sports club.

The principal system requirements have been identified as follows:

1. To maintain information on types of membership (the ones identified so far are full, student, OAP, off-peak, junior, racquets only, fitness only);
2. To provide a record of court bookings;
3. To maintain membership details and record subscription payments;
4. To maintain details of courts (minimally type of court ie squash or tennis, type of surface – tennis only, location, comments;
5. To maintain details of coaches (contact details, type of coach, qualifications, awards);
6. To produce management reports (minimally list of members, court bookings per week).

The system is not required to keep detailed accounting information. Make assumptions where it is necessary


Task one (Analysis and Design):

Produce a design of the database that would be suitable to meet requirements.

• List functional requirements for a given problem.
• Discuss ER diagram and Normalisation.
• Draw an ER diagram including labelled relationships, cardinalities and assumptions for Southern tennis club.
• Conduct relational data analysis and normalise your entities to 3rd Normal form.
• A list of the attributes for each entity including descriptions in a data dictionary.

Task two (Implementation):

Produce a database implementation that meets the key requirement.

• Within your system develop a range of sample input and output screens eg tables, forms and reports, dropdown lists, checkboxes, etc.
• Test the database with suitable test data.
• Full details of and justification for, the validation and other integrity controls you propose for the information to be entered into the database.
• Produce a user guide for staff training.
• Reflect on your solution for the identified problem. Discuss possible improvements that could be made to your solution.

Task three:

What is a DMBS?  Include in your discussion how a DBMS could be used in a commercial and non-commercial environment.  Include issues such as the end user, use of database across different platforms and compatibility.

describe in non-technical terms the features and benefits of a database.

In addition the report should contain a contents page, introduction, conclusion and a bibliography of your sources.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91118

Have any Question? 

Related Questions in DBMS

The following assignment is based on the database

The following assignment is based on the database environment designed in the Week Three Individual Assignment. Your database project must meet the following requirements: • Create a database using professional principle ...

A quick guide to pivot tables is found at the end of this

A "Quick Guide to Pivot Tables" is found at the end of this document. Review it BEFORE beginning the questions. The data for this exercise (structured as a flat file) can be found in an Excel workbook located on Blackboa ...

Database design continueduse the attached database to

Database Design Continued Use the attached database to complete the following assignment: You will be modifying the frmMainMenu to call the caption of each button from the table MainMenu and form or the report. 1) Create ...

Database reflectionuse the attached database and associated

Database Reflection Use the attached database and associated sheets to review and to make sure the forms are working. Review your project; make sure that all the forms are working. Write a one page report on how you coul ...

Home libraryisbntitleauthor Home Library I SBN Title Author LastName Author_FlrstName

Home Library I SBN Title Author LastName Author_FlrstName Publisher Date Edition Media 369852 Cosmos Sagan Carl Random House 1980   Book 741258 No Secrets Simon Carly Elektra 1972   CD 654789 Symphony No 3 Dur Eroica Op ...

Assessment item 1taskthe fermoy house databasethe owners of

Assessment Item 1: Task The Fermoy House database The owners of Fermoy House, a Bed and Breakfast guest house in the Blue Mountains of NSW, have approached you to build them a database to help them run their business. Fe ...

Project guidelinesoverviewthe final project for this course

Project Guidelines Overview The final project for this course is the creation of a database proposal and implementation plan report that will address the needs of a given scenario. The purpose of this assessment is to as ...

Itech 1006 - database management systems

ITECH 1006 - Database Management Systems Assignment Overview For this assignment you will implement and query a database from a supplied ER Diagram and Schema. You will be required to write the SQL statements to create t ...

Brief-the aim is that your team should produce a

Brief- The aim is that your team should produce a requirements document that describes the problem to be solved and captures the requirements for an information system that supports the needs of the vehicle pool manager ...

1 what is the difference between a column constraint and a

1. What is the difference between a column constraint and a table constraint? 2. What is a recursive join? 3. Explain the difference between an ORDER BY clause and a GROUP BY clause. 4. What is a CROSS JOIN? Give an exam ...

  • 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