The question:You are designing several databases for a client. While designing the databases, you come across the following listed data items. Which data type would you use to store each of these pieces of information and why?
These are my answers, but I'm not sure I understood. It is for SQL database.
Radius of a planet- Data type int. Juiper is the largest planet with a radius of 43,441 mi which makes it too larger for the smallint datatype.
Value of pi (π)- Data type varchar because the value of pi has a variable length
Salary- smallmoney, because salary would be a money type between 214,748.3648 to 214,748.3647
.Person's date of birth- Data type date*, because a person's date of birth would be between 0001-01-01 through 9999-12-31 and no time is required
Length of a board- Data type tinyint, because the length of a board should be between 0 to 255.
Numbers of music players sold- Data type tinyint, because numbers of music players sold should be between 0 to 255.