For the website, www.somethingspecialgiftbaskets.com, I am going to rebuild it using a database to handle the content. I am going to be using coldfusion mx as my databasing language. It will be through mysql
Problem I am running into is setting up a database structure for something like this. I will be honest, I have never put a database together in terms of mysql, access, or whatever.
I plan on making it so that the owner of the site can edit content through forms on the web, rather then making me change it every other week.
Currently, the menu on that site is being pulled with SSI, but if I go to a database, i think I am able to just do this using database tables, I am not sure. This is where I need some help.
The basic structure of the site is as follows
Main Page - Description and a featured content section and menu
Sub Menu selection - Meaning, when someone picks a basket category, they are taken to a page with the available style baskets for that category, but still keeping the menu where its at. This is done for every category
Basket Content page - This is where an image of the basket is shown, along with a brief description, contents, and a price. This page in particular will be one of the reasons for allowing the owner to use a form.
When I say I am struggling with the structure, I mean I am not really sure how the tables should be setup and related to each other.
Here is so far what I have in mind
If you feel you are able to help me in improving this current structure, and/or completely changing it, I would really appreciate it.
Have a read here. Proper planning is essential to have a good structured database, and if you plan it with a specific method, all you need to know is what data will be accounted for in the DB, the planning stage will sort out where it needs to go