Database design help

[Ron A.]

I am hoping to get assistance in getting a good table design for a database
for tracking units, Unit control officers and vehicle assigned to those units.

I want to be able to see by oginization code what units have that code who
is there vehicle control officer and what vehicles are assigned to that unit.
Any assistance is appreciated. Hope I gave enough info.

 

[Carl Rapson]

I am hoping to get assistance in getting a good table design for a database
for tracking units, Unit control officers and vehicle assigned to those
units.

I want to be able to see by oginization code what units have that code who
is there vehicle control officer and what vehicles are assigned to that
unit.
Any assistance is appreciated. Hope I gave enough info.

If there is only one vehicle control officer per unit, something like this
should work:

Table: Units
Fields:
Unit_ID (PK)
Unit_Name
VCO_ID (FK)
Org_Code (FK)
... (other fields related to a Unit)

Table: Org_Codes
Fields:
Org_Code (PK)
... (other fields related to an organization)

Table: VCO
Fields:
VCO_ID (PK)
VCO_Name
... (other fields related to a vehicle control officer)

Table: Vehicles
Fields:
Vehicle_ID (PK)
Vehicle_Description
... (other fields related to a vehicle)

Table: Unit_Vehicles
Fields:
Unit_ID
Vehicle_ID
... (other fields related to a vehicle assigned to a unit)


Carl Rapson

 

[Steve]

FYI in case you are interested ---

A service I provide is to design the table structure of a database for a
customer. I have done this for numerous customers. My fee is very
reasonable. I provide a map of the tables that shows all the tables in the
database, all the fields in each table, all the relationships between the
tables and the type of relationship for each relationship. The tables are
arranged on the map generally as the flow of information in the database. I
create a map of the tables for every database I do. The map visually shows
what forms and subforms are needed for data entry, shows what special forms
and subforms can be created for dispaying data in the database and shows
what reports and subreports can be created from the data in the database.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Ron A.]

Thanks Carl,

With your help it looks like I can come up with a solid table lay-out.
Thanks again.

 

[John Marshall, MVP]

These newsgroups are for FREE peer to peer support. Take your snake oil
elsewhere.

John... Visio MVP

 

[Carl Rapson]

No problem, just pass on your knowledge when you can. And remember - the
help on this newsgroup is provided free of charge.

Carl Rapson