Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Aim

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.

Scenario

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

Activities:

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

Taskoverview of business casealive amp boating aampb is a

Task Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the availa ...

Assignmentdeliverablesall files are located in the

Assignment Deliverables All files are located in the subdirectory of the project. The project should function as specified: When you visit the Personnel form page (frmPersonnel.aspx), a record should be saved in the tblU ...

Save a copy of the tal distributors database located within

Save a copy of the TAL Distributors database located within the Shared Files of the course. You will use this copy to create indexed fields in your database. The current TAL Distributors database only has a few customers ...

Database in-class assignment normalizationfor the following

Database In-class Assignment Normalization For the following table, list the functional dependencies and create a database from the table that is in BCNF and 4NF. Movie Rating Showtime Theater The SpongeBob Movie PG 4:00 ...

Relational databases with ms access1 create a table

Relational Databases with MS Access 1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run 2) Your code (for the button) will dynamically read the caption from the table and assign it t ...

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

Data analysis assignment- apriori analysis and cluster

Data Analysis assignment- ApriorI analysis and Cluster analysis CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" s ...

Moving average forecasting modelsmoving average forecasting

Moving Average Forecasting Models Moving average forecasting models are powerful tools that help managers in making educated forecasting decisions. A moving average is mainly used to forecast short historical range data. ...

Data information decision please respond to the

"Data Information Decision" Please respond to the following: • With the obvious pace of current technology development, data continues to grow daily. Imagine that you are a Database Administrator for a large organization ...

Assignment advanced relational databaseproject- advance

Assignment: Advanced Relational Database PROJECT- Advance SQL Overview: Using the knowledge garnered thus far, please solve all of the below problems. Please run the attached SQL script file at the SQL*PLUS prompt. This ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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