--- 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 > > I looked and what you wrote again you hit it on the head. I am just not sure how to pull the information out of the data base. Many be I need more talbs, did I make it to big with just two talbs
Dave
