To begin I still consider myself a newbie when it comes to databases. I know the general stuff like primary keys and relasionships, but would like some good advice.
I have been asked to design a database in mysql which will store the data for a website. Now before I start I want to make sure I do this the best way, as this site has the potential of becoming very big and collecting a lot of data so I dont want to have any issues down the line from designing a bad database.
Can anyone point in the direction of a good article or tutroial that will help me out? They are heaps available using a google search but dont know the best one to choose.
Well the database is basically for a sports record site. All sports results from a number of sports will be stored in the database. So as you can image it will only store text.
Anytime someone on the website wants results it will be pulled from the database. So thats why i want to ensure that i build it right, as if alot of people start using the site I would not like to have any performance issues,
yeh the tutorial would be great...where can i get it from?