Database Design

After we laid out our database schemas, which are the logical structure of the database would be represented. This included defining how the data would be organized, stored, and accessed using tables, fields, relationships, and constraints.

In addition to their importance in defining the database, these schemas play a crucial role in the efficiency and convenience of the front-end's access and modification of data. A well-designed schema can help to minimize errors and inconsistencies that can arise when working with complex data sets. Furthermore, a well-designed schema can greatly enhance system performance and scalability, while also reducing redundant space.

Here is the complete database schema for our project: