Results 1 to 8 of 8
  1. #1
    Join Date
    Apr 2006
    Location
    Norway
    Posts
    26

    designing a small CMS, need help?

    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??

  2. #2
    Join Date
    Apr 2004
    Location
    Toronto, Canada
    Posts
    249

    Please read a little bit of relational theory

    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

  3. #3
    Join Date
    Apr 2006
    Location
    Norway
    Posts
    26
    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??

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    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.

  5. #5
    Join Date
    Apr 2006
    Location
    Norway
    Posts
    26
    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?


  6. #6
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    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?

  7. #7
    Join Date
    Apr 2006
    Location
    Norway
    Posts
    26
    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

  8. #8
    Join Date
    Apr 2004
    Location
    Toronto, Canada
    Posts
    249

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

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •