data redundancy

[maxmangion]

in having the following tables in a database, would you think, i will be creating data redundancy:

tblMainCategory
MainCategoryID - autonumber
MainCategory - text

tblSubCategory
SubCategoryID - autonumber
SubCategory - text
MainCategoryID - Foreign Key to above table

tblCategory
CategoryID - autonumber
Category - text
SubCategoryID - Foreign Key to SubCategory Table
MainCategoryID - Foreign Key to MainCategory Table

tblMainTable
BookID - autonumber
Book - text
author - text
MainCategory - Number
SubCategory - Number
Category - Number
(These last three fields will be combo boxes) where later when creating the forms, i shall use these three fields as cascading combo boxes.

Does the above scenario creates data redundancy ?

Thank you!

 

[R6Flyer]

I would suggest having a lookup table for your authors:

tblAuthors
AuthorID (autonumber)
AuthorDESCR (text)

 

[dcx693]

What kind of information would you be storing in the Category, Main Category and SubCategory fields? Why have a category and main category field? Perhaps it's just the naming that seems redundant.

What are you capturing in here:
tblCategory
CategoryID - autonumber
Category - text
SubCategoryID - Foreign Key to SubCategory Table
MainCategoryID - Foreign Key to MainCategory Table

 

[maxmangion]

actually, in reality i was going to create the author field from a lookup table as you suggested, but i did not mention it here since the focus of my thread was more on data redundant with the 3 categories fields.

the idea behind those fields is that since i have several books/articles/tutorials regarding IT, i have the intention of categorise such books into the following manner:

Main Category Sub Category Category
========== ========== =======
Computers Programming C++
Computers Web Development HTML
Computers Networking TCP/IP
Computers Programming Visual Basic

and the list goes on.

The idea behind categorise my books collection, is so that i could create several different queries, all based on certain criterias such as a particular category only, or maybe a particular sub category etc.

i know that maybe the fact that i am not going to have a several thousands records database (therefore not experiencing many slow downs), but i am still looking to create it in the right manner.