Linux Fundamentals part 4 final

Below are questions related to the command line use of Linux.  You can use the videos, man pages, and notes to answer these questions. 

Remember that Linux is CASE SENSITIVE.  Rm and rm are NOT the same command.  I will count off totally for a question if you do not take this into account.

For each command give me the ENTIRE COMMAND SEQUENCE.  If I ask you  'What command would I use to move the file one.txt to the parent directory and rename it to two.txt?", the answer is NOT 'mv'. That is only part of the command. I want the entire command sequence.

16. Find all files under ~ whose content contain the keyword taco OR Taco OR taCo OR tacO. NOT all variations in case for 'taco', but just the variations listed meaning a keyword of tAco, tACO, tACo, etc, will not produce a result.

17. Find all files under the current directory which ends in '.txt' (just the .txt not the single quotes) and use -exec to create a listing of each files inode number. Since we're using -exec, this means we will call another command to produce the inode based on the results found. What command do we use to make listings? Now you just need to find how to make it produce an inode result. To the man page!

18. What command would I run to update the database of file names used by the locate command?

19. Find all files under the /var directory with a size less than 1 kilobyte. Use -exec and an appropriate command to copy those files to ~/Documents/FallFun/sep.

20. Find all files under the ~ directory that are named 'Picard' ignoring case.

Using the C language:

In the old days, data was stored on punched cards of 80 or 96 columns.

Presume your job is to update a database to include the newly found data in the file punchcard.txt
into a currently used data base. In order to do that, you must read in the data in columnar format
and convert it to comma separated fields so it can be imported.

Using buffered I/O functions (e.g. fopen, fclose, fprintf, fscanf, fread or fwrite, fgets, fgets, etc),
read the columnar data in punchcard.txt into your program. It has the following fields:

   unsigned int user_number 6 columns
   char name 32 columns
   char address 32 columns

Write the data out to a file called import.txt which is of the following CSV format for each line:

   user_number,name,address<carriage return>

If the data in name or address contains a comma, it must be delimited with double quotes around
it. Make sure you remove all extraneous spaces in front of, or behind the data so that the entry in
the import.txt file has no extraneous spaces which is not part of the data. This is often called
"trimming" the data.

punchcard.txt contains...

289383Estefana Lewey 9940 Ohio Drv, 85021
930886Burl Livermore 226 Amherst, 08330
692777Lannie Crisler 8143 Woods Drv, 20901
636915Zena Hoke 82 Roehampton St, 47905
747793Vicente Clevenger 9954 San Carlos St., 55016
238335Lidia Janes 348 Depot Ave, 29576
885386Claire Paladino 587 Front Ave, 32703
760492Leland Stillson 9793 Boston Lane, 08610
516649Wes Althouse 8597 Annadale Drive, 06514
641421Nadia Gard 218 George Street, 29150

Thank you in advance.

5.8. Discuss the entity integrity and referential integrity constraints. Why is each
considered important?
5.9. Define foreign key. What is this concept used for?
5.10. What is a transaction? How does it differ from an Update operation?

How about the differences between relational, object-oriented, and multidimensional databases in healthcare? What makes each type of database stand out from the other?

Bioinformatics:

What could be some of the reasons why your query sequence did not exactly match the sequence in the database (think of sampling, sequencing, and biological reasons).

What are your thoughts on this statement?

The job database algorithms work only in perfect scenarios. They do not have the ability to think outside the box as an individual might.

a) List any three causes of database failures and explain any one of those causes. [4]

b) Explain any six characteristics of a Relation [6]

Describe and share how querying a database is going to be beneficial to you in your current or future career. Explain your answer in no less than 150 words.

Need SQL commands for these questions based on the bowling league database; When was the first tournament date and where was it played? What are the number of tournaments per location?