I am trying to design a DB for the Boy Scouts to keep track of Camping Events and which Units showed up and how many were involved and amount if money collected.
My thoughts are to have a table for the Event, UnitInfo, sbuUnitInfo, Camp, Doctor, and Payment. I want to be able to pull the UnitInfo in if the Unit already exsist from a previous Event. The only information that keeps the Units different is the Unit Number and their City. You can have the same Unit Number but in a different city.
I have a one-to-many from the Event to UnitInfo at the EventNumber field. From the UnitInfo I take the EventNumber, UnitNumber, and UnitCity to do a one-to-many to the other tables like SubUnitInfo (because the number of scouts can change from event to event), Camp (for camp location per a map) Payment (for dollar amount spent by the unit).
Like I said, I do not want to have to re-enter the UnitInfo if they are already in the database from a previous event. I just need to be able to tie the Boy scout Unit to an Event, camp at that Event, Payment at that Event, how many scouts at that event
Below is piece of what I have started.
If I have totally confused everyone, let me konw and I will try again.
Thanks for the help.
Event UnitInfo SubUnitInfo
Enum Enum Enum
Etitle UnitNum UnitNum
Eyear UnitCity UnitCity
UnitType NumWeblos
UnitCouncil NumScouts
UnitDistrict NumLeads
UnitState Patches
My thoughts are to have a table for the Event, UnitInfo, sbuUnitInfo, Camp, Doctor, and Payment. I want to be able to pull the UnitInfo in if the Unit already exsist from a previous Event. The only information that keeps the Units different is the Unit Number and their City. You can have the same Unit Number but in a different city.
I have a one-to-many from the Event to UnitInfo at the EventNumber field. From the UnitInfo I take the EventNumber, UnitNumber, and UnitCity to do a one-to-many to the other tables like SubUnitInfo (because the number of scouts can change from event to event), Camp (for camp location per a map) Payment (for dollar amount spent by the unit).
Like I said, I do not want to have to re-enter the UnitInfo if they are already in the database from a previous event. I just need to be able to tie the Boy scout Unit to an Event, camp at that Event, Payment at that Event, how many scouts at that event
Below is piece of what I have started.
If I have totally confused everyone, let me konw and I will try again.
Thanks for the help.
Event UnitInfo SubUnitInfo
Enum Enum Enum
Etitle UnitNum UnitNum
Eyear UnitCity UnitCity
UnitType NumWeblos
UnitCouncil NumScouts
UnitDistrict NumLeads
UnitState Patches
