Laboratory on SQLite

Introduction

The GPM is an experimental project to create knowledge from proteomics data & reuse it solve biomedical research problems.

Analyze the structure of the database you downloaded, as well as the data in it, and write down the different table names and their structure. This will be useful in the following questions.
The “expect” value of a protein is the base-10 log of the expectation that any particular peptide assignment was made at random (E-value).
- Find the number of entries for which the expectation is greater than -100.
Find out from which institution the data for this project comes.
In what table and what field can you get the sequences of the proteins?

Make a copy of the database, and perform the following operations on it:
- Add a new table called grades that will contain columns for student ID, first name, last name, assignment 1 grade, midterm, assignment 2 grade, final grade as a number and final grade as a letter. Declare the student ID as an “INTEGER PRIMARY KEY”. This will avoid having two students with the same ID.
- Add some fake data in the table (3 records). No need to have the correct calculations for the final grade :)
- Dump the student ID and the midterm grades in a text file, with the tuple of values separated with a comma. This will in effect create a CSV file.
Modify the institution name that you found earlier to say “McGill University’s School of Computer Science”