Database Design

[ParyGoal]

First of all I hope in the right forum.

I am trying to design an Access Database that consists of keeping truck of Procedures for handling equipments.

Each Equipment has its own procedure.

There are 9 sections that need to be filled out for each procedure.

Sections are more of details information for each equipment.

Ex: Startup Procedure. Section 3. How to perform a startup procedure on an equipment

Users have to follow a specific set of steps to perform a Startup. The same thing apply when performing a ShutDown Procedure-- Section 4

Each equipment can have only one procedure. 1- many

Tables I have designed so far.


I think there is a one to many relationship for each Procedure. Here is why.

Section 1: We need to specifiy the list of serial numbers of equipments where the same procedures would apply.


Section 2: List Type & Location of Operator Controls. There could be a number of them.


Section 3. Shutdown Procedure
You specify all the procedures and the Lock Type and State to be verified.

Ex: Shutdown Procedure Table data may look like

Procedure Lock Type State Verified
1) Notify Users Lock & tag Visual

2) DISCONNECT EQUp UNLOCKABLE ATTEMPT TO START

3) "" "" ""
ect..




Here are my tables

Equipments Table
EquiID PK
EquipName
SerialNumber


Procedures Table
ProcedureID PK
EquipID FK



ShutDown Procedure Table
ID PK
ProcedureID
Steps..... THere could be number of steps
Startup Procedure Table
ID PK
ProcedureID
Steps..... THere could be number of steps


Documentation Table
ID PK
ProcedureID
Steps..... THere could be number of steps

ect....

Am I going in the right direction?

Lastely how should design the interface based in this database schema?

I will appreciate any help

Thank you

ParyGoal

 

[dhookom]

I would expect to see a sequence number in the shutdown table. This field would identify the order the steps are to be performed.

Aren't the fields basically the same from the shut down table to the start up table? If so, I would combine them into a single table.

There seemed to be a lot more information on your form but these tables are acceptable.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[ParyGoal]

First of all, I truly appreciate your help and especially your patience. Thank you

How do I go about implementing the sequence number via code everytime a step is entered into both the ShutDown and StartUp Tables? This will always help sorting the sequence in which each step has to be performed.

The fields defined in the shutdown tables are not the same as the one defined in the Startup Table, with the exception of the step entry. Thus not sure I can combine them into one table.

Thank you

ParyGoal

 

[dhookom]

You can manually enter the sequence number. If users object to having to enter a number then there are quite a few samples on the web of how to generate a sequence number.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]