CMIS 320
Name:_________________________


Download the bible.zip file, unzip it to extract the bible_kjv.txt

What is the size of the bible.zip in KB, MB and bytes:__________
What is the size of the bible_kjv.txt in KB, MB and bytes:__________
What is the compression ratio of this Zip file:________
i.e. ratio of uncompressed to compressed 

Create the Bible table using bible.sql (which loads bible_kjv.txt).

Answer these queries:

0. When the text file is loaded, how many records are inserted:_______

Paste the table's Description:

Paste SHOW CREATE TABLE bible\G

What is the engine type:____________

1. The number of verses, the total length of the verses, the average, min,
and max lengths (in number of characters) of the verses:

a. How many verses and characters in the Old Testament:

b. How many verses and characters in the New Testament:

2. The row with the shortest verse.

3. The book, chapter and verse number of the longest verse.

4. The book with the most verses.

5. The book with the most characters.

6. The book with the shortest average verse length.

7. In how many verses does 'Jesus' appear in the Old Testament?

8. The number of verses containing Magdalene.

9. The books in which Magdalene occurs.

10. A space separates the words of the verses.  If we could count the
number of spaces we would know the number of words in a verse. This will do so:
length(verse)-length(replace(verse,' ',''))+1
The replace function returns a string with all instances of the second argument,
here a space, replaced by the third argument, here nothing, i.e. delete the spaces.
The number of characters of the verse minus the number of spaces equals the number of words.
Adding the one is for the last word of the verse.
Assumes there are no consecutive spaces, and there aren't:   verse like '%  %'
  The number of words in this Bible:

11. The number of verses containing Ethiopia.

12. The verses that contain Ethiopia more than once.

13. The longest verse that contains David.

14. The book with the most number of words, and that number.

15. You propose an interesting question and then answer it.

16. The book with the most number of chapters.

17. The book(s) with one chapter.