dynamictiger
Registered User.
- Local time
- Today, 13:34
- Joined
- Feb 3, 2002
- Messages
- 270
I think I have looked at this off and on for about a year, and I still cannot see the structure for setting this up.
We have a contract to look after some swimming pools. There are four swimming pools, with various quantities of equipment which have a minimum of two readings each taken once or twice daily. I think I struggle to identify which object is atomic in this structure.
My last attempt that doesn't look right looks like this:
tblPool
PoolID
PoolName
tblEquipment
EquipmentID
Equipment
tblReadingType
ReadingID
Reading (Vacuum, Pressure, Inlet Pressure etc)
tblEquipmentSchedule
EquipScheID
PoolID
EquipmentID
TblEquipmentRequiredReading
EquipScheID
ReadingID
ActualReading
There is something here that constantly eludes me, and I simply cannot see it.
We have a contract to look after some swimming pools. There are four swimming pools, with various quantities of equipment which have a minimum of two readings each taken once or twice daily. I think I struggle to identify which object is atomic in this structure.
My last attempt that doesn't look right looks like this:
tblPool
PoolID
PoolName
tblEquipment
EquipmentID
Equipment
tblReadingType
ReadingID
Reading (Vacuum, Pressure, Inlet Pressure etc)
tblEquipmentSchedule
EquipScheID
PoolID
EquipmentID
TblEquipmentRequiredReading
EquipScheID
ReadingID
ActualReading
There is something here that constantly eludes me, and I simply cannot see it.