SQL database setup?

What are the best practice for setting up databases with SQL

do i really need to use the DOS prompt, or can i just write them out with windows note pad. then copy and paste it all into phpmyadmin.

3 Answers

Relevance
  • Anonymous
    1 decade ago
    Favorite Answer

    there is a free to use database creation program available. you can get a copy by searching on www.softpedia.com for sql database.

    i forget the name of the program at this time.

    good luck.

  • .PANiC
    Lv 5
    1 decade ago

    You can manage your entire database from phpMyAdmin. It's the best software in my mind available for managing MySQL databases.

  • 1 decade ago

    When setting up a database, i write out every attribute i'm possibly going to use. then i start normalizing. First remove all the redundant data (first normal form)... 1nF... actually read this:

    http://www.trumpetpower.com/Papers/Normal_Forms

    Once you know what tables and relations you want then just create the SQL statements to create all of that.

    http://www.w3schools.com/sql/sql_create.asp

Still have questions? Get your answers by asking now.