I am new to Database's and want to work toward installing a Database in the small company I work at for production and eventually other uses. The company has only 15 employee's and three departments. There will not be more than five computers accessing the database.
Currently the setup is one physical Domain Controller/file server running windows server 2012 r2 standard. This is a small warehouse that has many part numbers with instructions and pictures, all in multiple books. The office uses quick books and spreadsheets.
My goal is to have each department to access each job by sales order which will pull up all the items instructions, procedures and specifications for the job as it pertains to the department and eventually track production and inventory.
I will appreciate any assistance or guidance and I know there is much to learn but I am willing to take my time and build it in a virtual network for testing.
My thoughts on how and what database to use based on a small company and small budget.
Using SQL Server Express because has more storage than Access and would be scalable, secure, and cost effective. Is this correct?
Installing the SQL Server Express on the Domain Controller because it is a small company and would be cost effective and more simple. I am not sure if this is correct and if this is not recommended can I enable Hyper V on the Domain Controller and install server 2012 again using the same product key without having licensing issues in order to run the server for the database.
If there is more information needed then I will give it and I appreciate any advice and guidance.
I am a student while working and just started Database Design class and have a long way to go but I learn better when I am trying to build something in a real world application. I am willing to make mistakes it the virtual network in order to learn but not in my companies network. I believe I need a Database mentor.
Thanks in advance