Tutorial database using Base application

Tutorial database using Base application

Tutorial Base application database complete

Where we introduce this tutorial and its scope. We start by analyzing what a database is and describe its different components: Tables, relationships, primary and foreign keys, columns, column attributes, deletion attributes and relationship cardinalities and finally we provide a definition of database and Base database. We later comment on forms and reports and on modeling data and goals of proper design, after which we provide an overview of UML diagrams to use as a visual vocabulary. We then summarily review phases in database design and the importance of Normal Form. We also review First, Second and Third normal forms and how they aid in class extraction. After this we review the way that Base records attributes and the nature of the variables it uses, analyzing text variables, numeric variables, date and time variables and object variables and how choosing them properly will affect the performance of a Base application.

Databases are very useful programs that allow us to store information, organize it, retrieve it and even extract new information from it. OpenOffice.org offers a very powerful database system with Base. But because Base is a powerful and flexible application, you need to be able to make some informed decisions while working with it and this, in turn, requires some preparation.

This tutorial will try to help you better understand the options offered by Base while attempting to develop a functional application of a medium level of complexity. To achieve this, the first part of the tutorial will review some important concepts in the design of databases, that is, on how to organize the information that you need to collect. The later part of this tutorial will show you how to implement those decisions while developing an actual application with Base.