<%dim crumb crumb="0th Normal Form (Spreadsheet Layout)" crumb1="Non-Normalized Tables" crumb2="De-normalized Table Design" %> Database Table Design: 0th Normal Form (0NF)
Home  Fees/Services  Access Examples  Tutorials  Access Downloads  Articles  Search  Forums  Forums  Blockchain Tech  Contact  Privacy  Links
<% response.write crumb1 %>
Home > Access Tutorials > Access Table Design Tutorial > <%response.write crumb%>
 






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:

  • 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

Business Class Deals

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




























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


Contact Information

<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>

Microsoft Access 2007, Access 2010, MS Access 2013