Your task is to examine that relational data model, then pick one query you would like to optimize, and design a data warehouse table that optimizes for that specific query. Some examples of queries include:

• Which candidates have a PhD in Computer Science?
• Which candidates have > 10 years of experience working professionally?
• Which candidates had a gap of greater than a year in their experience?

Think of a query other than the ones listed above, and design a table that optimizes for that query.

Your submission should contain the following:

• An explanation of your use case
• A "create table" statement for your denormalized table
  • Keep in mind that purpose built tables are often very small!
• An ETL statement that extracts data from the database you created in last week's exercise into this week's table
  • You should exclude records that have not been "finalized"
  • If your database in last week's assignment did not include a finalization concept, just pretend there's a boolean flag on each record
• There's no need to write exactly valid SQL
  • I would like to see field names and data type

About

Experienced Engineer with a demonstrated history of working in the Department of Defense industry. Skilled in Energetic Materials, Manufacturing, Instrumental Analysis, Proposal Writing, and Patent Preparation. Strong engineering professional with a Bachelors Degree focused in Chemistry from Colorado Mesa University.

Experience

• Research Chemist and Principal Investigatr

Oct 2012 Mar 2017

Grand Junction, Colorado

Principal investigator for US DoD applications with a strong chemistry background and progressing responsibilities, experienced in strategic project planning, novel research and development, and business development. Specialties: explosives, pyrotechnics, propellants, additive manufacturing, instrumental analysis

Principal investigator for US DoD applications with a strong chemistry background and progressing responsibilities, experienced in strategic project planning, novel research and development, and business development.

Colorado Mesa University

Bachelors DegreeChemistry

2010 2014

Activities and Societies: Chemistry Club and Structured Research and Development

Graduated with institutional honors. Led Structured Research to develop experimental processes to identify and quantify oak volatiles and hop bitterness in wine and beer, respectively. Recipient of Deans List Scholarship for academic achievement. Recipient of Presidents List Scholarship for academic excellence.

Graduated with institutional honors. Led Structured Research to develop experimental processes to identify and quantify oak volatiles and hop bitterness in wine and beer, respectively. Recipient of Deans List Scholarship for academic achievement. Recipient of Presidents List Scholarship for academic excellence.

• Colorado Mesa University

Colorado Mesa University

Machining Technology

2007 2010

Information User ID User_FirstName User_LastName User Email User_Phone Number Education_ID Education ID (FK) Job Title_ID (FK) User_Skills Name Education Education ID User_SchoolName User_Major User_degree Jobskills User Skills Name User_Job Description Jobskills ID Job Title Job Title ID Location_ID Start_date End date