How to Design initial database architecture?

Question

0.00/5 (No votes)

See more:

i have one initial start-up project. i want to design database for this project. i am not great with database architecture design so,

what are important step for initial database design for project?

Posted 6-Oct-15 0:43am

Amit Samnani

Add a Solution

Comments

E.F. Nijboer 6-Oct-15 7:09am

I would say normalization for a relational database. (https://en.wikipedia.org/wiki/Database_normalization)

[no name] 6-Oct-15 7:24am

11 important database designing rules which I follow[^]

I hope this helps you.

[no name] 6-Oct-15 8:46am

i need specific and realistic information with some stable example

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vijay Palaniappan · Answer 1 · 2016-01-12T13:51:00

Database Design depends upon on the application data usage and flow.

Consider below parameters and choose the right database, it may RDBMS, Flat or Hadoop

1. Type of data
2. Volume of data
3. Transactions and security level
4. Data distribution architecture with your application
5. Cost/Budget
6. Scalability

If you go with RDBMS System, few points

1. Identify the Master data
2. Normalize them and create right Table structure
3. Identity the main Entity of the system and its depend items, mostly these tables involve in transaction
4. Normalize them carefully, too much normalization reduce its performance
5. If your have lot of reports, have separate DB for reports and extract report data alone from Transaction DB though ATL kind of jobs

Hope this helps

Richard MacCutchan · Answer 2 · 2015-10-06T02:51:00

Solution 1

This tutorial is worth studying: http://arcanecode.com/2007/04/24/sql-server-2005-compact-edition-important-component/[^].

Posted 6-Oct-15 2:51am

Richard MacCutchan

Comments

[no name] 7-Oct-15 2:39am

Mr. Richard ,
your solution have`nt contain database architectural information its all about SQL version and its specification.

i need initial guidelines about database creation that is very suitable for my application like ,

what are the risk, i might get in future(risk validation)?
relationship between the table

i hope now, you could understand my question from my above explanation.

Richard MacCutchan 7-Oct-15 6:44am

Then you need to do some research, buy some books and study them. This is a Quick Answers forum for specific technical questions. You have to do your own research.

[no name] 8-Oct-15 8:37am

Thanks you so much, for your curial time and great help. As i mention in my above comment that, i need specific and realistic example.i have gone through many books for my database architecture but i could`nt fine possible solution. that`s why i put this question here that, i get some experience person`s help.

Richard MacCutchan 8-Oct-15 11:56am

There are many real examples to be found on the Internet. As I said before, it is unlikely that anyone here will have the time to go through this for you. This site is for specific technical problems rather than training or mentoring.

Take a look at https://www.google.co.uk/search?q=northwind+database&ie=UTF-8&oe=UTF-8&hl=en-gb&client=safari For further samples.

Jörgen Andersson 13-Jan-16 17:23pm

If you want examples you should take a look here: http://www.databaseanswers.org/data_models/[^]