We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Case Study – PGD Essay Sample

essay
The whole doc is available only for registered users OPEN DOC
  • Pages:
  • Word count: 540
  • Category: database

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

Case Study – PGD Essay Sample

I have chosen to use the database software to solve the problem. There are two different database software packages. These are Microsoft Access and Microsoft Works database. Both packages are available to my access but I have chosen to use Microsoft Access and this would allow me to implement all the user requirements. Access is also a relational database which will make it easier to link all the tables in the database.

Hardware

The hardware required for the system is:

* Monitor- To allow the user to see whatever is happening.

* Mouse- To allow the user to interact with the monitor.

* Keyboard- To allow the user to input any data.

* Printer-To print all reports and forms.

Data Input

The user would have to enter the following once the system has been set up:

* The list of all the members with other necessary information such as member type and address. This would be obtained from the paper-based database. Each member would have a member ID which would uniquely identify them.

* Details of all the activities available. The data would be Class ID, Class description, level, days, location and instructor.

* Bookings by members would also be keyed in once the booking date has been confirmed. This information would be entered into the booking form which would be much easier for the user.

Data such as MemberID, BookingID, ClassID, Date of Birth and Booking dates will all be automatically validated by the computer because they would be set to a preset type which Autonumber or Date.

I would be getting all my data from the paper-based database from the gym. This would be given to be in person. In order to check for any mistakes, I would proof read all the information that has been given to me.

Data Manipulation

The tables which would be required for the system will be Members, Activities and Bookings. The fields in each table would be as follows:

TBL_Members [MemberID, Surname, Forename, Gender, Date of birth, Address line 1 & 2, County, Postcode, telephone number and Member Type]

TBL_Activities [ClassID, Description, Level, Time, Day, Location and Instructor]

TBL_Booking [BookingID, ClassID, MemberID, Date booked and Date of class.]

Two reports would be produced. To produce a report for different member types, a query would be run to access data from the Members table. The user would be able to enter the member type and the query would search for the records in the database. This query would be source for the members report.

Backup Strategy

In order not lose any important data; the computer file containing the completed system must be backed up onto a floppy disk or a flash drive every time it is updated. This copy should be kept on another computer which in a different location which could be my house in case of any problems such floods or theft.

The system should also be protected by a password in order to prevent any unauthorised users to access any data. This protection would not be a problem as there is a password-protect function in Access.

We can write a custom essay

According to Your Specific Requirements

Order an essay

You May Also Find These Documents Helpful

What is the difference between controlled and...

Controlled redundancy is the state to improve the performance of queries. We want to control redundancy and retrieve the data along with the all the details. By placing all the data together, we do not have to search multiple files to collect this data. In some cases, the DBMS should control this redundancy in order to prohibit inconsistencies among the files. A controlled redundancy is...

Database Design

Introduction Every Weekend I rent a Video or DVD from my local videostore in Dungannon, and when I ask about new releases the employee behind the desk sits rummaging through lots and lots of file paper. I can see where they have taken down details of the person renting the filming in one column and in another the film number. I think they would be...

Database Report

In this report I will show how I created my own database so you can also create your own database following these simple steps that I will guide you through. How to set a Drop down list: How to set the primary key: How to set the Input Masks: How to set the Data Validation: Relationship: I have completed my tables now I need to...

Implementation of my Database for Emma's DVD...

Emma's DVD rental shop in Birmingham. It started in 2008. It started in Birmingham by Emma's Pegg. When I later then realised that there was a gap in the market in the area. Originally I rented out films and computer games but the popularity of DVD'S increased rapidly in the years I decided to start my own business as a DVD renter. At the moment...

Benefits and Drawback for Patients and Staff...

The benefits of my database for my patients is that they can get letters telling of special offers sent to them because dentercall has there information in the database and the patients will be told if there are any offers on the products they like and the security of the databases information will abide by the data protection act and they will also get discounts...

Get Access To The Full Essay
icon
300+
Materials Daily
icon
100,000+ Subjects
2000+ Topics
icon
Free Plagiarism
Checker
icon
All Materials
are Cataloged Well

Sorry, but copying text is forbidden on this website. If you need this or any other sample, we can send it to you via email.

By clicking "SEND", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
Sorry, but only registered users have full access

How about getting this access
immediately?

Become a member

Your Answer Is Very Helpful For Us
Thank You A Lot!

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?

Couldn't Find What You Looking For?

Get access to our huge knowledge base which is continuously updated

Next Update Will Be About:
14 : 59 : 59
Become a Member