1 / 7

Understanding Data Types: Boolean, Alphanumeric, Real, Integer, and Date Formats

In the digital age, understanding various data types is crucial. Boolean data can only hold true or false values, like a light switch being on or off. Alphanumeric data includes letters, numbers, and symbols, used in strings for diverse applications, like storing telephone numbers. Real numbers can have decimals, while integers are whole numbers. Additionally, dates can be formatted differently across regions, with notable examples from the UK and US. We'll also discuss other types, including currency and images, that enhance data storage and retrieval in databases.

michon
Télécharger la présentation

Understanding Data Types: Boolean, Alphanumeric, Real, Integer, and Date Formats

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Logical or Boolean • Data stored in Booleanform can only be oneof two available values. • Think of a light switch – it’s on or off. • Examples include: YES TRUE 1 M FALSE 0 F NO

  2. Alphanumeric • Alphanumeric data is any combination of letters, numbersand symbols (@#¬|\/>< etc.) • This data type is also known as a string or text. • Examples: I like fish £4987 is a lot to pay for a badger DL61 ABC @*!#

  3. Alphanumeric Continued… • Alphanumeric or text/string is used to hold telephone numbers. • In a computer, telephone numbers are stored as text. • This is because the telephone number contains a leading zero and spaces.

  4. Real • A real number is one which has decimalplaces. • Examples: 3.14175 18.01 12.4

  5. Integer • Integer numbers are whole numbers, no bits, no decimal places. • Examples: 5 -54 999999

  6. Date • Dates can be stored in many different forms. • In the UK we write the date in the form DD/MM/YYYY e.g. 31/12/2014. • In the US, they use the form MM/DD/YYYYe.g. 12/31/2014. • Examples: 15/08/1999 2009/11/30 12/31/1999

  7. Other Data Types • Currency – Software will automatically add £ or $ to data and include decimal places. E.g. £22.99. • Image – Some databases will allow an image to be stored, for example a photo of a criminal and their fingerprints on a crime database.

More Related