Creating Companies Table

Start Timer

0:00:00

Let’s say that you’re in charge of creating a new companies table at your new startup’s database. Your boss wants you to track all major companies that could be interesting leads for salespeople.

You’re given a huge list of scraped company names from many different websites with a few fields such as:

  • Name

  • No. of Employees

  • Industry

  • Location

  • Primary phone

  • Date Established

The scraped list may include duplicates and misspellings. How would you create a new production_companies table prioritizing correctness while also ensuring we do not include duplicates?

.
.
.
.
.
Topic
Data Modeling
Tags
SQL
Data Modeling
Data Cleaning
Data Deduplication
Category
Case Study
Position
Data Engineer
Business Analyst
Difficulty
Medium
Success
N/A
Last asked
This question was asked on December 17, 2025
Companies
What did you think?


Comments

Loading comments