Discussion Locked

Data Model & SRS

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi All,
Relatively easy question but I don't have the answers to following questions
1. Where Does data model fits in SRS?
2. While creating a data model in SRS, if my SRS is organized in different module do I have to maintain the same modularity in ERDs?
3. Does data model necessarily features DFDs, ERDs, Data dictionaries etc. or only ERD can be used to develop physical data design?
4. Does physical data design features realtionship among the tables with others definitions like table structure, Primary key etc?
5. What database details feature in Detailed Design?
I thank you all in advance for the answers.

5 replies

by ukothari

IMHO, Data Model does not fit anywhere in SRS (Software Requirement Specification) because Data Model is part of the design or in other words part of the implementation of the SRS. SRS talks about 'WHAT' part of the application without worrying about 'HOW'.

HTH

Good luck

Uday Kothari
CTO, Compulink Systems

by samir shukla

While Reading the book "CMM in Practice" by Mr. P. Jalote. I came across these questions. One doubt of mine was where exactly the data activity begins. Obvious answer is the DFDs ERDs, Data Dictionaries. My Question expected an answer to "what essentailly features in SRS regarding database?" Since I think that Analysis comes before preparing the SRS, I should have DFDs etc. ready in analysis before going to SRS.

by jooehrlein

1. I agree that the data model is part of the Design, unless an existing data model is an integral part of the requirements.

2. Even if the SRS is divided into parts, I don't think it's necessary to divide the data model, especially if there would be duplication across those areas.

3. I think the data model at a minimum includes ERDs and a data dictionary. People need to know what a field is, when it should be used, what valid values are, etc. This information could be stored in the ERD tool and just extracted. Data flows are important when data moves from one table or file to another. I rarely distinguished between the conceptual data model and the physical data model. The only real use I see for them is where the conceptual data model is the ideal (in at least 3rd normal form) and the physical data model shows how things have evolved & denormalized for performance or other issues.

4. I think it's important that the physical data design show the relationship among the tables and all keys and indices.

5. I think the Detailed Design should document the design of the database down to the field level and explain why certain choices were made. It should point to any standards used for database table & field names, abbreviations, data types, etc. For maintainability, all the "grunt" work of the detailed database design (the tables, fields, keys, etc.) should be able to be reverse engineered from the database to ensure that they are current. A good solution is one that lets you model the database, generate the scripts, reverse engineer the database back to a model, make changes, generate scripts, etc.

This discussion is closed to new replies.