Database Design
Putting
together a database is not a process to be taken lightly. It needs to
be designed properly to ensure that your data is accurately and
consistently accessed and updated. Without a proper design, you
will pay the price for your haste for the life of the database and its
data.
How Do I Approach It?
Database design is a science more than an art. There are procedures and rules which make the design of the database more stable, more accurate, and easier to work with. I have experience working with databases used for everything from project management to adult services, so I can make something that will work for you. We'll work backwards from the sort of information that you need to get out of your database, to determine what needs to be in there in the first place.
What Do I Do?
I will work closely with you to identify your requirements for the information that you will be getting out of the database, as well as the technology that you have available and how you will be interfacing with your database once it is operational. Bringing this all together, we will select an appropriate RDBMS and then develop a schema for your database.
From this point, I will document the relationships of the database as required, and present you (or your development team) with detailed instructions on the relationships and how they should be used. This information will be used in the development of the interface or system that you will use for accessing your database.
From there it's up to you and your team, or me, if you want me to help out with any web development.