hi, what are the first steps for designing a database system for cms? can u please help me with it? i dont know how to start it. what should i do for the begining?
A:
Your best bet would be to download one of the FOSS CMSes out there, install it locally and analyze the database structure. I'm sure there are plenty of solutions out there, I'd use Drupal or Joomla. These two will give you nice ideas.
Vasileios Lourdas
2010-09-19 12:51:24
+1
A:
Gather requirements. Write them down in plain English (or whatever human language you prefer). Be sure you have a clear understanding and definition of every item and action you write down.
Then identify data entities, relations between them, and processes that modify them.
Data entities become tables (with each row representing one instance). Data relations become foreign keys. Processes become methods or functions in the application that uses the database, although you might want to implement a part of the functionality in stored procedures to minimize the amount of data that goes into and out of the database.
tdammers
2010-09-19 12:51:52