conceptual modeling, business rules | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

conceptual modeling, business rules


are business rules usually accompanied with the conceptual model?
in a separate plain text document? stuff like this…. Business rules:
– an individual obtains one or more licences
– an individual belongs to one or more local real estate does anyome have a template for this?
See whether this articlehttp://www.winnetmag.com/SQLServer/Article/ArticleID/8589/8589.html is any help to you. Enterprise integrity means business rules and these are normally defined in the functional model rather than the data model (another output of your conceptual/ logical design). Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
so what format are business rules usually in?
sentences??

Yet another articlehttp://www.winnetmag.com/SQLServer/Article/ArticleID/38020/SQLServer_38020.html about BR. And I don’t know whether thishttp://www.sql-server-performance.com/mh_gnosis_2.asp link is any help. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Business rules usually get passed to the developers in a document format, it is your job to figure out the best way to enforce the rules by means of triggers, contraints, SP’s, etc. The comments you might have seen in the logical models are not exactly business rules, but little phrases describing referential integrity or data flow. Some designers incorporate the conceptual and logical models together, Logical modeling is a representation of the reality of your business requirments. So at these level you should already have a consensus of your business needs. If you are looking for a cook book or template on designing your best resources are books on RDBMS design. Some good ones I have read are Datbase design for mere mortals and SQL Server 2000 design and TSql programming
]]>