Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

One reason to keep all the tables separate is to facilitate adding things to them later. Also 
localization for other languages and to keep entries exact so searches are easier to do. Solves 
issues with How did I spell that? problems in queries

To my mind the only thing that belongs in a table are things that are only related to that item. 

Since there has to be a one-to-one relation between the ReadStatus
table and the BookInformation table, you might as well merge them.

The way you have it rather misses the point of a status table. I
wouldn't merge them, I would instead add a ReadStatusID to the
BookInformation table, and change the ReadStatus table to:


You want to store entries in here like the following:
1  -  Finished Reading
2  -  Not Started
3  -  Busy Reading
4  -  Could Not Finish
5  -  Must Read Soon

that sort of thing.

There is a one to many between read status and book info so it would need tobe a separate table in 
my mind. Exactly as above. So it would be a foreign key in the book table. 

Hrm. It does depend on what you want to do with rankings.

You could merge them into the BookInformation table, have a varchar
field that holds a short description of each ranking category for each
book, or you could make this also a status table. Add DepthRankingID,
LessonsRankingID, CitationsRankingID etc fields to the BookInformation
table, and have the Rankings table like so:


With the following sorts of entries:

1  -  Very Poor
2  -  Poor
3  -  Average
4  -  Fair
5  -  Good
6  -  Excellent
7  -  Specially Awesome
8  -  Good but incomplete
9  -  Thorough, but dry

By the way, carefully consider how you intend to import the data from
your original spreadsheet to the database. There are various ways to
do it, and how you structure your database will impact how you import
your data.

I found that it was easiest to strip out and create a separate spreadsheet for each of the tables 
in my database, copy the data to it from the original behemoth of a spreadsheet, save as a .CSV 
file and use a .CSV to SQL importer function to get the data into my database But my spreadsheet 
originally consisted of 15 separate sheets in one file each with approximately 200 rows and about 
700 columns. I am using SQLite as my database not BASE. 

Eugenie (Oogie) McGuire 
Desert Weyr, LLC - Black Welsh Mountain Sheep  
LambTracker - Open Source SW for Shepherds
Paonia, CO USA

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.