BK3, Group Project
You have been contracted to build an interactive web site for a public park in your county - Cider Falls. Here are the features that the administrator of the park wants to have.
There are six major destinations in the park. This application will display information about the park areas, their services, and about the guests. We will only track first and last name for each guest.
- In the northeast section, there is the Chamfort River that supports rafting, canoeing, and fishing.
- In the northern section, there is the Lost Wolf Hiking Trail that supports hiking, picnicking, and rock climbing.
- In the northwest section, the main attraction is the Lodge, but there is also a hotel, and a restaurant. This area supports lodging, parking, information, and picnicking.
- In the southwest section, there is the Gander River, which is a natural preserve, so it only supports fishing and hiking.
- In the southern section, the main attraction is the Campgrounds. Ther eis also the office park, and children play areas. This area supports information, lodging, and parking.
- In the southeast section, there is the Pine Bluffs Trails, a vast network of trails for all levels of hikers. On the beginner trail, there are food vendors. This area support hiking, picnicking, and zip lines.
- Each section should have a title (e.g. Lost Wolf Hiking Trail).
- Each section should display the services is supports (e.g. hiking).
The administrator wants the park logo and park name at the top of the page. She wants the main phone number, email address, and street address at the bottom of the page.
All of the areas should be displayed in the proper location in a layout of two rows, and three columns.
The areas grid should be in the main content area of the page, and left aligned.
The names of all current park guests should be listed in the main content area of the page, and right aligned.
Given these requirements by the park administrator, use your wireframing tool to make a low fidelity layout of the project.
Now that you hav a visualization of how the project will be presented to the user in the browser, it is time to design the data needed for the project.
- What are the main resources? For example, one resource is Guests.
- What are the properties of each resource?
- What are the relationships between the resources?
Here are some helpful hints to get you moving if you feel stuck.
Main resources
These are the main resources, but may not be all of the tables you define in your ERD. That will depend on what you determine their relationships to be.
- ParkAreas
- Services
- Guests
How to determine relationships
Pick two resources in your ERD. For example, ParkAreas and Guests. Then ask yourself the following two questions.
- Can a park area have many guests?
- Can a guest currently be visting many park areas?
If the answer to only one of those questions is yes, the you have a one-to-many relationship. You put the foreign key on the correct resource and draw the relationship.
If the answer both one of those questions is yes, then you have a many-to-many relationship. This requires a joining table between the resources which will contain a foreign key to each main resource. Then draw both relationships.
This project is more complex than either DeShawn's Dog Walking or Brewed Awakenings, and you are not provided with any initial, boilerplate code.
It is crucial, therefore, that you work on designing the algorithm before you write any code.
- What are the main resources (i.e. tables)? Design your ERD first.
- What are the properties of each resource?
- What is the relationship between the resources? If it's many-to-many, what additional data must you design in your ERD?
- Which modules should you create?
- What is the responsibility of each module?
- What functions should be in which modules?
- What is the responsibility of each function?
- What should each function return?
- What is the spcific algorithm for each function? Does the function need parameters? Should it return something?
Do all of this before you write a single line of code, or you could end up wasting hours of time writing code only to find that you need to throw it all away because you didn't design the algorithm first.
When the title of any area is clicked, the current number of park guests in that area should be displayed.
The park administrator has a new feature request. Right above the park area grid, she would like all of the services that the park provides listed. When a park guest clicks on one of the services, a message should be displayed show which park areas support that service.
