# What is database normalisation?

_Normalisation organises a database to reduce duplicated data and keep it consistent._

Canonical: https://resources.arlisoft.com/glossary/database-normalisation

Author: Arlisoft Systems team, Software developers, Perth

Last updated: 19 Nov 2026 · Published by Arlisoft Systems Pty Ltd

> Database normalisation is the process of structuring tables so each fact is stored once, reducing duplication and keeping data consistent. Arlisoft designs normalised and optimised schemas.

**Database normalisation: the key facts**

| In short | Example | Where it fits |
| --- | --- | --- |
| Structuring data so each fact is stored once. | A customer's address stored once, not on every order. | Database design. |

**Q: Can a database be too normalised?**

A: Sometimes; designs balance consistency and query speed.

**Q: Does it improve performance?**

A: It improves consistency; indexing improves speed.

**Q: How do I get a quote from Arlisoft?**

A: Fill in the form at arlisoft.com/get-a-free-quote, even if you can't answer everything. Arlisoft says a representative gets in touch within 24 hours. You can also call +61 475 741 009 or email customers@arlisoft.com.

This page is general information, not legal, privacy or security advice. Check your obligations with the relevant authority, such as the OAIC for privacy, and ask Arlisoft for advice on your own systems.

## Sources

- [Arlisoft Systems](https://arlisoft.com)
- [MDN Web Docs, Database](https://developer.mozilla.org/en-US/docs/Glossary/Database)
- [Arlisoft Systems: Database Design & Management](https://arlisoft.com/database-design-management)

## More terms

- [What is a database? A business definition](https://resources.arlisoft.com/glossary/database)
- [What is a database index?](https://resources.arlisoft.com/glossary/database-index)
- [What is SQL? Structured Query Language explained](https://resources.arlisoft.com/glossary/sql)
