Hey, I have a database I need to try and create. I have a few different categories and lots of fields in each. If I write down what needs to be in each table, can someone help me fit it into at least 3rd Normal Form? I've tried once but I ended up with about 20 tables in total. I need to try and keep it as simple as possible.
A large number of the fields are optional and all the information will be displayed in tables on a website. I need to be able to order by County, Country, Day or Category where available.Concert Venues:
Venue Name
Address, including post code
Phone Number
Website URL
Country
County
Advert Images (Can be multiple, or none)
Dance Clubs:
Club Name
Country
County
Address, including post code
Day
Time
Contact Name
Phone Number
Website URL
Advert Images (Can be multiple, or none)
Links:
Category
Title
Description
Telephone Number
Website (can be multiple)
Advert Images (Can be multiple, or none)
Music Clubs:
Club Name
Country
County
Address, including post code
Day
Time
Frequency
Contact Name
Phone Number
Website URL
Last Checked Date
Advert Images (Can be multiple, or none)
I also need to be able to archive the records if they are edited or deleted. This is a different matter, but I'm not sure if it's best to clone the structure of the database and add entries in, or add archive table to this database; so it is something that will need to be addressed at an early stage.
My client will also need a back-end to the website, in order to update and maintain the database easily. I'm thinking of writing a bespoke DBM but if there are any DBM's out there that can be used to update databases as easily as you can with Access, I'd be wiling to try out any suggestions.
I have resigned myself to writing the site in PHP and MySQL (or SQLite) as I still haven't been able to find a stable host for ASP.NET 4.0 websites.
Any help anyone can give would be greatly appreciated and repaid with thanks in the site's humans.txt
Bookmarks