Exercise

Using integer types

The Small Business Administration through its local Small Business Development Centers (SBDC) provides advising and technical support for entrepreneurs and small businesses. Given the importance of having an online presence, the SBA is starting an initiative to help small businesses with e-commerce website development. You have been brought in to develop a database to store data on these development efforts. In this exercise, you will have the opportunity to use your knowledge of integer data types in PostgreSQL for defining a table for SBDC clients.

Instructions

100 XP

Complete the definition of the client table using the most appropriate integer type to support the range of possible data values for the column.