Selecting the options in this section of the dialog produces the following results: Under Options, set up the initial table characteristics. You can change the size of the table later, if necessary. Under Size, specify the initial number of columns and rows for the new table. This might come in handy when using the Navigator to quickly jump to a table. Under Name, you can enter a different name than the OOo-generated default for the table. Here you can specify the properties for the new table.
In the process, we will be explaining how a database works.Inserting a new table using the Insert Table dialog box. To explain how to use a database, we will create one for automobile expenses. Relationships are defined in terms of unions and intersections of the subsets (tables). The fields of a database are the elements. If you are acquainted with mathematical sets, a relational database can easily be explained in terms of sets: elements, subsets, unions, and intersections. The relationship between the names and social security number is one-to-one: only one social security number for each name. One of the fields contains the names of the employees while others contain the social security numbers, and other personal data. Most if not all the relationships in such a database are one-to-many relationships.Ĭonsider an employment database for the same library. This is what is known as a one-to-many relationship: one author and more than one book.
The library may contain more than one book by the same author. There is an obvious relationship between the authors and the books they have written. It will contain a field for the names of the authors and another field for the names of the books. This makes it fairly easy to create a database in which the fields of the database have relationships with each other.įor example: Consider a database for a library. Windows' version of JRE can not be used, while there are other versions that can.īase creates relational databases. In Apache OpenOffice, use Tools → Options → OpenOffice → Java to register Java. If you do not have it on your computer, you can download it from and install it following the instructions on the site. The database in Apache OpenOffice requires Java Runtime Environment (JRE).
0 kommentar(er)
