Database Methodology

 

The structure of the SCGV relational database is informed by editorial choices. A relational database is a database made up of multiple datasets organized into tables. The tables have defined relationships with one another, making it possible to ask the database for information across several tables. The relational database management system (RDBMS) for this database is Libre Office Base and it is queryable using Structured Query Language (SQL). SCGV contains three types of information about the cases, organized into tables:

The Legal Cases table, Fornication table, and Bastardy table contain information about the criminal cases themselves.

The Archives table, Call Numbers table, and Documents table contain information about the documents where the cases can be found.

The People table and the Relationships table contain information about the people involved in cases.

schema.png

Database Schema