Database Creation Help

zech · #1 (**permalink**) 07-31-2007, 10:17 AM

Hello guys,sorry if this is going to be too long for you,but i need your help in creating a database in MySQL.
See,i have a school project where i'm supossed to design a database but the problem is i'm not so good in database creation.but i managed to collect some basic information for the database:
(i have put in some example of the data that will be displayed in each field)
FIELD EXAMPLE
ID 1
Business_Name John's Pub
Type_of_Busines Pub/Bar
Country_Region North_America
Country_Name USA
City New York
Street1 11098 Gamersville
Street2 4th Corner Junction
Location_Descriptio NE statue of Liberty,Just after ZE BAR
Known_for Grilled Fish
Url http://www.johns_pub.com
Tel_no 00002345345
Postal_address p.o box 123943
Comment Nice Fishes

Now i know i'll be asking too much from you guys,but have no choice,i know the above information data will need to be put into different tables(normalized tables)to avoid design errors.so if someone can help or just give me hints,i'll be thankful.Thank you again guys.

tutorialstation · #2 (**permalink**) 08-02-2007, 10:22 AM

Quote:

ID 1
Business_Name John's Pub
Type_of_Busines Pub/Bar
Country_Region North_America
Country_Name USA
City New York
Street1 11098 Gamersville
Street2 4th Corner Junction
Location_Descriptio NE statue of Liberty,Just after ZE BAR
Known_for Grilled Fish
Url http://www.johns_pub.com
Tel_no 00002345345
Postal_address p.o box 123943
Comment Nice Fishes

id: INTEGER, should be primary and autoincrease
other fields are CHARACTERS, feel free to choose length from 64-255

PHP Code:


			
CREATE TABLE `users` (

`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,

`business_name` VARCHAR( 64 ) NOT NULL ,

`type_of_business` VARCHAR( 64 ) NOT NULL ,

`country_region` VARCHAR( 64 ) NOT NULL ,

`country_name` VARCHAR( 64 ) NOT NULL ,

`city` VARCHAR( 64 ) NOT NULL ,

`street1` VARCHAR( 64 ) NOT NULL ,

`street2` VARCHAR( 64 ) NOT NULL ,

`location_description` VARCHAR( 255 ) NOT NULL ,

`known_for` VARCHAR( 64 ) NOT NULL ,

`url` VARCHAR( 255 ) NOT NULL ,

`tel_no` VARCHAR( 32 ) NOT NULL ,

`postal_address` VARCHAR( 255 ) NOT NULL ,

`comment` VARCHAR( 255 ) NOT NULL

) ENGINE = MYISAM ;

some field types need to be changed into INTEGER if you want to make related multi tables

zech · #3 (**permalink**) 08-02-2007, 10:43 AM

thanks,i really appreciate you taking your time trying to help me,i got your point,but don't you think the table should be broken down into multiple tables(Known as NORMALIZATION) to avoid design problems?

wilkin · #4 (**permalink**) 08-09-2007, 08:54 PM

Hi zech

Though I myself is not an expert at the concern area, I always take help from some professional service providers, currently I am taking the services from http://www.techhelpformarketers.com for my current project. "They are an assembled team of Tech Professional with Extensive Experience in taking down IT task or IT technical problems giving you the Shortest Turnaround Time possible."

Hope it's helpful to you!

[wilkin]

nadiakamel · #5 (**permalink**) 09-20-2007, 05:58 PM

how can i export the sql file with dump data to test my website coz i'll publish it?
thanx in advance

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode