What fields would I need If I was trying to create a relational database on workers at a summer camp?

camping table designs image

Brittany D

I need to be able to find out their personal information, jobs, hourly rate, and anything else related to a job. I just need to draw the design and make sure that there is no redundency.

Answer
The main thing I'd remind you to do is to use a unique worker id number that is set to auto increment for the primary key for the workers table.

I'd start with something like:
worker_id AUTO_INCREMENT PRIMARY KEY INT(5)

Then do fields for each bit of info. I like to have a record of when I entered the row, so I'd do a date_entered, plus a date_started for whenever the worker started working there. I like to be able to order by date entered sometimes. Otherwise, then just do a field for each bit of personal info you want.

For jobsâwill workers have multiple jobs? If so, I'd do a jobs table where each job has a job_id number (auto_increment) as a primary key with a job title and a description. Then I'd do a job_assignments table with a field for worker_id, job_id, and assignment_id (as the auto_increment primary key) where jobs will be assigned to employees. You'll need to do a join when you query for information, but that shouldn't be a problem. This way, you don't have to have extra unused fields in your workers table since you never know how many jobs a worker will have, and you can assign as many jobs to an employee as you want via the job_assignments table.

Off the top of my head, that's how I'd start at it anyway.

Can state parks rent out handicap camping spots when full?

duder8675

My father has said when he designed and worked with a few county parks that their policy was to rent out the handicap spots to non handicap party's when everything else was taken but the handicap spots.

I was wondering if that were true for state parks as well. Specifically Wisconsin state parks.

Answer
Contact the Wisconsin State Park of your interest to determine present policies. Often, there are over-flow camping areas as well as private campgrounds near the state parks. Depending on the location, there may also be dispersed camping or backpacking "walk-in" site opportunities if you are willing to "rough it." I have never had any problems finding a place to camp. You may also qualify for "group" campsites.

Devil's Lake State Park
S5975 Park Rd.
Baraboo, WI 53913-9299
608-356-8301

First-come, first-served campsites

You can identify first-come, first-served sites by going to the Wisconsin State Park System Camping Reservations website. First-come, first-served sites are shown as "Walk-up only" in campsite lists and "W" in availability tables.

Campers can reserve campsites at most Wisconsin state parks and forests. Some parks and forests do not accept reservations and have sites that are available only on a first-come, first-served basis. Check with the forest, park, or trail office for current availability. Due to unpredictable demand, we cannot guarantee that a site that's vacant when you call will still be available when you arrive. You can register for non-reservable family sites for up to 14 consecutive days.

Any reservable site that has not been reserved is also available to campers who arrive without a reservation. The maximum allowable stay will depend on the next date for which the site has been reserved.

All campsites at the following locations are first-come, first-served only:
â¢Brule River State Forest, 35 sites
â¢Chippewa Moraine State Recreation Area, three remote sites
â¢Elroy-Sparta State Trail, 20 hike-in or bike-in sites
â¢Flambeau River State Forest, 60 family sites, 34 canoe sites
â¢Governor Knowles State Forest, 30 family sites, 30 equestrian sites, four backpack sites
â¢Peshtigo River State Forest, 16 sites
â¢Tower Hill State Park, 15 sites
;

Powered by Yahoo! Answers

Title Post: What fields would I need If I was trying to create a relational database on workers at a summer camp?
Rating: 96% based on 9658 ratings. 4,4 user reviews.
Author: Unknown

Thanks For Coming To My Blog