Database Developing
Hello Developer Team..This is Demetrius Powers i am writing you in regards to a situation that i have acquired in entry level database developement. I am a Database Administrator for a medium level construction company in chicago..They have hired me and a team to complete a database using Visual Studio .Net and Ado .Net...I was wondering if you could share a lil bit of your expertise with me...
Here is the problem: This construction company has 3 storage garages filled with all kinds of tools, equipment and vehicles, since this is a big company they have problem keeping up with all the tools that come in a go as they please some in which get legs and never return to these storage garages... so they want us to design a database that has all the tools, equipment and vehicles loaded in..this database will also be equipped with Employee ID's and Employee's first name...now using the software that i have , i was tryin to make sure i was on the right track..I am creating the database in MS Access which is powered by MS Jet Databases 4.0..I am making the user interface in a window application form that will keep record of all the tools or equipment that a construction foreman wants to check out...To minipulate the data that is already stored in the database i am using MS SQL statements that will change the affects of this realtional database.......
When i finish the testing processes ...I would like a construction foreman to put in his employee id along with his first name then the equipment type along with the equipment number and job number along with the location of the job where the tool is going...Then i am going to have a check status button for management so when management wants to check up on which foreman has which tools they can simply go to the application type in Employee ID and all of the equipment and tools this particular employee has will be displayed...Do you think i am on the right track...what methods would you use to create a database of this type? Please right me back..I am up to my ears in Microsoft Step By Step manuels to get a grip on things but i have no senior level help?
Sincerely,
An Entry Level Database Administrator who might be in over his head?!?!?!?
