Re: Hierarchical Model and its Relevance in the Relational Model

On 2015-01-30, Derek Asirvadem <derek.asirvadem_at_gmail.com> wrote: 8>< --------
>==== Task: JKL & JH ====
>
> So here is a small task for you that I think will demonstrate many
> of the issues that we are dealing with in this thread. Given your
> demonstrated skill in the SQLite link and the RM (forget the "rm" of
> the mathematicians), I think this would take 30 mins or less.
>
> Produce a data model for a set of tables that is fully compliant with
> the RM, ie, completely Relational, for the storage of data pertaining to:
> - Countries (Name, FullName, FederationDate, ExpiredDate)
> - State/Province/Territory (Name, FullName, Type)
> - County (Name, Type)
> - Town/Township/Metropolis (Name, Type)
> - Suburb (StreetName(FK), StreetType(FK) )
>
> - StreetName (PK: StreetName (CHAR(50) )
> - StreetType (PK: StreetType (CHAR(3), Name)
>

You left out the Street table!

Eric

-- 
ms fnd in a lbry