In this article, we will talk about Data types in Base Class 10 it 402 for learning outcome 2 of Unit 3 Database management system.
Topics Covered
Data types in LibreOffice Base Class 10 IT 402
Let’s begin Data types in Base Class 10 IT 402 with the introduction to data types in LibreOffice Base. As we have covered fundamentals of database tables in an earlier article. To read the article Database Concepts and Introduction to DBMS – Click here.
Your database tables can have different types of values or data. It defines which kind of data we are going to use in our tables. The nature of data to be entered for various fields are of different types.
For example:
| Field | Data Type |
| Names | Text |
| Marks | Number including decimals |
| Admission Date | Date |
| Class | Number without decimals |
| Photo | Binary Object |
The memory size of database tables are depends on the data types and values entered in the table.
There are five basic types of data we can insert into the table.
- Numbers – It stores numeric values having integers and fractional numbers.
- Text – It holds the textual data with the combination of numbers and digits and special characters.
- Date-Time – The date-time data type is used to save the dates into a database field.
- Binary – Binary types stores large types of data such as images, audio or video files.
- Other Variable – Other variable types can have data of other remaining objects.
In the next section of Data types in Base Class 10 IT 402 let’s talk about details about above numeric types.
Numbers
LibreOffice Base Provides following different types of data types:
| S.NO | Name | Data | Signed | Length |
| 1 | Tiny Integer | TINYINT | No | 3 |
| 2 | Small Integer | SMALLINT | Yes | 5 |
| 3 | Integer | INTEGER | Yes | 10 |
| 4 | Big Integer | BIGINT | Yes | 19 |
| 5 | Number | NUMERIC | Yes | 19 |
| 6 | Decimal | DECIMAL | Yes | 19 |
| 7 | Float | FLOAT | Yes | 17 |
| 8 | Real | REAL | Yes | 17 |
| 9 | Double | DOUBLE | Yes | 17 |
| 10 | Yes/No | BOOLEAN | No | 1 |
Text
LibreOffice Base provides following types of text data types:
| S.NO | Name | Data | Length |
| 1 | Text | VARCHAR | User Defined |
| 2 | Text (fix) | CHAR | Fixed Length |
| 3 | Memo | LONGVARCHAR | 64000 |
In the next section of Data types in Base Class 10 it 402 we will talk about binary data types.
Binary Types
The certain types of binary data types are as following:
- LONGVARBINARY: This type will store a specific image with array of bytes i.e. images, sound files etc. without validation.
- BINARY(fix)/Binary: This is also used to store data into binary form.
Date/Time
Sometimes you need to store dates like date of admission, date of joining, date of birth, date of event, date of transaction with a specific time or without time. The date/time data types is used to store such dates in LibreOffice base tables.
So in this section of Data types in Base Class 10 it 402 we will talk about three types of date/time data types supported by LibreOffice Base.
- DATE: It stores a date in common format like month, day and year i.e. 1/1/99. The date ranges are 1/1/99 to 1/1/9999
- TIME: It stores a particular time in hour, minute and seconds format. The seconds since 1/1/1970.
- TIMESTAMP: It stores the value with and time together in the table field.
Other Data Types
In these types of data type, you can store any serialized objects of java like connector or specific script through objects. It is mostly used for the coding purpose only.
So here we conclude our today’s session for Data types in Base Class 10 it 402. I hope you enjoyed this article. Do like, share and comment your opinion about this article.
Thank you for visit. Visit again.
Follow this link for more important questions on Datatypes in Base: