how large the largest number will be. • Boolean: a data type with only two possible values, such as 0 or 1, “true” or “false”, “yes” or “no”. • Date/Time: a special form of the number data type that can be interpreted as a number or a time. • Currency: a special form of the number data type that formats all values with a currency indicator and two decimal places. • Paragraph Text: this data type allows for text longer than 256 characters. • Object: this data type allows for the storage of data that cannot be entered via keyboard, such as an image or a music file. There are two important reasons that we must properly define the data type of a field. First, a data type tells the database what functions can be performed with the data. For example, if we wish to perform mathematical functions with one of the fields, we must be sure to tell the database that the field is a number data type. For example, we can subtract the course capacity from the classroom capacity to find out the number of extra seats available. The second important reason to define data type is so that the proper amount of storage space is allocated for our data. For example, if the StudentName field is defined as a Text (50) data type, this means 50 characters are allocated for each name we want to store. If a student’s name is longer than 50 characters, the database will truncate it. Database Management Systems Information Systems for Business and Beyond (2019) pg. 75
Made with FlippingBook flipbook maker