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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-25 : 07:44:18
|
| selva kumar writes "core concepts of database design.is it really databsae design helps developers reduce headclinche!how? role of system analyst." |
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2005-05-27 : 08:18:30
|
| In my opinion, analysts do the db design. Developers only on the sql, procedures, triggers, etc. Then DBA takes care of optimizing the db generally (examining sqls, sps, create appropriate indexes based on the queries, proper partitioning of the db files, log files, maintenance schedules). |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-27 : 09:14:47
|
| >> analysts do the db designlol - why not let the database designers do it.Analysts should know about the business requirements not the technical implementation.I have had analysts trying to define a requirement by desining the table structure and even by giving sql - but that always leads to problems because they do stupid things and you have no way of telling what they were trying to do.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-05-27 : 15:50:37
|
| Kumar, not sure what your question actually is. Can you elaborate on what it is you would like some feedback on?HTH=================================================================The surest way to corrupt a youth is to instruct him to hold in higher esteem those who think alike than those who think differently. -Friedrich Nietzsche, philosopher (1844-1900) |
|
|
|
tomy74
Starting Member
32 Posts |
Posted - 2005-06-01 : 05:56:49
|
| Hi,The data model is one part of the database conceptual design process.The data model focuses on what data should be stored in the database while th function model deals with how the data is processed.-Identification of data objects and relationships -Drafting the initial ER diagram with entities and relationships -Refining the ER diagram -Add key attributes to the diagram -Adding non-key attributes -Diagramming Generalization Hierarchies -Validating the model through normalization -Adding business and integrity rules to the Model Thanks,Tarek Ghazali |
|
|
|
|
|
|
|
|
database design