• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Normalisation

#1
[eluser]georgerobbo[/eluser]
Hello,

I need some help with database normalization. Basically I have five/eight pages where content will be brought down from a database. I'm not sure if the way I've set it out is the most efficient way of doing things.

I have all the results grouped into a table
Quote:ID Object_ID Value

1 contact hello, lorem ipsum
2 about bonjour, lorem ipsum


I am then using a MYSQL WHERE statement to use the Object_ID to determine which page the result is displayed on.

Is there a better way of doing this?

Thanks

#2
[eluser]Phil Sturgeon[/eluser]
No, you have no more data that needs to be normalised. I would recommend giving your fields more meaningful names though.

Try:

Quote:id, uri, body

or:

Quote:id, slug, content

#3
[eluser]georgerobbo[/eluser]
Those were just for example. I'm using different names for them.

Thanks very much though.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.