normalization
From: ParekhMa <parekhma_at_aol.com>
Date: 27 Apr 2001 01:52:03 GMT
Message-ID: <20010426215203.01542.00001332_at_ng-ba1.aol.com>
+-------------+---------- +
| chapter_id | word_id | font_type | Language | paragraph_id | word |
Date: 27 Apr 2001 01:52:03 GMT
Message-ID: <20010426215203.01542.00001332_at_ng-ba1.aol.com>
I am sorry if the following doesn't look right but which normal form would you say the following database is in:
+-------------------------+ | file |
+-------------+-----------+
| path | book_id |
+-------------+-----------+
| book.html | 1 |
+-------------+---------- +
+-------------------------------------------------------+ | Title | +----------+------------------+---------+--------------+| book_id | book_name | owner | chapter_id |
+----------+------------------+---------+--------------+
| 1 | Computing | - | 1 |
| 2 | ART | Jack | 2 |
+---------+------------------+---------+---------------+
+-------------------------------------------------------------------------
----------+
| Content
|
+-------------+-----------+-----------+-------------+------------------+--
--------+
| chapter_id | word_id | font_type | Language | paragraph_id | word |
+-------------+-----------+-----------+-------------+-----------------+--- -------+ | 1 | 1 | Arial | English | 1 | The | | 1 | 2 | verdana | English | 2 | father | | 2 | 9 | Arial | English | 5| Paint |
+-------------+-----------+-----------+--------------+----------------+----------+Received on Fri Apr 27 2001 - 03:52:03 CEST
