Recent content by DBApprentice

Hi, I have a new image to example how they work today in Excel. In the ER Diagram I have the table RequiredBy handles them. Is it correct?

Thanks, I have updated them as per Pat said too. I created SchoolTrainingComments to keep track of feedbacks and issues we have from the school as for TrainingsComments is to track discussions we have about a specific trainings. Despite they are holding the same fields now I am feeling I will...

Hi, Pat! Thanks for your input. Relationships are part of my problem in DB design, I am still trying to wrap my head around it. I found a tutorial on YT that I will be dedicating some time to get it right. So far I realized it is a design from the business rule but anything that would violate...

I am not sure I followed you... :unsure: Indeed I tried to avoid Many-To-Many relationships on this ER Diagram, for instance Trainings are carried by Schools, but only the approved ones by my company will be accepted so I figured I had t make a TrainingBySchools, since it can change over time...

Hi mike60smart the link brings you to the ER Diagram, just click here so you can view and zoom in and out. Thanks for your time!

Welcome! Funny we have a similar job... but I handle crews working in oil & gas industry in Brazil. Hope you find all the help you need as the guys "working" here are really great in Access.

Hi, I am coming to you once again to ask you help so that I can develop an ER Diagram of a Training Matrix Database that I am willing to build and replace the current Excel Spreadsheet. The current file is becoming difficult to follow-up on and some features were identified as a nice to have but...

Thanks jdraw! Here are the answers to your questions: Roles and Positions are the same thing, like Mechanic, Business Development Manager or VP of Operations. Yes we have a Competence and Training Matrix per installation to do that, it helps us to identify diplomas (technical or...

Your help is much appreciated, jdraw! I will review your diagram and if I have further questions I will post them. Let me take a look at Visual Paradigm since PPT or Excel are not good, and the free online Diagram builder I´ve found had many limitations. Thanks!

I see what you mean with the alternatives, but in this business rule we can´t have that. If we don´t find a person that has all certificates necessary then we can identify whos has the lowest number of gaps and apply a Dispensation for the person to act in that role temporary. A dispensation is...

Thanks! Why Role is not and entity? Or a child from Installation?

Hi jdraw! I have revised the model and it indeed helped me. The only part that keeps being confusing for me is the relationship between Installation and Role. Each Installation has a number os roles to be perfomed by employees, and also a training matrix to be complied depending on the role...

Hi guys! I am working a pet project from my job, this DB is intended to manage employees, competence and trainings certificates, installations and the dynamics of crew changes and compliance of paperwork. I have posted this question in Stack Overflow 5 days ago but I had few inputs there, so I...

Thanks, Gasman. I put a link to the files but I will remove them, thanks to your tip I managed to post all files.

I only have one spreadsheet I designed to control crew rotation, the matrix cannot be changed and I have to make a VBA to read from it. As for the certificates it will be coming from a CSV file produced from a training portal. My goal is to build everything I need on DB and read the information...