Question

1. What is the file extension for databases created using OpenOffice Base?


2.List any three file formats that can be managed using OpenOffice Base?


3. How many types of relationships can be created in Base? Explain each

of the them.


4. What do you mean by Sorting? In how many ways it can be done?


5. Explain Referential Integrity with the help of an example
​

Answer 1

Answer:

1ans:- ODB is the file extension for databases created using OpenOffice Base.

2ans:- three file formats that can be managed using OpenOffice Base.

3ans:- There are three types of relationships.

1) One-to-one: One to one is implemented using single table by establishing relationship between same type of columns in a table.

2) One-to-many: Implemented using two tables with primary key and foreign key relationships.

3) Many-to-many: Implemented using a junction table. The keys from both the tables form composite primary key of the junction table.

4ans:-Data sorting is any process that involves arranging the data into some meaningful order to make it easier to understand, analyze or visualize. When working with research data, sorting is a common method used for visualizing data in a form that makes it easier to comprehend the story the data is telling.

5ans:- Referential integrity refers to the accuracy and consistency of data within a relationship. In relationships, data is linked between two or more tables. ... So, referential integrity requires that, whenever a foreign key value is used it must reference a valid, existing primary key in the parent table.

tum mujhe brainliest mark nahi kar rahe ho please mark karo...