First Normal Form
First Normal Form Definition
A summary of this list above is often stated as 'All fields in the database are atomic', meaning they are reduce to a single data value in each cell of the table.
The following table is in first normal form (1NF/1ST):
Problems With Data Stored in 1NF
Data duplication: within the same project the project manager name will be duplicated. If the manager is replaced then all records for that project will need to be updated (cascade update related records). The result is more space is used for each record and processing time is consumed checking updates and performing updates.
To add a project manager you should already have an employee in the project.
See our 2nd normal form table design discussion.
Copyright 2000-2016 Blue Claw Database Design
Microsoft Access 2007, Access 2010, MS Access 2013