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

Assignmentproject descriptionextreme h2o is a company that

Assignment Project Description: Extreme H2O is a company that specializes in water sports. It is considering adding some new experiences for its customers. In a nearby community, there is a small river that can be used f ...

Mis 204 hands-on activityaccess - forms and

MIS 204 Hands-On Activity: Access - Forms and Reports Introduction In this assignment you will learn how to create forms and reports to access and analyze your data. Forms are useful for data entry and navigation. Report ...

Benefits of data protection controlsbased on what you have

Benefits of Data Protection Controls Based on what you have learned about data protection in an online environment, prepare a 5-slide presentation to a department head or the CEO of a company to convince the audience tha ...

Database designfrom textbook fundamentals of database

Database Design From Textbook: Fundamentals of Database Management Systems 2nd Edition. 1. Convert the Video Centers of Europe, Ltd., entity-relationship diagram in Exercise 2.2 into a well structured relational database ...

Make the menageriegis database using petgissqllook at the

Make the menagerieGIS database using petGIS.sql Look at the petGIS.png to see where the pets are. 1. Display the name, astext location, X and Y values of each pet 2. Display the pets with their location displayed in stan ...

Graph databases assignment1choose a social network that you

Graph Databases Assignment 1. Choose a social network that you use. Say, FaceBook, Twitter, LinkedIn, or anything else. 2. Design a model to store and manage relationship data from these social networks in a graph databa ...

Frontlines united states of secrets all Frontline's United States of Secrets, all

Frontline's United States of Secrets, all episodes: http://www.pbs.org/wgbh/frontline/film/united-states-of-secrets/ (Links to an external site.) Nova's Genome specials http://www.pbs.org/wgbh/nova/body/cracking-the-code ...

Describe a database that might be used in nursing using

Describe a database that might be used in nursing. Using this data, explain the relationship between a field, a record, a table and a database. In addition, what are the advantages of managing database information in Acc ...

Capstone project purpose of the assessmentthe purpose of

Capstone Project Purpose of the assessment: The purpose of this assignment is to identify new learning, self realisation and plan for improvement. Students will have an opportunity to explore the use of the online tools ...

Task - overview of business casealive amp boating aampb is

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

  • 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