how to design a database

[heena sharma]

how to design a database for an enquiry form with following attributes:
1.name
2.address
3.telephone no
4.email
5.educational qualification
6.college
7.language: java vb.net vc#.net asp.net C++
php assembly embedded C vC++
(a student can opt for more then 1 language)

8.expectation on programming week: 24 16 12 8 6 4 less than 4
9.remarks
10.date
11.sign

[ichigo_cool]

You can mix PHP and SQL to create and access the database. Is that what you were asking?

[swi2]

first
you collect all information which you need in your project
then you make table of respective to your project

then in table you create primary key and forien key
and then another field which you needed in your project
i think this will help you

and another thing if you develope website then you use xammp
to design your database then to create forien key in db you select
the searchengine TYPE INNODB OK BUY

[sandeepji1]

When you Create a database then you use Structured Query Language(DDL)and Syntex is

"CREATE DATABASE Database_name";

Hi,I just try it, Because I have no Proper Idea

"CREATE TABLE Table_name( 
                          name VARCHAR(20)  NOT NULL, 
                          address VARCHAR(120)  NOT NULL,
                          telephone_no INT  NOT NULL,
                          email VARCHAR(20)  NOT NULL,
                          edu_qual VARCHAR(25)  NOT NULL,
                          college VARCHAR(25)  NOT NULL,
                          language VARCHAR(25) DEFAULT 'java',
                          pro_week: VARCHAR(25) DEFAULT '16',
                          remarks VARCHAR(25)  NOT NULL,
                          date VARCHAR(25)  NOT NULL,
                          sign VARCHAR(25)  NOT NULL
                          )";

I'll Give an appropriate answer to you, just wait,.

[braveheart_sb]

how to design a database for an enquiry form with following attributes:
1.name
2.address
3.telephone no
4.email
5.educational qualification
6.college
7.language: java vb.net vc#.net asp.net C++
php assembly embedded C vC++
(a student can opt for more then 1 language)

8.expectation on programming week: 24 16 12 8 6 4 less than 4
9.remarks
10.date
11.sign

Hi,I will assume u mean for mysql?
And it looks like you want a table for a form?

create table[name of your table]
(
id int,
name varchar(20),
address varchar(40),
telephone_no varchar(15),
email varchar(40),
educational_qualification varchar(20),
college varchar(40),
language varchar(20),
expectation varchar(20),
remarks varchar(20),
date date,
sign varchar(20)
);

[Ankit_Parmar]

I Think , You are asking for Normalization.........

One time entry you can keep in one Table. means these fields
1.name
2.address
3.telephone no
4.email
5.educational qualification
6.college

&&&&&&

Another table will store according to first table primary key. In this table you can keep.Becoz,you are telling one person can store more than one language.

Lanuages
Date
Sign
Remarks

[heena sharma]

thnks Ankit.
yes i was asking for npormalization...
what if a single student opts for more than 1 language...how to store that

[almostbob]

each table has a reference that links to other tables
the user table has a sequential id, not nul
the language table has its own sequential id not nul
and a column that links to the id of the user table
user
id,name,address,town,state
000, fred, 123 four street, five town, six state
001, bill, 234 five street, six town, seven state

language
id,userid,language
000,000,perl
001,000,php
002,000,c++
003,001,perl
004,000,mysql
005,001,mysql

http://www.sql-tutorial.com/relations-keys-normalization-sql-tutorial/