rio-tinto

Challenge

In the terminal, navigate to the challenge directory and run the following commands:

1. Run Python file:

python3 rio-tinto.py

2. Start MySQL Server:

mysql.server start

3. Launch MySQL CLI:

mysql --local-infile=1 -u root

4. Store data in table with schema.sql and seed.sql:

source schema.sql;
source seed.sql;

5. Select data from table (see screenshot of output below):

select * from ship;

6. Exit MySQL CLI:

exit;

7. Stop MySQL Server:

mysql.server stop

Screenshot

Here is a screenshot of the MySQL table with imported enriched.csv data:

Bonus

The solution to the bonus question can be found here: bonus.sh.

Business Case Scenario

The solution to the business case scenario can be found here: logical-data-model.pdf.