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

Assignment1write a query that retrieves studentlastname

Assignment 1. Write a query that retrieves student.last_name, student.first_name and total number of enrollments from the student and enrollment tables. Your query should also include students that do not have any enroll ...

Computer sciencein reference to your database design

Computer Science In reference to your Database Design Proposal: Proposal Outline, provide a narrative analysis of the customer and user needs by defining the customers and users as well as describing their individual nee ...

Assignment business intelligence and data

Assignment: Business Intelligence and Data Warehouses Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a man ...

Assignmentthis must be your own unique work you cannot have

Assignment THIS MUST BE YOUR OWN UNIQUE WORK: you cannot have the exact same table as another student and you cannot turn in something you find online!Your work will be checked against a plagiarism database. The format m ...

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

Suppose that you are the database developer for a local

Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training s ...

A task descriptionoverviewyour task is to create and test a

A. Task Description Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, describing the requirements that Southern Cross University may ...

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

Enterprisebim projectgoal - to enable students to

Enterprise/BIM Project Goal - To enable students to experience the process of building a non-trivial database-backed web application. Tasks 1. Choose any area that interests you - this does not necessarily have to be abo ...

Projectinstructionsfor the purpose of grading the project

Project Instructions: For the purpose of grading the project you are required to perform the following tasks: Instructions 1 Open the start file Day Spa that you recently downloaded then Save the workbook as Lastname_Fir ...

  • 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