Info Tech Guide

Data- Every organization has some information needs. A library keeps a list of members, books, due dates, and fines. A company needs to save information about employees, departments, and salaries. These pieces of information are called data.

Database- An organized collection of information.

Database Management Systems- A program that stores, retrieves, and modifies data in the database on request. There are four main types of databases: hierarchical, network, relational, and more recently object relational.

Microsoft Access Database- A collection of data and objects, such as tables, queries, or forms, related to a particular topic or purpose.

Relationship- An association established between common fields (columns) in two tables. A relationship can be one-to-one, one-to-many, or many-to-many.) between your tables.

Relational Database. A type of database that stores information in tables. Uses matching values from two tables to relate data in one table to data in the other table. In a relational database, you typically store a specific type of data just once. A relational database uses relations or two-dimensional tables to store information.

Data Models- Models are a cornerstone of design. Engineers build a model of a car to work out any details before putting it into production. In the same manner, system designers develop models to explore ideas and improve the understanding of the database design.

Models help communicate the concepts in people’s minds. They can be used to do the following:

The objective is to produce a model that fits a multitude of these uses, can be understood by an end user, and contains sufficient detail for a developer to build a database system.