M2-Unit 3.Database Management System Using LibreOffice Base-Chapter 2.pptx

• newEditor
• IT
• Primary Education
• Age 6,8

Text

identify the icon

A. Multiple choice questions

1. Which of the following is NOT a type of text data type?

(a) Memo

(b) Varchar

(c) Float

(d) Char

2. A currency data type can only store monetary data that is

in dollars.

(a) True

(b) False

(c) Neither a nor b

(d) Both a and b

3. Which of the following data can a date data type store?

(a) Date

(b) Time

(c) Both date and time

(d) Neither date nor time

4. Which of the following is true about LibreOffice Base?

(a) It is a spreadsheet software

(b) It is free and open source software

(c) It can store only character data

(d) It is a licensed software.

LO

Learning Outcomes

Simultaneous Rally Table:

Setting the Primary Key

• To make a particular field as the primary key, place the mouse pointer before the field name and right click.

• A pop up menu appears. Select the Primary Key option from pop up menu

• A key icon appears before the field name indicating that it is a primary key.

Saving a Table

• To save the table click on the save button or follow menu option File >Save As.

• A Save As dialog box is displayed. Enter the name of table and click on OK button.

Entering Data in a Table

• To enter data in the table, double click on the created table Events icon in the Tables Object Area on the database screen. Alternatively, we can open the table by right clicking on the desired table and then selecting the Open option from the dropdown menu.

• The datasheet view of the table will appear. It displays the field names in the top row. These fields are displayed in the same order as they were added while creating the table.

• The cursor will be blinking in the second row. Start typing the data value for each field.Use Tab to move to next field.

• Once all the data values are entered for a single record, the cursor moves to the next record. This process is called as data entry. Enter 4-5 records.

ACTIVITY

Extended task

There are 5 houses in Ruhi’s school – Ganga, Yamuna, Satluj,

Beas and Narmada. Once student can participate from each

house in a particular event. Create a table Participants with

following fields.

1. Event_Id

2. Event Name

3. Ganga

4. Yamuna

5. Satluj

6. Beas

7. Narmada

Also add minimum five records in the table.