"Leandro Guimaraens Faria Corsetti Dutra" <leandro@dutra.fastmail.fm> wrote in message news:pan.2004.05.31.12.28.27.729303@dutra.fastmail.fm...

1) One side suggests that in order for a table to violate 2NF, the table
must have attributes that are dependent on only part of a compound
PK--this implies that 2NF violations only apply to situations in which a
table has a compound PK. This requirement has been stated ...

It struck me when reading one of Leondro's responses to mountain man that
over the past two years of studying first pick and then relational databases
(history, theory, and practice), along with OO and XML, I have gotten a bit
of the "flavor" of each sub-culture (just a bit).

Hi Gang,
Hope somebody can help or steer me in the right direction. I know this
kinda thing has been done before, but I'm having a hard time getting
my head around it right now.

I'm designing a database to keep a list of my current projects, and various
details about them.
I'm stuck on the normalization and design aspects.
Here is the layout:

There are events, a rehearsal, another rehearsal, a performance. etc. These
are instances of entity type 'event'. They have attributes like venue, start
time, date etc.
A group of them together make up a production (there may be some BOM type

My reading of Date allows me to assert his detailed
coverage of the theoretical ground of database
systems technology lacks any meaningful discussion
of the (one would implicity assume exists) application

Hey, I'm featured in dbdebunk.com's quote of the week, and
not even in a particularly bad way!
The Q: is me, and the A: is Neo.
I suppose Bob would take me to task for feeding the trolls.

I am relatively new to database design, and what I am working on is
definitely pushing the envelope of my abilities. So I wanted,
hopefully, to get a second opinion.
The databse is for accepting photograph submissions for an online

Me and a friend are currently writing a short paper about Data Quality
(problems, causes, solutions) at our university.
I read the article "Total Information Quality Management, a Complete
Methodology for IQ Management" at

In the "Network Data Model" thread, there was some discussion whether E.F. Codd
deserves credit for originating the concept of the data model.
"Conventional wisdom has it that Codd invented not only the concept of network
and hierarchical data models, but the very concept of a data ...

I thought I got my head round relational algebra until this question came
up....
We have a database with the following relations:
Division([divono],div_name,)

Roman numerals: i, v, x etc...
i, ii, iii, iv, v, vi, vii, viii, ix, x.
Arabic: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9.
Try one:

Leandro Guimares Faria Corsetti Dutra <leandro@dutra.fastmail.fm> wrote in message news:<pan.2004.05.11.21.37.13.680915@dutra.fastmail.fm>...

Let's say that someone likes to model data as functions [e.g.
PERSON(key)=tuple ], in non-1NF and in di-graphs (so you can navigate your
way through it), with a target implementation in XML or PICK.  I have heard
people say that is a good way to "view" the data, but we need to model ...