Click here to Skip to main content
16,020,633 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
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    
[no name] 6-Oct-15 8:46am    
i need specific and realistic information with some stable example

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
 
Share this answer
 
 
Share this answer
 
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.
[no name] 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.
[no name] 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/[^]

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900