🔗 Link: https://awsrestart.instructure.com/courses/1632/modules/items/886874

Scenario

You are creating a database to track sales and inventory for the Canal House Books store, which sells books and various other products. Canal House has an adjoining coffee shop that sells coffee drinks and food, and hosts events such as music performances, book signings, art shows, and poetry readings. Data types are needed to provide additional methods and calculations to enhance your current view. Specifically, you might find it difficult to multiply two numbers that have a data type as a string or a character.

Objective

In this lab, you will:

• Practice data type and threshold boundary identification, and the ability to merge using sample data

Exercise 1: Update Model to Include Data Types

In order to establish a solid design plan for your database, it is important to understand what each data type should be represented as. This information can be derived from your required end state of the data. Do you need to do any mathmatical operations on the data? Does it need to be manipulated in transit, or is it just purely a store and lookup requirement?

TODO

1. For each column in the table below, identify the data type, minimum and maximum boundaries, and whether the data can be combined with the data in another column.
2. Populate the resource table on the next page with your answers.

Note

Max and min should be estimates based on knowledge gleaned from the data table alone.

Data Table

Resource table

Nota: MySQL provides a BOOL type as a synonym for a TINYINT.