|
Hi everybody!
Please can you tell me what is the best tool for creating a database from scratch?
|
|
|
|
|
Member 9611795 wrote: Please can you tell me what is the best tool for creating a database from scratch?
A computer?
If that wasn't the answer you thought you were looking for then you need to understand that you don't choose a database based on tool but rather on the functionality of the database vendor. AFTER you have chosen a database then you look for applications that allow you to manage the database application.
|
|
|
|
|
Pen and paper: figure out what you want the database to do for you and then create a structure to support that. Sketching it out with a pen and paper is the first thing I do (or whiteboard).
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
It's all about learning not working! so I want to know the tool which can help me to insert data and retrieve it and more.
is SQL server the tool that can help me? or ADO.NET?? and what is the difference between them??
|
|
|
|
|
Member 9611795 wrote: I want to know the tool which can help me to insert data and retrieve it and more.
SQL Server is where data is stored, ADO.NET is a set of objects for Creating, Reading, Updating and Deleting data.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
Just Like Mark wrote, I start with the whiteboard.
When that gets to small I make the model in Oracle SQL Developer Data Modeler [^], which supports Oracle, SQL Server and DB2 out of the box, and you can make your own design rules as well.
And as an extra plus, it supports source control via Subversion.
"The ones who care enough to do it right care too much to compromise."
Matthew Faithfull
|
|
|
|