What do you need to design to form a computerized database?

I now have to design a database, and apart from the tables, what do I need to prepare and design, so I can implement it more efficiently and effectively?

What do you need to design to form a computerized database?
You need to normalize the database to insure proper relations between tables and eliminate redundant data. Normalization should be part of your table design, as it can effect table layout, keys, and how many tables you have. I always normalize to the Boyce-Codd normal form, which is enough for all but very complex and process-intensive databases.
Reply:william k got it right. I've been designing databases for years and the one thing that makes a database successful is the GUI (Graphic User Interface). There's an old saying in the computer game - "Garbage in, Garbage out!" As a DB designer, you must ensure that the operator enters data in a highly structured way. The better the structure, the better the results. Your programming code should check for, and report on every error: Mr, Mister, Street, St, Road Rd. Make the GUI user friendly, then make it even more user friendly. Get different friends to enter data and see where they differ. redesign the GUI to stop any differences happening and then think about making it even more user friendly. Any database data entry screen must be simple to use by anyone. The database program itself will produce good results provided the imput is accurate to start with. If you think I've used the phrase "user friendly" too much, you're wrong. How many times have you filled out a form and asked yourself "I wonder what I'm supposed to enter in this box?"
Reply:Well, if you're in a fairly large environment, running it of an SQL server is pretty popular. It's possible to just share it directly from a shared folder in XP, though. What program are you using? OOo base? Microsoft Access?
Reply:Hi,


you have a lot of work ahead of you, the hard part of any design is the GUI "graphic user Interface" how the user inputs the data and see's the results. please read MS Access "Inside out" and this will really help you. hope this all helps you.

trading cards