Database schema

A full database schema is a physical schema and a logical schema. The physical schema displays the hardware, servers, and connections that need to be set up to install the database.

Logical schema

The structure of the data itself:

• optimise fields versus items
• normalise - reduce redundancy among data tables
• primary keys per table versus secondary keys