Re: [libreoffice-users] Currently Using Spreadsheet for Personal Project - Thinking About Database

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:
>
> ReadStatusID
> ReadStatusDescription
>
>
> 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:
>
> RankingID
> RankingDescription
>
> 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
> etc
>
> > 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 http://www.desertweyr.com/  
LambTracker - Open Source SW for Shepherds http://www.lambtracker.com
Paonia, CO USA


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted