Assignment 3: Working with Relational Databases and SQL

1. 75 points

Convert the flat file data in data/flat.csv into a well-structured relational database in SQLite3 stored as data/faculty.db. Note - salary information is confidential and should be kept in a separate table from other personal data.

2. 25 points

We want to find potential mentors for Abram Boyer. Find all faculty members who know one or more of the same languages as Christopher Robbins whose salary is at least $50,000 higher than his using SQL statements. Assume that the only information you have is that you need to find mentors meeting the criteria for the faculty member named Abram Boyer. In other words, the ONLY hard coded terms in your SQL query are Abram and Boyer and the salary differential.

You can use the sql magic extension or the sqlite3 driver for this question.