Database schema

A relational database schema is the logical structure that defines the organization of data in a relational database, including:

• Tables (relations)
• Columns (attributes) and their data types
• Primary and foreign keys
• Constraints (e.g., NOT NULL, UNIQUE)

It serves as a blueprint for how data is stored and related.

Entity-Relation diagram

An Entity-Relationship diagram (i.e. ER diagram) is a visual representation of the data model that illustrates the database schema. Below is the ER diagram of the parsomics database.

You can also get this diagram in PDF by clicking the button below.