Supporting an SBA marketing campaign

The SBA has recently seen applications for their loan offerings decline. You have been hired to build a database to support marketing campaigns to increase SBA loan applications. In this exercise, you will define a campaign table to track campaign characteristics and results. Descriptions for the fields of this table are as follows:

an id column to assign a unique identifier to each campaign
a name column restricted to 50 characters in length
a budget column that is restricted to monetary values less than $100,000
a num_days column to indicate the length in days of the campaign (typically 180 days or less)
a goal_amount column to track the target number of applications
a num_applications column to track the number applications received

Este ejercicio forma parte del curso

Creating PostgreSQL Databases

Ver curso

Instrucciones del ejercicio

Define the campaign table including the required columns (id, name, budget, num_days, goal_amount, num_applications) and the most appropriate data type specification for each.

Ejercicio interactivo práctico

Prueba este ejercicio completando el código de muestra.

-- Create the campaign table
___ ___ ___ (
  -- Unique identifier column
  ___ ___ PRIMARY KEY,
  -- Campaign name column
  ___ ___(50),
  -- The campaign's budget
  ___ NUMERIC(___, ___),
  -- The duration of campaign in days
  ___ ___ DEFAULT 30,
  -- The number of new applications desired
  ___ ___ DEFAULT 100,
  -- The number of received applications
  ___ ___ DEFAULT 0
);

Editar y ejecutar código