Simple database bridge management system

[tsvetkovdimitar]

Hi, I have to built a simple database management system, it's relationship diagram should look something like file name capture2, if I have done it correctly . I have problem fulfilling the following condition : From time to time, the organisation may decide to change the inspection frequency for a list
of component types on bridges of selected construction types. These inspection policy


changes are specified as in increase or decrease in the inspection interval (in months),
subject to an allowable minimum and maximum interval for each combination of
component type and construction type. For example, it might be decided to extend the
inspection interval for the cables on all cable-stayed bridges by adding 6 months to the
current interval per bridge, subject to a minimum of 12 months and a maximum of 36
months. I would be extremely appreciative and grateful if someone give me any idea how can I do that. Thank you!

[June7]

Not sure what you are asking for. Is this not simply changing the value of the InspectionFrequency field?

I don't understand the Inspections table. Why is the link on InspectionFrequency fields and not the PK in Inspections? Why is InspectorID in both ComponentTypes and Inspections?

[tsvetkovdimitar]

Thank you for replying. You helped me a lot to create a better diagram and reorganize the tables. Thank you. There is still a problem with table ComponentTypes, Access doesn't let me to set a primary key for it. Does anyone have any idea why is that? Thanks!

[June7]

Why doesn't it, what error do you get when you try? Do you already have data in the table? Is ID autonumber? Unless you intend to use as FK in another table, probably not important there is no PK.

[tsvetkovdimitar]

I did query, to find duplicate data values in the table and I found where is my mistake. The problem is that I have entered duplicate data in the fields, so I need to change that. Thank you for your help