Scribd
Upload
145 views12 pages

Data Types

This document discusses different data types used in programming and databases. It outlines 8 main data types: Boolean, character, integer, floating-point, alphanumeric, date/time, currency, and binary. Each data type stores specific types of data, like logical values for Boolean, strings for character, numbers for integer, dates for date/time, and monetary values for currency. Understanding these data types is important for effective software development and database design.

Uploaded by

alex
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
145 views12 pages

Data Types

This document discusses different data types used in programming and databases. It outlines 8 main data types: Boolean, character, integer, floating-point, alphanumeric, date/time, currency, and binary. Each data type stores specific types of data, like logical values for Boolean, strings for character, numbers for integer, dates for date/time, and monetary values for currency. Understanding these data types is important for effective software development and database design.

Uploaded by

alex
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
You are on page 1/ 12

Name:

Institution:
Introduction
Data types are specific information classifications that
objects and variables holds in programming.
They are significant factors in programming languages.
They inform compilers of predefined variable properties.
Different data base application use different data types.
These applications comprises of: visual basic, MS access,
java script and C++ (Sutherland, 2002).
A stored variable must have a particular data type.
1. Boolean (logical)
Data type with 2 values denoted as TRUE or FALSE.
It was developed by George Boole.
It enables user represent logical fl0w.
It is the primal result of restrictive statements.
Used in locating precise matches in the internet
(Sutherland, 2002).
Example of field Boolean would be used includes
Quiz, training and investigations.
2. Character
Stores strings of numbers, symbols and letters.
Data may be stored as a variable-length or fixed-
length string.
VARCHAR and CHAR are its main string types.
Data is stored using CHAR, TEXT and VARCHAR
strings.
Its field store information not utilized in mathematic
calculation.
Example includes: names, phone numbers and
addresses.
3. Integer
Data type representing finite sub-set of
mathematician integers.
Written as a series of digits prefixed by a - or+ signs.
Integers do not have decimal places.
May be of diverse sizes
May not or may have different values.
Used in investigation departments and computer
systems to find the location of an item.
4. Floating-point
A variable data type used in storing floating point
number values.
Have fractional part expressed by decimals.
They have numbers, exponent and base.
Effectively represent approximation of real numbers.
Supports a broad array of values.
Used in hardware for computation purposes.
5. Alphanumeric
Data type made of both numbers and letter.
Commonly used in explaining text availability.
“1c2a3d" is a short example of an alphanumeric string.
Symbols such as +$@%^ are also allowed.
The data type also recognizes spaces.
Alphanumeric are used in filenames, authentication
and security fields.
6. Date and Time
Data type that consists of a combination time and
date.
Data type provides for storage of year, month and day.
“Small-date-time” and date-time data types stores
date and time data (Allert, 2009).
Small-date-time stores dates from 1st January 1753 to
31st December 9999.
Date-time store date from 1st January 19000 to 6th June
2079.
7. Currency
Data type utilized in financial calculations.
It contains currency symbols and numeric values.
The data type is utilized for data which holds
monetary values (Allert, 2009).
The data represent negative and positive amounts of
money.
Four decimal places are allowed in this data type.
Used in Forex bureau, banks, and financial
institutions.
8. Binary
Data types with hexadecimal numbers.
Data unit take 2 states 0 and +1.
It allows for storage of some binary strings (Allert,
2009).
Data is stored using image, bit, varbinary and binary.
Most of the store data is raw-byte.
Binary data type is used in storing IP address,
information in videos and in translations.
Conclusion:
Data types are data classifications that objects
and variables holds in programming.
Various data types exists in database management.
They include, integer, Boolean, character, floating-
point number, and alpha numeric string.
Each type serves a particular function.
Understanding different types of data is vital to
database success.
It further ensures effective software development.
References:
Gilmore, W. J. (2010). Beginning PHP and MySQL:
From novice to professional. New York: Apress.
Allert, J. (2009). Programming with Visual C++:
Concepts and projects. Boston: Course Technology
Cengage Learning.
Sutherland, S. (2002). The Verilog PLI handbook: A
user's guide and comprehensive reference on the
Verilog Programming Language Interface. Norwell,
Mass. [u.a.: Kluwer Academic Publ.

You might also like