The original database was one monolithic table. This posed several problems including:

The team has improved the existing database structure from a single table to a multi-table database

Updated structure advantages:

1. Avoids Data Duplication - By separating the acceptor and donor data into their respective tables, you avoid repeating the same data in the SaltBridge table.

2. Data Integrity - if an acceptor's details change, you only need to update it in one place, and all related salt bridges will automatically reflect the change.

3. Flexibility - If you need to add more attributes to the acceptor or donor in the future, you can do so without affecting the SaltBridge table.

4. Efficient Queries - For operations that only concern donors or acceptors, you can query the respective table directly without having to deal with the additional data from the SaltBridge table.

The team has successfully added data to the database by updating the python script included with this project

Table Structures