i am going to make a tiny little CMS for a site with about 5 or 6 pages.

but how should i design the structure?
what should the tables contain?

is it ok to make it like this:
a page is called prices, so i make a table called prices.
on that page i have a h1 tag and 3 p tags, so i make 1 column called h1 and 3 columns called p1, p2 and p3
and i have i picture to so i make another column called img

is this a way to go?
how is a pro CMS designed??

Hi,

Please read up a bit on some fundamentals of relational databases.

It is not possible to understand your problem from what you have described.

Ravi

i am just wondering how to design the ER model for a CMS-based DB.
how many entities? which entities? how many attributes per entity? which attributes?
basically, what should i include in the DB??
does anybody know about a tutorial for a CMS-based DB??

Actually, I'm not sure what you mean by CMS. My first thought was "Code Management System", but looking at your examples of prices and pictures that seems unlikely. "Contact Management System" perhaps? Or did you really mean CRM (Customer Relationship Management)?

Anyway, there's a kick-start data model for Contact Management here on Database Answers, and if that isn't what you want there are 200 other models on that site to choose from.

by CMS i mean Content Management System

i may be wrong about the name...

i am trying to make a system for a friend of mine who runs a traffic school.
its only going to be 5 or 6 pages but he wants all the content to be editable by him. so all the text and images on the different pages have to be stored in a DB.

and how should i structure the different tables?

Sorry, but that question is far too vague. If you no nothing at all about database design then perhaps you shouldn't offer to do this?

ok!
how about this!

STARTPAGE (h1, h2, p1, p2, p3, li1, li2, li3, li4, li5)
PRICES (h1, h2, p1, p2, p3, p4,)
ABOUT (h1, p1, p2)
CONTACT (h1, p1, li1, li2, li3)

this is the way my DB is today. no PK and FK.
then i use a html form and php codes to write INSERT INTO and UPDATE SQL queries... it works just fine... BUT...

something tells me that this is not the way to go about making a CMS

What are these columns called h1, h2, p1, p2, etc.?

It does not look to me that you are building a data model of any sort.

If, as I suspect, h1, h2, etc. are the HTML tags, then they have no place as column names in a data model. Ask yourself, are these tags features of the problem domain, or are they merely an artifact of the technology (html) that you are using to solve the problem.

Please educate yourself on some fundamentals of relational databases so that you can ask more meaningful questions and we can provide meaningful answers to these questions.

Ravi