Get the cars_file.txt file from the class web site:
CMIS 325

wget http://davidwills.net/cmis325/cars_file.txt

Its five fields are: make, model, year, mileage, price.
What kind of file is it? (use the file command)_____________________
How many lines, words, characters are there? (wc)_____________________
What are the whitespace characters between the fields? (od)_____________________
What is its inode number? (ls)_____________________
What is the command to extract the second and fourth columns? (cut)_____________________
What is the command to sort by:
  lines (ie. default sort)_____________________
  by model  _______________________
  reversely by year_____________________



Using japan.txt from the same web site:
What kind of file is it?_____________________
How many lines, words, characters are there?_____________________
What are the whitespace characters between the fields?_____________________
How many disk blocks are allocated to it?_____________________
How many lines contain 'pa'? (grep)_____________________
How many lines contain 'papa'? (grep)_____________________
How many lines contain 'papapa'? (grep)_____________________
How many lines contain 'ma'? (grep)_____________________
How many lines contain 'mama'? (grep)_____________________
How many lines contain 'mamama'? (grep)_____________________
For each of the six fields, what is the smallest and largest values of each:
________________

For each of the six fields, how many different values does each field have:
hint: cut columns and sort -u
_______________


In the 'weblog' file, 
How many different IP addresses requested files:________


At www.gutenberg.org/browse/scores/top is a list of books.
Choose a novel that no one else in the class has yet posted about.
Download (wget) the plain text version of it.
What novel:__________________________
Rename the file more meaningfully to:_____________________
wc:__________________
Edit it to remove the gutenberg header and trailer that isn't part of the novel.
wc:__________________
file:___________________________
ls -l:__________________________



Download the 'createDB' executable file from the same place.
file:________________________
give it execute permission: chmod +x createDB
ls -l:_______________________
Run it (either createDB or ./createDB if your PATH does not include the working directory)
inputting one number which is the number of lines to generate (try 10 at first).
Then run it with 1000, redirecting the output to a file.
Name of the output file:________________
wc of it:__________________
file of it:_____________
For each of the six fields, what is the smallest and largest values of each:
________________

For each of the six fields, how many different values does each field have:
hint: cut columns and sort -u
_______________