Question

B.Answer the following:
1. Define the term Table with respect to LibreOffice Base.
2. What do you mean by Field Types?
3. Explain the use of Primary key in a table.
4.What do you understand by the term Field Property?​

Answer 1

Answer: 1) LibreOffice uses the terms “Data Source” and “Database” to refer to the same thing, which could be a database such as MySQL or dBase or a spreadsheet or text document holding data. Each table of the database is a group of fields. When creating a table, you also determine the characteristics of each field within it .

2) Text fields. Text fields are for free text data about the object you are cataloguing

Pick List fields (authority controlled fields) Pick List fields enable you to create and use a standard set of terms.

Editing terms.

Deleting terms.

Date fields.

Number fields.

Global Term fields.

Public and Private fields.

3) A primary key is a special relational database table column (or combination of columns) designated to uniquely identify all table records

4) The properties of a field describe the characteristics and behavior of data added to that field. A field's data type is the most important property because it determines what kind of data the field can store.

Explanation: please mark me as a brainliest

Answer 2

Answer:

1. LibreOffice uses the terms “Data Source” and “Database” to refer to the same thing, which could be a database such as MySQL or dBase or a spreadsheet or text document holding data. Each table of the database is a group of fields.
2. The field type determines the type of data that a user can enter into the field (alphanumeric, numeric, date, and so on) or determines how the field functions in the database, for example, is an image displayed in the field when a user selects an image file of an allowed type, does the field link to another field in a ...
3. The PRIMARY KEY constraint uniquely identifies each record in a table. Primary keys must contain UNIQUE values, and cannot contain NULL values. A table can have only ONE primary key; and in the table, this primary key can consist of single or multiple columns (fields).
4. The properties of a field describe the characteristics and behavior of data added to that field. A field's data type is the most important property because it determines what kind of data the field can store.