Re: On Normalisation & the State of Normalisation
Date: Tue, 3 Feb 2015 03:49:03 -0800 (PST)
Message-ID: <0adc91af-1c44-4d4b-90dd-f4a740d272db_at_googlegroups.com>
> On Tuesday, 3 February 2015 21:05:02 UTC+11, Derek Asirvadem wrote:
> On Tuesday, 3 February 2015 19:13:01 UTC+11, Erwin wrote:
>
> b.7. The existential predicates are usually not stated nowadays, I am happy to provide them for you at your request. I was hoping to focus on the Normalisation issues.
b.9. Descriptive predicates are also not usually given these days, because they can be _read_ the model: ____County is described by ( StateId, CountyCode, Name ) However, if that is proving difficult, please ask, and I will get him to provide. It only takes a few seconds, and I always say, do anything and everything in order to be understood.
b.10 We produce State Transition and Transaction Sequence diagrams, as standard practice. I would think those are out-of-scope re Normalisation. But if it helps, if it increases understanding the database, of which the model is merely one rendition, eg. what operations are performed on those predicates, and under what conditions do those operations perform their function, please ask. Seconds away.
b.11 All updates to the database are performed via OLTP standard-compliant Transactions. Therefore View Updating and similar crimes against nature are a non-issue.
Cheers
Derek
Received on Tue Feb 03 2015 - 12:49:03 CET