I'm developing an internal tool (as an intern). We deal with a lot of hardware, which is all custom and managers have a hard time knowing who is developing on what machine. The three main things to track for this project will be Hardware, Projects and the Employees. I'm struggling with how to deal with the managers.

I was struggling with databases and of course I have to design one in my first internship. Any and all suggestions are greatly appreciated.

Here is my current ERD:

Here's my current ERD

Here is an excerpt from the design document for context:

Tool Features

  1. Track gaming hardware: Sort or search by serial no, vendor, platform, type.
  2. Track project pool: See employees and VLT’s assigned by project. Emails are directly in the web >page.
  3. Track lab hardware: Sort or search by serial no, vendor platform and type.

1 Answer 1


I am still learning myself so you might not agree with everything I say.

In my business we have 'projects' that last for a certain amount of time and have staff assigned to them.

I would give your Employees a 'default role' eg Manager, Technician whatever. Then when they are added onto a project this role will be used by default in a drop-down menu unless you choose otherwise. This role may affect their pay rate for each project also.

If you really wanted to impress them you could make an application in Visual Basic for creating and updating the tables, you can do this for free I believe.

  • I absolutely hated my experience with VB, but maybe that's just me. I'll be using ASP.Net/C#. It's not a critical project, so pay rate isn't relevant for me. They've got people payed much better than I to do their accounting. Thanks for your input.
    – J Hache
    May 5, 2016 at 14:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.