Coursework Specification

Authors Avatar

AS ICT                COURSEWORK

Luke Tucker        Candidate No.: 9126        Centre No.: 64225                

CONTENTS  

SPECIFICATION        

Outline Problem Statement        

Organisation background        

The problems that the organisation is having        

The main task that I intend to solve        

Details about the current system        

Testing the Items Form        

IMPLEMENTATION        

Tables        

Animals Table        

Meals Table        

Meal Items Table        

Items Table        

Relationships        

Input Forms        

Animals Form        

Meals Form        

Meal Items Form        

Items Form        

Queries        

Animal details        

Details of animal’s meals        

Individual animal’s meals        

Meal times        

Meals for particular time        

Meals form        

Reports        

Animal details        

Details of animal’s meals        

Individual animal’s meals        

Meal times        

Meals for particular time        

Switchboard        


SPECIFICATION

Outline Problem Statement

Organisation background

The zoo ‘Animal Land’ in Sussex owned by Dean Thunder holds many species of animals for public viewing. It holds general details about the animals living in the enclosure and details about their feeding times and their dietary needs. As well as providing a home for the animals, it provides viewing for the public and educates them on the lives of the animals.

The zoo is fairly big and there are 15 employees that work in the zoo with the animals. There are 75 animals in total looked after in the zoo. These include reptiles, mammals and birds.

The zoo uses information about the animals such as their location within the zoo, their meals, their feeding times and the food within their meals. Therefore, the zoo uses information about only the animals and holds no information about the staff who work at the zoo. It also holds and uses more detailed information about the animals and their meals such as whether they are nocturnal.

The employees are the zoo staff who take care of the animals. The staff use the information to assist them with looking after the animals efficiently and the zoo manager prepares the orders for the food needed to feed the animals using the information about the dietary needs of the animals.

The problems that the organisation is having

The zoo is having problems with the feeding of the animals. Feeding times have been missed, some of the animals have gone long periods of time without food, and animals have been fed the wrong food by accident. Records of the animals are kept on paper, which makes it difficult for them to be stored and updated easily and it is very hard to search for details on feeding times or diets for any particular animal.

Join now!

The main task that I intend to solve

By creating a system for this zoo, I intend to make the zoo more organized, which will prevent harm to the animals. It will hopefully eliminate any confusion about feeding times and dietary needs of the animals. Overall, it will reduce or get rid of mistakes that might bring harm or discomfort to the animals. The system will also allow records of the animals to be kept and updated easily, and will decrease the difficulty of searching for records. The system will allow details and lists of feeding times and ...

This is a preview of the whole essay