Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New Coder
    Join Date
    Jul 2004
    Location
    UK
    Posts
    99
    Thanks
    0
    Thanked 0 Times in 0 Posts

    database design research

    hi everyone,

    im looking to develop an online restaurant reservation system using PHP and MYSQL but im not too sure about the systems database design.

    Does any one know any good starting points for me to start my research...

    Ive got substantial knowledge in PHP and sql so thats not a worry, its just the actual database design.

    thanks
    c:\dos...
    c:\dos\run...
    run dos run

  • #2
    fci
    fci is offline
    Senior Coder
    Join Date
    Aug 2004
    Location
    Twin Cities
    Posts
    1,345
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Do you know how to create relational data.,..
    A relational database management system (RDBMS) takes things one step further by creating relationships among the tables that make up a database. These relationships can then be used to combine data from multiple tables in various ways, allowing a user to view the same data from various perspectives and then use this enhanced vision to make better (read: more efficient and cost-effective) business decisions. By creating links among related pieces of information, an RDBMS thus not only makes it possible to store information more efficiently (by removing redundancies and repetition), but it also brings to the fore hitherto undiscovered relationships among disparate segments of data and permits efficient exploitation of those relationships.
    source
    To normailization...
    Database normalization can essentially be defined as the practice of optimizing table structures. Optimization is accomplished as a result of a thorough investigation of the various pieces of data that will be stored within the database, in particular concentrating upon how this data is interrelated. An analysis of this data and its corresponding relationships is advantageous because it can result both in a substantial improvement in the speed in which the tables are queried, and in decreasing the chance that the database integrity could be compromised due to tedious maintenance procedures.
    source (part 1)
    source (part 2)

  • #3
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,278
    Thanks
    4
    Thanked 83 Times in 82 Posts
    A discussion on databases would probably be better suited in the database forum. I'll move it there..
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #4
    Regular Coder
    Join Date
    Oct 2002
    Posts
    380
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm not sure what you're asking for, exactly. The basic concepts of normalisation are scattered all over the web (a search for database normalization will give you a big list that will get you to at least 2nf pretty easily and maybe 3nf). Getting an entire database to 2nf is usually good enough; 3nf is nice, but not always sensible; beyond 3nf is more interesting than practical.

    eg (simple introductions)
    http://www.databasejournal.com/sqlet...6861_1428511_1
    http://dev.mysql.com/tech-resources/...alization.html

    The formal theory of normalisation is a fairly mathematical/programatic theory. If you want that, then you would probably be wise to start with Codd (Edgar F Codd) who first formalised normal forms. Subsequent normal forms all build on his original formulation.

    eg (prtty simple introduction, but gives the names you need to search for)
    http://en.wikipedia.org/wiki/Database_normalization

  • #5
    New Coder
    Join Date
    Jul 2004
    Location
    UK
    Posts
    99
    Thanks
    0
    Thanked 0 Times in 0 Posts
    thanks for all of the replies,
    i have looked at normalisation methods and i do believe that m getting somewhere.
    thanks for the help guys
    c:\dos...
    c:\dos\run...
    run dos run


  •  

    Posting Permissions

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