Home  Fees/Services  Access Examples  Tutorials  Access Downloads  Articles  Search  Contact  Privacy  Links
Non-Normalized Tables
 






Link Database Tables
0th Normal Form (0nf)
First Normal Form
Second Normal Form
3rd Normal Form
Table Design Summary
Table Design Tutorial
Access Join Tables

Table Level Events

Article:
Repair Corrupted Table


Database Table 0th Normal Form (Spreadsheet Design)

Definition Examples and Recommendations

Zero Normal Form Definition

0th normal form is the classic spreadsheet layout for a database table. Characteristic of a spreadsheet layout are:



Are you just starting out on your quest for a small business database? Need some advice or someone to bounce ideas off of? We are happy to chat with you to discuss options to your situation.

Did you know that most template databases often do not do exactly what you need done? We can create a custom template that fits your needs exactly.


  • Repeating groups of fields

  • Positional dependence of data

  • Non-Atomic data


Example

The following table is in spreadsheet design:

Project_Name
Project_Location
Milestone_1
Milestone_2
Employee_Names     (example data in a single cell would be "Jane Doe,
                                John Doe, Billy Bob"
Emp_Hire_Date
Sales_2001
Sales_2002

Problems With Data Stored in Spreadsheet Layout

  • Data duplication

  • Single fields contain multiple data values (Employee_Names), therefore they are non-atomic

  • Queries would require constant update as because of positional dependence of data (sales_2001, etc.)

  • Tables/forms/queries/reports require redesign when a additional milestones or sales years are needed

How to Fix The Problems

All repeating groups should be split out into a separate subordinate table with the column 'data' defined in a table field.  Example for the Project_Sales table would be a table with the following fields:

Project_Name
Sales
Year

To solve the problem with multiple employees listed in one field create a subordinate table like:

Project_Name
Employee_Name










A Blue Claw Database Design Article:

Repair Corrupted Access Table
 







Blue Claw Database Design Downloadable Tutorial:
DoCmd.OpenForm & OpenArgs VBA Example.  







A Blue Claw Software Design Template:

Real Estate Marketing Campaign System
 











Microsoft Office:
MS Access 2000 Through 2016 and Office 365 & Sharepoint


Contact Information

Copyright 2000-2017 Blue Claw Database Design

Microsoft Access 2007, Access 2010, MS Access 2013