designing a database for cms

what are the first steps for designing a database system for cms? can u please h开发者_如何学JAVAelp me with it? i dont know how to start it. what should i do for the begining?

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.

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.