Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mia
Starting Member
1 Post |
 Posted - 2011-12-21 : 16:45:48
|
| Hello,hope i post this question in the right section.I'm new to database design. i have some basic knowelde.But i want to know if someone knows a step by step tutorial that i can learn how to create a database design from scratch.what i mean by scratch? by scratch i mean. from the database normalization (i know how to normalize a db) to the ERD diagram till creating the database, tables, diagrams, views, queries etc in sql server. I want to know the sequence of the designhope someone can help me.thnx in advance |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2011-12-26 : 13:53:14
|
| I'm not sure if there is a universal step-by-step formula. Partly because every project is different. Not to mention it is hard to get all the requirements up front and requirements can change over time.I'm not to big on the ER Diagrams myself.This may or may not work for you:1. Jot down some of the main relationships and tables.2. Create your tables. Be wary of not allowing duplicate data (i.e. normalization). Use SQL Server to layout the tables on a Diagram. Create Foreign Keys. Now you have a pretty good layout.3. Then you can add views and queries but try to think of a naming scheme at some point. If you have a big project without a naming scheme, it will be hard to change things later. |
 |
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-13 : 10:28:46
|
| To gain the basic/mid level of knowledge in the Database design I have few suggestion , if you follow I hope it will easy for you.1) Read about the database properties and its options. 2) Read about the all the constraint , index , trigger , function and stored procedure behavior.when you complete the basic level it will be ok When you done the above , not required you need to a expert then open your sql server and if you have the Microsoft sample database(Adventurer) then convert the database into the design mode.Goto :- Database Digrams Right click and add all the table , and see how the releation works Sr Sql server DBA/Artitech |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-01-13 : 23:31:23
|
quote:
Originally posted by Mia
Hello,hope i post this question in the right section.I'm new to database design. i have some basic knowelde.But i want to know if someone knows a step by step tutorial that i can learn how to create a database design from scratch.what i mean by scratch? by scratch i mean. from the database normalization (i know how to normalize a db) to the ERD diagram till creating the database, tables, diagrams, views, queries etc in sql server. I want to know the sequence of the designhope someone can help me.thnx in advance
First...Is your logical model ready ?After Monday and Tuesday even the calendar says W T F .... |
|
|
|
|
|
|
|
|
Database Design from scratch