Structure has me confused (1 Viewer)

[dynamictiger]

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.

 

[shay]

Hi

Your structure seems ok to me. The only comment I would make is that I think it is perhaps a bit over complicated. I would have had the last two tables as one ie PoolID, EquipmentID, ReadingID, ActualReading but I don't have all the details and you may have a good reason for splitting that info into two tables.

Why do you think it isn't correct?

shay

 

[dynamictiger]

I think the data entry under this system is too cumbersome. So I think there is a better structure.

 

[shay]

Hi

I'd suggest the following structure:

tblPool
PoolID
PoolName

tblEquipment
EquipmentID
Equipment

tblReadingType
ReadingID
Reading (Vacuum, Pressure, Inlet Pressure etc)

tblReadings
PoolID
EquipmentID
ReadingID
ActualReading

As regards data entry, I think you should create an input form. Include combo boxes for Pool, Equipment and Reading type and a text box for the actual reading. The user will then have to choose 3 things and type in one number - not cumbersome at all!

hth

shay