Schema (Database Schema)

A database schema defines how data is organised within a relational database. The schema includes table names, fields, data types and the relationships between these entities. Schemas and entity relationship diagrams act as valuable documentation and should be used by testing professionals to ensure data can be used by stakeholders, duplication is not introduced and the systems that utilise the database are as performant as possible.