Help with Open Source DesignAuthor-Usable Database Table and FieldDesign for Glossary, Index, Spell Check, Persons, Bibliogrpahy, etc.

Access Database Design for a book’s master special word database…

Say an author has a book with “special words” identified for use in a
glossary, index, spell check adder, persons, authors, book titles,
quoted ironic words, possessive words, etc

Since every author needs this; I hope it can be a free collaborative
open source web project to build a freeware database with minimal
features first so everybody can deal with their books professionally;
indeed; I am surprised Microsoft didn’t add one…

The advantage of normal form of course is that one only need enter the
database; indeed the above “mess” was MADE FOR DATABASE NORMAL FORM.

My book is 2600 pages so this could be useful.

So let’s get started and focus on the general one that everybody will
and can use…

What is the correct design for an Access Database (in 6’Th order
normal form) for handling the entire situation?

Right now, I have a MS Excel Spreadsheet with the following columns:
WORD
Multiple Words spelled the same i.e. "read" and "read"
TYPE OF WORD which may be of many types; don’t worry about the full
details just uses the top dozen (NUMERIC, symbol,, DATE RANGE, UNKNOWN
EXACT DATE TO FIX, DATE, Regular, CHEMISTRY, ABBREVIATION OR ACRONYM,
ABBREVIATION, New, , FIRST NAME, LAST NAME, LATIN, LEGAL, NAME
FRAGMENT, NAME (SINGLE ), GEOGRAPHY, SLANG, CONTRACTION, Brand Name,
Weird failure of spell checker requires adding this, RELIGION,
Fragment of word , SCIENCE, ACRONYM, Book title ( from), FIRST
INITIALS, , Computer , Spanish , Trademark, Title of Journal, First
Name Nick Name, from book, from a , Title of Book, , Medical , Title
of Song, Title of Movie, FRENCH, Music , Title of Play, , Product
Name, SPECIES, (for indexing), Title of Book ( from), philosophy ,
Title of Television Series, biblical name of some sort, Title of Play/
Movie, book section , Physics , Book Title, Title ( from), Title of
Movie from, Book, Title of Movie and Book ( from), from a book,
Trademark of Toy, Trademark),
Is word, person, concept FICTIONAL? Yes or Not
Is it in primary form; i.e. plurals are not; possessives are not
The Primary Form of this word which is not the see instead cause of
names:
Spelled OK? Or should be added to spell Checker?
If word is a new word, who invented it
Should this book be in glossary of book "A"
DEFINITION of word
Should this be indexed?
How should it be indexed; i.e. perhaps a word "Paris" should appear
as "Paris (City)"
AE or MW?
Last Name if it is a Person
First Name if it is a person
FULL NAME
ADDITIONAL CAPITALIZATION FORM
ADDITIONAL POSSESSIVE FORM
ADDITIONAL PLURAL FORM?
TITLE of Person
SUBJECT of Person's interest
LOCATION of person i.e. US, Antarctica

Obviously, this is a non-normal “super messed up” join of what should
be several titles

And I have another table for all the quotations in the book, like said
by somebody or titles, words used in meaning, ironic words
With the following types
UNKNOWN
TITLE OF BOOK, MAGINE
EMPHASIS
IRONY
WORD QUA WORD
SPEECH by person


Furthermore, I want a table of persons cited
Which I have not built…It should handle single word persons like
Aristotle and also First and Last Name Persons…

And a table of works citied not yet made
Author(s)
Publishers
Edition
Title
Date Published
Type (book, movie, magazine article, etc…)


I just learned about the normal forms and want to convert everything
to Access; right now, though I am content just with the relationship
design of the database.

So the problem is to design an access database with the specific
TABLES, and ATTRIBUTES within in as normal form as possible; I
realized that everybody might want this database in general since it
would make like for authors easier.

Then this master database will be used to construct the following sub
databases:
Glossary (or multiple glossaries)
List of words to add to spell checker via custom dictionary
Bibliography
What to Index (or perhaps for multiple indices of words, authors,
works citied, etc…who knows…); by constructing the auto mark index
file
Table of Persons

Did you consider Indexing Service?

http://msdn.microsoft.com/en-us/library/ms689718.aspx

On Aug 17, 3:59*pm, arthurtheaut...@gmail.com wrote:
> Access Database Design for a book’s master special word database…
>
> Say an author has a book with “special words” identified for use in a
> glossary, index, spell check adder, persons, authors, book titles,
> quoted ironic words, possessive words, etc
>
> Since every author needs this; I hope it can be a free collaborative
> open source web project to build a freeware database with minimal
> features first so everybody can deal with their books professionally;
> indeed; I am surprised Microsoft didn’t add one…

MS index service is not what I want.

How the data gets in the database is a different story....

I just want to know what tables to build and what fields for them so
everything is in normal form with respec to relational databases...

arthurtheauthor@gmail.com wrote:
> MS index service is not what I want.
>
> How the data gets in the database is a different story....
>
> I just want to know what tables to build and what fields for them so
> everything is in normal form with respec to relational databases...
>
The first thing is to not use Access. It is not intended for "heavy
lifting", and has some serious limitations for on-line collaborative usage.
Access is not "open source", so it misses on that criterion as well.

But, having looked at your original post, I am unclear about why your
intentions can't be met with the built-in spell checking capability of any
decent layout or authoring application.

Regards,

--
Neil Gould
Terra Tu Technical Publishing
www.TerraTu.com

On Aug 17, 3:59*pm, arthurtheaut...@gmail.com wrote:
> Access Database Design for a book’s master special word database…
>
> Say an author has a book with “special words” identified for use in a
> glossary, index, spell check adder, persons, authors, book titles,
> quoted ironic words, possessive words, etc
>
> Since every author needs this; I hope it can be a free collaborative
> open source web project to build a freeware database with minimal
> features first so everybody can deal with their books professionally;
> indeed; I am surprised Microsoft didn’t add one…
>
> The advantage of normal form of course is that one only need enter the
> database; indeed the above “mess” was MADE FOR DATABASE NORMAL FORM.
>
> My book is 2600 pages so this could be useful.
>
> So let’s get started and focus on the general one that everybody will
> and can use…
>
> What is the correct design for an Access Database (in 6’Th order
> normal form) for handling the entire situation?
>
> Right now, I have a MS Excel Spreadsheet with the following columns:
> * * * * WORD
> * * * * Multiple Words spelled the same i.e. "read" and "read"
> * * * * TYPE OF WORD which may be of many types; don’t worry about the full
> details just uses the top dozen (NUMERIC, symbol,, DATE RANGE, UNKNOWN
> EXACT DATE TO FIX, DATE, Regular, CHEMISTRY, ABBREVIATION OR ACRONYM,
> ABBREVIATION, New, , FIRST NAME, LAST NAME, LATIN, LEGAL, NAME
> FRAGMENT, NAME (SINGLE ), GEOGRAPHY, SLANG, CONTRACTION, Brand Name,
> Weird failure of spell checker requires adding this, RELIGION,
> Fragment of word , SCIENCE, ACRONYM, Book title ( from), FIRST
> INITIALS, , Computer , Spanish , Trademark, Title of Journal, First
> Name Nick Name, *from book, *from a , Title of Book, , Medical , Title
> of Song, Title of Movie, FRENCH, Music , Title of Play, , Product
> Name, SPECIES, (for indexing), Title of Book ( from), philosophy ,
> Title of Television Series, biblical name of some sort, Title of Play/
> Movie, book section , Physics , Book Title, Title ( from), Title of
> Movie *from, Book, Title of Movie and Book ( from), *from a book,
> Trademark of Toy, Trademark),
> * * * * Is word, person, concept FICTIONAL? Yes or Not
> * * * * Is it in primary form; i.e. plurals are not; possessives are not
> * * * * The Primary Form of this word which is not the see instead cause of
> names:
> * * * * Spelled OK? *Or should be added to spell *Checker?
> * * * * If word is a new word, who invented it
> * * * * Should this book be in glossary of book "A"
> * * * * DEFINITION of word
> * * * * Should this be indexed?
> * * * * How should it be indexed; i.e. perhaps a word "Paris" should appear
> as "Paris (City)"
> * * * * AE or MW?
> * * * * Last Name if it is a Person
> * * * * First Name if it is a person
> * * * * FULL NAME
> * * * * ADDITIONAL CAPITALIZATION FORM
> * * * * ADDITIONAL POSSESSIVE FORM
> * * * * ADDITIONAL PLURAL FORM?
> * * * * TITLE of Person
> * * * * SUBJECT of Person's interest
> * * * * LOCATION of person i.e. US, Antarctica
>
> Obviously, this is a non-normal “super messed up” join of what should
> be several titles
>
> And I have another table for all the quotations in the book, like said
> by somebody or titles, words used in meaning, ironic words
> With the following types
> * * * * UNKNOWN
> * * * * TITLE OF BOOK, MAGINE
> * * * * EMPHASIS
> * * * * IRONY
> * * * * WORD QUA WORD
> * * * * SPEECH by person
>
> Furthermore, I want a table of persons cited
> Which I have not built…It should handle single word persons like
> Aristotle and also First and Last Name Persons…
>
> And a table of works citied not yet made
> * * * * Author(s)
> * * * * Publishers
> * * * * Edition
> * * * * Title
> * * * * Date Published
> * * * * Type (book, movie, magazine article, etc…)
>
> I just learned about the normal forms and want to convert everything
> to Access; right now, though I am content just with the relationship
> design of the database.
>
> So the problem is to design an access database with the specific
> TABLES, and ATTRIBUTES within in as normal form as possible; I
> realized that everybody might want this database in general since it
> would make like for authors easier.
>
> Then this master database will be used to construct the following sub
> databases:
> * * * * Glossary (or multiple glossaries)
> * * * * List of words to add to spell checker via custom dictionary
> * * * * Bibliography
> * * * * What to Index (or perhaps for multiple indices of words, authors,
> works citied, etc…who knows…); by constructing the auto mark index
> file
> * * * * Table of Persons

Given a list of the words / people and their categories in advance,
easy enough w/ some sed or other scripts and a decent markup system
--- w/o that, well, one has to read through and mark up the manuscript
manually regardless.

William

On Aug 17, 3:59*pm, arthurtheaut...@gmail.com wrote:
> Access Database Design for a book’s master special word database…
>
> Say an author has a book with “special words” identified for use in a
> glossary, index, spell check adder, persons, authors, book titles,
> quoted ironic words, possessive words, etc
>
> Since every author needs this; I hope it can be a free collaborative
> open source web project to build a freeware database with minimal
> features first so everybody can deal with their books professionally;
> indeed; I am surprised Microsoft didn’t add one…
>
> The advantage of normal form of course is that one only need enter the
> database; indeed the above “mess” was MADE FOR DATABASE NORMAL FORM.
>
> My book is 2600 pages so this could be useful.
>
> So let’s get started and focus on the general one that everybody will
> and can use…
>
> What is the correct design for an Access Database (in 6’Th order
> normal form) for handling the entire situation?
>
> Right now, I have a MS Excel Spreadsheet with the following columns:
> * * * * WORD
> * * * * Multiple Words spelled the same i.e. "read" and "read"
> * * * * TYPE OF WORD which may be of many types; don’t worry about the full
> details just uses the top dozen (NUMERIC, symbol,, DATE RANGE, UNKNOWN
> EXACT DATE TO FIX, DATE, Regular, CHEMISTRY, ABBREVIATION OR ACRONYM,
> ABBREVIATION, New, , FIRST NAME, LAST NAME, LATIN, LEGAL, NAME
> FRAGMENT, NAME (SINGLE ), GEOGRAPHY, SLANG, CONTRACTION, Brand Name,
> Weird failure of spell checker requires adding this, RELIGION,
> Fragment of word , SCIENCE, ACRONYM, Book title ( from), FIRST
> INITIALS, , Computer , Spanish , Trademark, Title of Journal, First
> Name Nick Name, *from book, *from a , Title of Book, , Medical , Title
> of Song, Title of Movie, FRENCH, Music , Title of Play, , Product
> Name, SPECIES, (for indexing), Title of Book ( from), philosophy ,
> Title of Television Series, biblical name of some sort, Title of Play/
> Movie, book section , Physics , Book Title, Title ( from), Title of
> Movie *from, Book, Title of Movie and Book ( from), *from a book,
> Trademark of Toy, Trademark),
> * * * * Is word, person, concept FICTIONAL? Yes or Not
> * * * * Is it in primary form; i.e. plurals are not; possessives are not
> * * * * The Primary Form of this word which is not the see instead cause of
> names:
> * * * * Spelled OK? *Or should be added to spell *Checker?
> * * * * If word is a new word, who invented it
> * * * * Should this book be in glossary of book "A"
> * * * * DEFINITION of word
> * * * * Should this be indexed?
> * * * * How should it be indexed; i.e. perhaps a word "Paris" should appear
> as "Paris (City)"
> * * * * AE or MW?
> * * * * Last Name if it is a Person
> * * * * First Name if it is a person
> * * * * FULL NAME
> * * * * ADDITIONAL CAPITALIZATION FORM
> * * * * ADDITIONAL POSSESSIVE FORM
> * * * * ADDITIONAL PLURAL FORM?
> * * * * TITLE of Person
> * * * * SUBJECT of Person's interest
> * * * * LOCATION of person i.e. US, Antarctica
>
> Obviously, this is a non-normal “super messed up” join of what should
> be several titles
>
> And I have another table for all the quotations in the book, like said
> by somebody or titles, words used in meaning, ironic words
> With the following types
> * * * * UNKNOWN
> * * * * TITLE OF BOOK, MAGINE
> * * * * EMPHASIS
> * * * * IRONY
> * * * * WORD QUA WORD
> * * * * SPEECH by person
>
> Furthermore, I want a table of persons cited
> Which I have not built…It should handle single word persons like
> Aristotle and also First and Last Name Persons…
>
> And a table of works citied not yet made
> * * * * Author(s)
> * * * * Publishers
> * * * * Edition
> * * * * Title
> * * * * Date Published
> * * * * Type (book, movie, magazine article, etc…)
>
> I just learned about the normal forms and want to convert everything
> to Access; right now, though I am content just with the relationship
> design of the database.
>
> So the problem is to design an access database with the specific
> TABLES, and ATTRIBUTES within in as normal form as possible; I
> realized that everybody might want this database in general since it
> would make like for authors easier.
>
> Then this master database will be used to construct the following sub
> databases:
> * * * * Glossary (or multiple glossaries)
> * * * * List of words to add to spell checker via custom dictionary
> * * * * Bibliography
> * * * * What to Index (or perhaps for multiple indices of words, authors,
> works citied, etc…who knows…); by constructing the auto mark index
> file
> * * * * Table of Persons

Cool thanks!