Design the Database in SQL First time

Hi all,
I m desiging the database first time, so how can i design the database,how i set the datatype of Datafield.(means which creteria i use for giving data type).
how can i manage the Relationship....
plz discuss in detail....
thanx in advance
Sajjad Rizvi

1. Do you need syntax on how to create table?

2. Or do you need just information/suggestions on giving field types?
3. Or do you want suggestion on naming conventions on fields etc

|||Thanx for reply
I need information/suggestions on giving field types
and want suggestion on naming conventions on fields etc......
and also wanna know about various data type, like booleon,varchar,numeric....
thanx in advance
Sajjad|||sorry forget....
I m using Sql Server 2000
Sajjad|||

Try these two links the first is Microsoft new sample database AdventureWorks2000 download and the second is the book used to create it right click and download the PPT slides. When you have installed AdventureWorks2000 look at the 113 tables and see if you could use some for your application. Data Modeling is very complex some one cannot teach you online, if you need a book buy the book in the link it comes with six complete databases. BTW if you have problem installing AdventureWorks use my email in my profile and I will email you the only file you need to install it, you need SP3 to install it. Hope this helps.

http://www.microsoft.com/downloads/details.aspx?FamilyID=487C9C23-2356-436E-94A8-2BFB66F0ABDC&displaylang=en

http://wings.buffalo.edu/mgmt/courses/mgtsand/data.html

|||No one can teach you database design in a forum. That's what books andonline articles are for. Lacking that Microsoft provides a pile ofdocumentation as well. Not as accessible but it's included with whatyou already have.
There are no shortcuts. Learning SQL will take some time. It'sworthwhile though so get to it and come back when you have *specific*questions.
|||

What your asking is like "can you tell me how to build a house using a Catipillar Crane and Earth Mover"?

Let's also not forget that SQL Server 2000 is a tool. You need to learn the fundamentals of relational theory and data modeling. Date's INTRODUCTION TO DATABASE SYTEMS is standard issue for fundamentals.

|||I agree that it will take time to learn SQL in and out. Database design is not easy if you have never done it before. However, there are some great links above that should point you in the right direction. If you have ever used Microsoft Access, you should be alright. In SQL 2000, you can use the "designer" (Enterprise Manager) to assist with developing the tables or you can use transact-SQL directly within Query Analyzer. The best suggestion I would have for you is to draw out everything first. Then determine what limitations need to be specified.|||

Thanx to All for great reply,

I just wanna know Normilizaton, Relation ship and some introduction about common Datatype and their usage.....

Sajjad