1. Learn
    2. /
  2. Courses
    3. /
  3. Creating PostgreSQL Databases

Exercise

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

Instructions

100 XP
  • 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.