We need to build a DBMS that we can pull out forms/data from that can be sent along to our parent company, and in general help us better manage our business. We would need to provide our supervisors, and employees with electronic forms accessible either via iOS and Android apps or a web based app that are integrable to the database we create. We are undecided as to the environment/database and are open to suggestions. Possibly access, excel, or oracle as the parent company uses a mixture of oracle and excel sheets, so these may be our best choice. We need to build a database to help us organize our 40-50 employees, all their personal information, weekly work hours, multiple forms required to be used by supervisors and employees and roughly 300 work orders a day, and other vital pieces of information.
I have a basic understanding of database design and an associates degree using Access SQL, MYSQL, excel, and some oracle. I took it upon myself to create a relationship model that includes many of the fields we will need. I am sure that there are redundancies and other mistakes but I believe it will be a useful resource. With this in mind, I am still looking for input and suggestions/ideas from the experienced developers when modeling and designing the database. We need to store many pieces of information, and be able to query the database to pull forms that we can use to send to our parent company as well as save the files in an organized fashion for future usage and reference.
A small example of some of the database functionality would be every day having a new sheet that would add to a master document that keeps a back log of all the past works that are all date/time stamped as this is required when billing our parent company. We want to have developed either an iOS/Android or web app that can be used by our employees for their daily time sheets etc that can be sent to us in the main office and seamlessly integrated. We would need to be able to differentiate from things like a completed job, an open job, employees current job site, hours worked that week being calculated by the integrable sheets that we would received from the employees each day upon completion of work, and many other similar features to streamline this companies data and daily work load. I will go into more detail upon requests/interest in this job
One of the electronic forms we would need is a street supervisor sign off sheet. Without the proper information we will not receive payment for the work. It would include fields such as Employee Name, Signature(electronic), Emp. I.D. #, Date, Start Time, End Time, Location, Purchase Order Number, Parent Company Rep Name, Parent Company Rep Signature-(electronic), Parent Company Employee ID#. For start time, end time, we would also want to have the database calculate the hours worked by that employee and be able to flag employees that reach a certain amount of hours worked each week.
This is an example of 1 of approx. 4 electronic sheets that needs to be given to the street employees that can be integrated back into our database across 50 employees multiple times a day.
I believe the work is fairly straight forward. Although I can tell some components require superior knowledge to create the database, the supplemental sheets, and the nitty gritty bits like calculating the hours worked per employee based on their sign-off sheet.
I think I have sufficiently given the scope of work at hand so I will stop here. I look forward to communicating with you and addressing my concerns. If this is a reach in any aspect for you I kindly request that you do not apply, for those that have extensive experience with work like this you are whom i'm looking for.
I expect daily updates and constant open communication with daily calls as I have an understanding of the work I am requiring, as well as detailed time-frames. With that in mind I do expect the people whom are signed on to work with me to optimize the end result and use their learned skill sets to help deliver the best possible product. I want to be able to leverage this DBMS in such a way that we can reduce company error, increase productivity and performance, better manage and direct company employees, as well as gain interest from the parent company based on reduced error and efficient data storage that allows us to perform the duties required on a day to day basis in a way that currently no competitors are doing.
I understand the included document has errors, redundant data etc... It hopefully gives you an idea of what I am looking for. That said, I am sure that with the experts help more will be needed. With certainty I know there are at least 2 other tables I need to include but am awaiting the protocol from the parent company.