Authors: Wooyoung Jeong and Jisu Kim

In this data set, there is detailed information of each city, state and region with specific latitude. There are 250 countries, 4857 states, and 147400 cities. Based on specific geographical information of many different areas, we decided to dig further to find out specific unique information about areas that are separated by certain longitude and latitude points.

In this data set, there is randomly generated data for merchandizing company. There are total 10 tables that have customer, employee, product and other infomration. Based on the relationship between tables, we wrote the code that can analyze the trend of the business including hidden deparment information about employee department.