Computer Science Assignment

1.   Part of this position involves connecting to databases to extract data. What is/are your suggestion(s) for keeping passwords secure while doing so?

2.   You have the following table in a MySQL database:
| id  | name    | parent |
| 1   | ’home’  | 1      |
| 2   | ‘mobil’ | 1      |
| 3   | ‘motor’ | 1      |
| 147 | ‘toyota’| 2      |
| 160 | ‘bmw’   | 2      |
| 301 | ‘honda’ | 3      |
| 488 | ‘vespa’ | 3      |

Write an SQL-query to produce the following output:
| id | category | subcategory |
| 147| ‘mobil’  | ‘toyota’    |
| 160| ‘mobil   | ‘bmw’       |
| 301| ‘motor’  | ‘honda’     |
| 488| ‘motor’  | ‘vespa’     |

Python

1.   Assume you have managed to load the expected output from the previous question to a Pandas DataFrame (if you are not familiar with Pandas, show how you would load the output from a .csv file and continue with your preferred method). Write code that gives you only the rows where the category is ‘mobil’.
Expected output (no need to print):
| id | category | subcategory |
| 147| ‘mobil’  | ‘toyota’    |
| 160| ‘mobil’  | ‘toyota’    |

2.   What is/are, in your opinion, the best and worst features in Python?