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.
This exercise is part of the course
Creating PostgreSQL Databases
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Define the business_type table below
___ ___ ___ (
___ serial PRIMARY KEY,
___ TEXT NOT NULL
);