Hi there,
I believe that there will be some one who will be able to help out for this type of database design. The idea is to maintain record of Equipment and related aspects.
Lets have some brain storming contents;
- 1 Equipment can be in only 1 Work center.
- 1 Equipment can have one or more spare parts.
- 1 Equipment can have one or more operational Parameters.
- 1 Equipment can have one or more Manuals.
- 1 Equipment can have one or more Consumption data types.
- 1 Equipment can have one or more Maintenance Schedule.
- 1 Equipment can have one or more Operators (Day and Night shift).
what can be the best ERD for this type of contents?
Hope to hear from you soon.
zee