Re: first normal form

From: <joe_celko_at_my-deja.com>
Date: 2000/03/28
Message-ID: <8bqmi4$740$1_at_nnrp1.deja.com>#1/1

>> a table with firstName,lastName,allName(which is firstName ||
lastName), is this table in first normal form? <<

There are no repeated groups in the rows. If you had columns for the names of his kids in the row, then you would have an non-1NF table. But I agree it is not normalized since I have non-atomic data in the third column.

--CELKO-- Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Mar 28 2000 - 00:00:00 CEST

This message: [ Message body ]
Next message: Markus Janscha: "Reporting Database design"
Previous message: Kevin King: "Re: Surrogate Keys As Part Of Composite Keys?"
In reply to: DOM: "first normal form"
In reply to DOM: "first normal form"
Next in thread: edbs_at_icon.co.za: "Re: Entity Relationship Diagrams - Conceptual - Logical"
Reply: DOM: "Re: first normal form"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message