This forum will be closed on November 04, 2020.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Designing Databases

Question
0

Sign in to vote

Hi, I have enroll my self into Business Intelligence just now and i want to go towards Design Databases (creating the picture plan for the clients).

my question is which way should i fouces more.

right now i'm working with SQL server 2008 R2.

best regards

Monday, July 4, 2011 7:59 PM

Reply

|

Quote

Answers

0

Sign in to vote
Designing databases is not just about the database product you use (in your case Microsoft SQL Server 2008 R2). It's also about the techniques to store your data in an efficient way (creating tables, working with primary and foreign keys, constraints, nullable columns,...) for which the basis lies in database normalization: http://en.wikipedia.org/wiki/Database_normalization

About this you can find many resources on the web (like the wikipedia link above) and there are also books available:

Database Processing: Fundamentals, Design and Implementation By David M. Kroenke

Database Systems: Design, Implementation and Management By Peter Rob, Carlos Coronel

Database Principles and Design By Colin Ritchie

Dimitri C. - Please mark the replies as answers if they help! Thanks.
- Marked as answer by Rubel KhanModerator Monday, July 25, 2011 12:37 AM
Wednesday, July 6, 2011 6:23 AM

Reply

|

Quote