Session Ready
Exercise

Creating tables in existing schemas

The SBA provides twelve different funding opportunities. Two popular programs are the 7a and 504 programs. These loans have different purposes where 504 loans are typically used for real estate purchases and 7a loans are typically for general business needs. You have been tasked with the creation of tables which share a name but allow for different structures within their respective schemas. The schemas for these loans have already been created for you (named loan_7a and loan_504, respectively).

You will now put your knowledge to use to add new tables to these existing schemas.

Instructions 1/4
undefined XP
  • 1

    Create a bank table in the loan_504 schema consisting of id and name (max of 100 characters) columns.

    • 2

      Replicate the columns of the loan_504.bank table in the loan_7a schema adding an express_provider boolean column.

    • 3

      Create a borrower table in the loan_504 schema with id and full_name (max of 100 characters) columns.

    • 4

      Replicate the columns of the loan_504.borrower table in the loan_7a schema by adding an individual boolean column.