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

Assignment database environment proposalas one of the

Assignment: Database Environment Proposal As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standa ...

Query 1list all movies played in landmark or music box

Query 1 List all movies played in Landmark or Music Box. Output only titles and eliminate duplicates. Query 2 List all stars born after 1960. Order them by their birthdate in ascending order. Output their first names, la ...

1 analyse situations andor environments for the application

1) Analyse situations and/or environments for the application of database solutions including web connectivity 2) Create, alter and remove relational tables, indexes and data using an appropriate database language. 3) Ex ...

Replacement china incproject descriptionyou work as an

Replacement China, Inc. Project Description: You work as an associate database manager at Replacement China, Inc. This firm specializes in finding difficult-to-replace, no-longer manufactured china, crystal, silver, and ...

Assignmentyou are to design a program that will serve as a

Assignment You are to design a program that will serve as a database for keeping track of video games and various statistics for the games. This application will allow for the storing of the name of a video game, its gen ...

Case problem-global site gps - kevin hodge is a production

Case Problem- Global Site GPS - Kevin Hodge is a production assistant at Global Site GPS, a leading manufacturer of GPS devices located in Crestwood, Missouri. One of Kevin's jobs is to monitor output at the company's fi ...

Fundamentals of databases assignment 1 -q1 explain the

Fundamentals of Databases Assignment 1 - Q1. Explain the distinction between total and partial constraints. Q2. Explain the difference between a weak and a strong entity set. Q3. Explain the distinction between disjoint ...

Database design discusion post and assignmentdiscusion post

Database Design Discusion Post and Assignment Discusion Post: Data as a Corporate Resource and Foreign Keys Please respond to BOTH of the following questions: Question A Discuss how data can be a corporate resource and d ...

Restaurants and fast-food chains rely heavily on business

Restaurants and fast-food chains rely heavily on business intelligence to make important decisions. Casinos do as well. Some of the leading restaurants, fast-food chains, and casinos using data warehouses include AFC Ent ...

Apriori analysis and cluster analysis-data analysis

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

  • 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