--- In [email protected], "Richard Root" <[EMAIL PROTECTED]> wrote:
>
> Volunteer,
> I suppose you will be gathering and reporting on data from the
firemen
> (volunteers), Calls, Dispatch, Locations where they went, etc.
> These might be the entities about which you are gathering data. I
am
> assuming a Call is the "input" to the process. And, Dispatch is the
> output, the place where we record the information about the trip to
> the emergency. Each entity has attributes, for example the Call
> entity might have attributes like time, address, person calling,
> reported problem, etc. The Fireman entity might have attributes
like
> name, shift, phone number, special skill, etc. After listing out
the
> entities and their corresponding attributes describe the
relationships
> between the entities. A Location has zero to many Calls. A
Dispatch
> has 1 to many Firemen. A Call has zero to many Dispatches. Etc. etc.
>
> See the following which is a database design for a fire
department - -
> http://ocw.mit.edu/NR/rdonlyres/Urban-Studies-and-Planning/11-
521Spatial-Database-Management-and-Advanced-Geographic-Information-
SystemsSpring2003/6873A2CD-0C0B-41DF-86D1-D9713DF0BB8C/0/lect7b.pdf
> and more generally - -
> http://en.wikipedia.org/wiki/Entity-Relationship_diagram_(ERD)
>
http://www.infocom.cqu.edu.au/Courses/spr2000/95169/Extra_Examples/ERD
.htm
> http://www.getahead-direct.com/gwentrel.htm
>
> Dick
>
>
> --- In [email protected], "volunteerff8" <volunteerff8@>
wrote:
> >
> > is this any one here that could help me build a data base for m y
fire
> > department. I have started it put not sure if I am doing it right
new
> > at this. I first built a table and name it memebers to list all
> > memebers then I built a table for calla. this for all call to be
listed
> > that we run in amy given day. I would to pull information for
this to
> > tell me how many calls we run in a month also to tell me how many
call
> > each memeber has run. Help
> >
>What I need to keep track of is just to calls for me station. We
have 9 station and dispatch keeps track of most of other thing. We
are paid and volunteers. What I and doing is keeping track of the
volunteer side of my station. We normal write down and report about
the call like who was on the truck and times of dispatch, time on the
scene, time in service, time back in station. What I would like to do
is keep track of how many calls each memeber runs. How many man hour
was use how many truck miles. I have all ready start a data base but
not sure if it will do what I am try. So far I just have to talbs one
is memebers to keeps track of the firefighter my key field is their
memebers ID # . Then I starteda talbe wich I called run sheet. In
this I keep track on some of the information I talked about. The key
filed in it is Call # I use drop down box for the memebers the are
link to the call sheet file. Like I said not sure if I am going about
this the right way. Any help I can get would be great. I would be
glade to send you a copy of what I have so far.
Dave
