05 July 2009

🛢DBMS: First Normal Form (Definitions)

"Eliminate repeating groups, such that all records in all tables can be identified uniquely, by a primary key in each table. In other words, all fields other than the primary key must depend on the primary key." (Gavin Powell, "Beginning Database Design", 2006)

"A relation is in first normal form if it contains no repeating groups." (S. Sumathi & S. Esakkirajan, "Fundamentals of Relational Database Management Systems", 2007)

"One of the three normal forms that make up relational database guidelines, this rule states that a table should not have any repeating fields." (Robert D Schneider and Darril Gibson, "Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies", 2008)

"A table is in 1NF if it satisfies basic conditions to be a relational table." (Rod Stephens, "Beginning Database Design Solutions", 2008)

"A table is in first normal form (1NF) if and only if there are no repeating columns of data taken from the same domain and having the same meaning." (Toby J Teorey, ", Database Modeling and Design 4th Ed", 2010)

"In relational theory, the first of Dr. Codd’s constraints on a relational design: Every tuple may have only one value for an attribute in a relation." (David C Hay, "Data Model Patterns: A Metadata Map", 2010)

"The first stage in the normalization process. It describes a relation depicted in tabular format, with no repeating groups and with a primary key identified." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management" 9th Ed., 2011)

"An entity is in first normal form if and only if all underlying domains contain atomic values only." (Craig S Mullins, "Database Administration", 2012)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.