databasedev.co.uk - database solutions and downloads for microsoft access

Fishing Lakes and Members Scenario

The following data model is designed to hold information relating Members of a Fishing Lake and hold information relating to catches made at these lakes. For this scenario we need to define the following facts:

These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation.

The draft facts have been defined as:

The Entities required should include:

• Members
• Lakes
• Swims (Positions in the Lakes)
• Catches
• Species

The Entities are related as follows:

• One Member can submit Many Catch Reports
• One Lake can contain Many Swims
• One Swim can produce Many Catch Reports
• One Species can relate to Many Catch Reports

The design allows a Member to submit many catch reports, detailing dates and times of a particular catch that has been made. The catch report will detail which species has been caught from which swim on a particular lake

When asking questions of the database we may need to know:

1. What is the largest species of fish caught
2. Which member has caught the largest fish
3. Which lake holds the largest fish
4. Which swim produces the best catch
5. What time of day will be best for catching the largest fish

The following data model allows these questions to be answered and allows the information contained above to be stored logically and in a structured manner.

To view the model please go to: Relationships for Fishing Lakes and Members Data Model

Please download the data model relating to Relationships for For Fishing Club which is contained in the zipped up Microsoft Word document.