Week 73 – Intermediate

We’ve gotten the message that some of our DBAs are loosing grasp of the internal structure of our FakeCompany inc. Let’s try to help them out!

To aid in this, we’re initiating a challenge! Your task is to create a reference table that encapsulates the essential aspects of our internal database structure.

What You Need to Do

Examine the Provided Table Image: A reference image (see below) outlines the basic format and information your table should include.

Create a Similar Table: Develop a table that mirrors the structure shown in the image. Make sure your table is tailored to reflect our specific database architecture at FakeCompany Inc.

The starting code for this challenge:

CREATE OR REPLACE table departments (department_name varchar, department_ID int, head_department_ID int);

INSERT INTO departments (department_name, department_ID, head_department_ID) VALUES
    ('Research & Development', 1, NULL),  -- The Research & Development department is the top level.
        ('Product Development', 11, 1),
            ('Software Design', 111, 11),
            ('Product Testing', 112, 11),
        ('Human Resources', 2, 1),
            ('Recruitment', 21, 2),
            ('Employee Relations', 22, 2);

Remember if you want to participate:

1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘ (note joining our mailing list does not give you a Frosty Friday account)
2. Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
3. Post the URL in the comments of the challenge.