Database Concepts Chapter 9 Review

Study Notes

Database Basics

A database is a collection of related data.
RDBMS (Relational Database Management System) organizes data into tables, ensuring structured data storage.

Data Organization

Dividing data into tables minimizes unnecessary data duplication, also known as data redundancy.
A database schema describes the organization's data structure and aims to group information efficiently with minimal redundancy.
Each table should have relationships with at least one other table; isolated tables do not belong in a well-structured database.

Table Structure

A column in a table, also called a field, is used to store specific types of data.
Combining multiple pieces of data in a single field can hinder sorting and searching capabilities.

Naming Conventions

Field names should be unique, concise, descriptive, and avoid special characters.

Data Types

Common data types include:
- AutoNumber
- Text
- Number
- Date/Time
- Currency
- Memo
- Yes/No
- Hyperlink
- Attachment
- Lookup

Field Properties

The size of a field defines the character count or type of number it can store:
- "Single" is for decimal numbers.
- "Long Integer" is for whole numbers.

Field Formatting

Field formatting determines how data is displayed:
- Options include Fixed, Percent, Standard, Long, Medium, Short.
Text fields typically do not have a specific format.

Example Field Types

Retail Price: Currency
Order Date: Date/Time
First Name: Text
Product Description: Memo
E-Mail Address: Hyperlink
Record ID: AutoNumber
Delivery Time: Date/Time
Peanut Allergy: Yes/No
Quantity: Number

Primary Key Setup

To set a primary key:
- Click in the primary key field, then navigate to Design > Primary Key.
- The Required option ensures each record has a primary key entry.
- Multiple keys can be established by selecting gray boxes next to fields.

Forms

A form is essential for data entry and retrieving records from a table.
Different types of forms include simple, split, and multiple items forms.

Form Formatting

Logos can enhance form professionalism.
Formatting options for forms are bold, font size adjustments, and predefined formats.

Data Entry Efficiency

Forms must be in Form view to add new records and display existing ones effectively.
Record controls at the bottom help navigate through specific records or create new entries.
Forms streamline data entry by displaying one record at a time, reducing errors.

Description

Test your knowledge on key database concepts with this Chapter 9 review quiz. Each flashcard focuses on important definitions and descriptions of core database principles, including RDBMS and data redundancy. Perfect for reinforcing your understanding of database organization.