Re: Nicola's Data Model [A] of Non-relational DNF Data

Nicola

On Wednesday, 11 February 2015 10:09:30 UTC+11, Derek Asirvadem wrote:

< big snip, OMG, what a big snip. I mean any and all points discussed therein >

I forgot to mention something. It is pedestrian to me because I use it all the time, but I forgot the notion is (a) denied (b) impossible (c) exclusive [HM xor RM], here amongst the theoreticians.

Congratulations, you have achieved Hierarchical Data Modelling within Relational Data Modelling !

Yes, quite unconsciously, without thinking about it.

Since the data is hierarchical, since you accepted parts of my model (which acknowledges the hierarchical nature of the data), since you dealt with your perception of the Köhler data, and you dealt with it hierarchically ... you are exercising (ie. not denying) the Hierarchical view over the data, and you are executing Hierarchical Data Modelling within the Relational Data Modelling context.

Yes, the two are inseparable.

Yes, every Key that you suggested is Hierarchical. Yes, some Keys maintain not one but TWO hierarchies.

Yes, by doing that, you are modelling more Relational Integrity than can be had in the RFSs of your colleagues (less than mine, no matter, more than RFS).

Certainly puts the lie to [a][b][c], doesn't it. So much for pig-poop-eaters. Keep them locked up in the barn. Or the asylum.

And that puts you two notches above your colleagues. One for not modelling an RFS, one for handling hierarchies naturally, within Relational.

I think, this deserves a silver star.

Congratulations again !

Wooohooo !

>>>>

(Slow)
I'd like to thank the guy
who wrote the song
that made my baby
fall in love with me

(Fast)
Who put the bomp in the bomp-bah-bomp-bah-bop ? who put the ram in the ramma-lamma-ding-dong ? who put the bop in the bop-she-bop-she-bop ? who put the dip in the dip-de-dip-de-dip ?

who was that ma-an
I'd like to shake his hand
he made my ba-by
fall in love with me-ee

...
(Chorus, Backing vocals)

Who-oo-oo-oo oo-oo-oo-oo-oo-oo-oo ?
Who-oo-oo-oo oo-oo-oo-oo-oo-oo-oo ?
Who-oo-oo-oo oo-oo-oo-oo-oo-oo-oo ?
Who-oo-oo-oo oo-oo-oo-oo-oo-oo-oo ?

Lyrics: Barry Mann, Gerry Goffin
Music: Johnny Maestro
Artist: Barry Mann and the Halos
1961
http://youtu.be/lXmsLe8t_gg?list=RDiDcvmrHV9Jc <<<<

Who ? Er, not me, the incomparable Dr Edgar F Codd, I am just a faithful, un-subverted disciple.

Small but Important Correction

d. The method is:
___ Delete the fact in StudentExamination ( Ada | Networks ). Notice, only the PK is required, but you are actually addressing the fact of ( Ada | Networks | 3/10,1pm | 101). ___ Add the fact in CourseExamination ( Networks | DateTime_X | Room_Y ), which cannot be ( 3/10,1pm | 101 ) because that slot is already taken by ( Networks )

Should be:
___ Add the fact in CourseExamination ( Security | DateTime_X | Room_Y ), which cannot be

Cheers
Derek Received on Wed Feb 11 2015 - 05:41:15 CET