Creating My First DataBase Critique

[Kyp]

OK so does tblFacility only ever have :-

1 Contractor & 1 Controller

The synopsis is:
A facility can have 20, to 30 controllers [PLC's}.
Annually, we upload the active program, saving is with a date/time stamp. This is under normal conditions.
If the active program needs to be changed/modified in any way, I will save the active program without changing the date/time stamp. When I make the changes, again I save the modified program with a new date/time stamp. In the event that I am not available or on another job and I cannot make it the the facility to make the modifications/changes to the active program, I will call out a third party contract person. When modifications are made, it will be at most, 2 employees, or 2 contract technicians.

I am trying to keep up with the programs as well as who/when changes are made.

 

[Kyp]

No you need to delete the field "AssignedEmployees" from the Facilities table.

Its deleted...

 

[mike60smart]

So you are currently responsible for 1 specific Facility or Multiple Facilities ?

 

[Kyp]

So you are currently responsible for 1 specific Facility or Multiple Facilities ?

about 25 different locations in 3 different states including offshore oil rigs.

 

[mike60smart]

So it is as follows:-

A Facility has Maintenance carried out by Yourself or Other Employees or Contractors.

 

[Kyp]

about 25 different locations in 3 different states including offshore oil rigs.

I'm not keeping up with me, each facility has their own techs. I am just the guy that keeps up with all this. (manager)

So it is as follows:-

A Facility has Maintenance carried out by Yourself or Other Employees or Contractors.

Yes, the maintenance for these controllers is usually carried out by the assigned facility tech (total of 2), or myself (just me), and in the event no one within the company is available, I will call out 2 third party techs. to complete the task.

 

[mike60smart]

What has the field "Company" got to do with the tblFacility details?
Does 1 specific Company own the Facility?

 

[Kyp]

What has the field "Company" got to do with the tblFacility details?
Does 1 specific Company own the Facility?

We have assets on other facilities that are not within our company.

 

[mike60smart]

So Facility1 is within your Company
Then Facility2 can be owned by another Company
Then Facility3 is within your Company etc...

 

[Kyp]

So Facility1 is within your Company
Then Facility2 can be owned by another Company
Then Facility3 is within your Company etc...

That is correct, not including the company I work for, there are 15 different companies with our assets that we have to maintain. We also pickup new companies from time to time.

 

[mike60smart]

The attached ER is my first attempt at your process.
It is not 100% accurate as there are fields in some tables that need to be deleted.

 

[Kyp]

The attached ER is my first attempt at your process.
It is not 100% accurate as there are fields in some tables that need to be deleted.

That is a really big difference from what I had!
I didn't know it was going to be that difficult,
Wanted to start again with something easy!

I wish I could hear your thought process while putting ti together! I recon the next step creating queries, forms and reports will be a hoot!

Thanks Mike!

 

[mike60smart]

See the Conversation I have started with you. Top right of the screen on the Forum