954,595 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

school inventory

hi guys,
i`m new to the data base systems i currently work in a school and i have been asked to design a database for all the computer items in school the problem i have is because i no very little about how to setup and make a database i dont know where to start (a bit noobish i know) so if u kind people here at daniweb could point me in the right direction i.e which program to use (free verison ofc) and a place to learn how to make a database that would be great.
thanks for reading my post have a good day!

kind regards
mr-antony

mr-antony
Newbie Poster
6 posts since Jan 2008
Reputation Points: 10
Solved Threads: 0
 

There are plenty of off-the-shelf inventory control products that can do this better and cheaper than writing something yourself. If your requirements are simple there is bound to be some freeware available.

ChrisPadgham
Posting Pro in Training
413 posts since Sep 2009
Reputation Points: 102
Solved Threads: 78
 

Why would they ask you to design the database if you don't know how to... kind of a stupid idea? anyway, just search Google for decent freeware, read a review to see if it's legit and what you need..

Toni Chopper
Light Poster
34 posts since Jan 2011
Reputation Points: 10
Solved Threads: 4
 

the reason why i have been asked is because im the techie in the school so doesnt sound like stupid idea dont u think? thanks chris for the info.

mr-antony
Newbie Poster
6 posts since Jan 2008
Reputation Points: 10
Solved Threads: 0
 

A ten minute search (Google) found a half dozen decent looking free inventory control systems for Windows platforms (which always worries me, but that's a different issue). Tucows is often a good resource (thought I usually go there indirectly). I was less successful looking for something on other platforms.

If you want/need to roll your own, I strongly suggest that you get two or three of the free or demo packages and run them past your "customer" to get feedback about which features are nice, which useless, etc. Be aware (if you aren't already, of course) that you will spend 80% of your time doing screen layout and similar work, and 20% actually getting the back end system working correctly. I suggest that you front load the 20% part so you can give the customer something 'real' to look at as early as possible. (He) will then spend most of (his) time tuning things like colors, text box size and location, how pages flow to each other and all the "what it looks like" things that actually make a huge difference in the day to day use of the program. And may also have some valuable insight into actual functionality that only comes to light when the program is in use (which wraps back around to why you want to let them see some of the "commercial" packages, too).

griswolf
Veteran Poster
1,165 posts since Apr 2010
Reputation Points: 344
Solved Threads: 256
 

thank you very much griswolf

mr-antony
Newbie Poster
6 posts since Jan 2008
Reputation Points: 10
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You