In the process, we will be explaining how a database works. 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. Then click on Forms > Use Wizard to Create Form to open the window below. If you are acquainted with mathematical sets, a relational database can easily be explained in terms of sets: elements, subsets, unions, and intersections. Click Finish to open both the primary Base window and the software database. The relationship between the names and social security number is one-to-one: only one social security number for each name. primary key field, A field in a database that contains unique data for. One of the fields contains the names of the employees while others contain the social security numbers, and other personal data. In OpenOffice Impress, the feature that assists in the creation of new presentations. This is unlikely to be an issue in the majority of cases, since OpenOffice Calc is designed to identify an entry typed as a date in a cell and automatically. 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. Click here to Download: odb04a-Employees.odb. Download file (s) to accompany Video 4. Instead of importing the data into a table that is already created, this time we look at two ways to create a LibreOffice Base table using a LibreOffice Calc file. There is an obvious relationship between the authors and the books they have written. Video 4 - Create a Table Using a Calc File. 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |