CCNC/CCNC Module 5/The database application

From WikiEducator
Jump to: navigation, search

The OpenOffice 2.0 Database Application

The focus of this section is threefold; first, you will develop an understanding of the a database, and how it can be used to gather, store and report on data that is within a specified subject domain. This first tutorial will also explore the basics of how to design a database for data integrity and for longevity of usefulness. When we speak of data integrity we mean the accuracy and reduced duplication required to keep data healthy. When we speak of longevity of usefulness we mean the database design has considered many of the future data needs. These two attributes may seem lofty goals, with thought and the application of database theory a strong and integral database can be built that will serve many needs for a good duration of time. Second, you will play with connecting to an existing database and how to create and save a new database. This second tutorial will also explore methods of how to get help when building, using and maintaining a database. Third, you will explore the application settings available within OpenOffice Base. These settings help you understand and manage the database application environment.

Database Concepts

Icon objectives.jpg

Outcomes

Upon completion of this tutorial the learner will:
  • Describe a database and how it is used
  • Discuss how a database is organized in terms of tables, records and fields
  • Differentiate an entity from an attribute
  • Describe the different data types and how they are used
  • Normalize a database to second normal form


Database Design

Icon objectives.jpg

Outcomes

Upon completion of this tutorial the learner will:
  • Normalize a database to third normal form
  • Identify a key field; in particular, a primary key
  • Describe an index, its purpose, and how it is implemented
  • Discuss the purpose of relating tables in a database
  • Set rules to ensure relationships between tables are valid


First Steps with Databases

Icon objectives.jpg

Outcomes

In this tutorial we will:
  • Open (and close) a database application
  • Open, log onto an existing database
  • Create a new database
  • Save a database to a location on a drive
  • Use available Help functions
  • Close a database


Adjusting the application settings

Icon objectives.jpg

Outcomes

In this tutorial we will:
  • Change between view modes in a table, form, report
  • Display, hide built-in toolbars
  • Others (Oo 2.0 TBD)