Task 1: Database Exploration

To start with, let’s get to know the database further. You should feel comfortable doing this task after Chapter 7: SQL Part 1 .

Question

Make note of each table in the database, the columns within each table, each column’s data type, and how the tables are connected. You can write this down or draw a diagram. Whatever method helps you get an understanding of what is going on with LaborStatisticsDB.

To add a photo, diagram or document to your file, drop the file into the folder that holds the notebook. Use the link button to the right of the </> symbol in the gray part of the cell to create a link. The link you are looking for is just the name of the file for your visual.

Question

What is the datatype for women employees?

Question

What is the series id for women employees in the commercial banking industry in the financial activities supersector?