Challenge Overview
Challenge Objectives
-
Create a data factory for each type of data that appears in the tables.
-
Create a separate data population routine for each table.
Tech Stack
-
SQL
Detailed requirements
You will find a DDL file attached on the challenge forum (available after you register on the challenge).
Each table defined in the DDL follows the <Entity>.<Sub-Entity> naming convention.
As part of this challenge, using SQL functions and procedures, you need to:
1. Create a data factory for each type of data that appears in the tables
-
Things like names and phone numbers appears repeatedly, a single function that acts as a random, but constrained, data factory will speed up the process of populating the tables with mock data.
-
The mock data has to be meaningful but not authentic. Do not just use random strings.
2. Create a separate data population routine for each table.
-
This is somewhat important due to the constraints that appear in the schema. You can only insert valid data into constrained columns, so you need to develop a logical relationship between columns from one table to another. The only way to do this reliably is to have a separate routine for each table.
3. Create a top-level routine that will coordinate the whole process of inserting data into the tables.
Feel free to ask any questions on the challenge forum.
Important Note
This challenge is protected by your NDA. Do not share the DDL or any information from this challenge.
Read more here: https://help.topcoder.com/hc/en-us/articles/217482078-Non-Disclosure-Agreement-NDA-
What to Submit
Submit your code in a zip file and instructions on how to test it.