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

Exercise

Two tables and a foreign key connection

The Small Business Association (SBA) captures a large amount of data on their loan programs and releases it publicly. Some of the available data includes details on the applicant (including name and address) and how the business is organized (the business type). As you are developing your project to better understand characteristics behind which loans are approved and which are rejected, you suspect that details about the applicant and business type will be important to include in your analysis.

Three business types are defined. These types are "Individual", "Partnership", and "Corporation". You ultimately want to associate the applicant and the business type for which she is seeking a loan. You will create new tables in the sba database for this data.

Instructions 1/2

undefined XP
    1
    2

Create a new table named business_type which includes a unique identifier field named id and a text field named description.