Sesterterpenoids, a subset of the terpene family, exhibit notable biological activities. These natural compounds are present in a variety of organisms such as plants, fungi, bacteria, insects and marine life. The therapeutic potential and structural diversity of sesterterpenoids have attracted considerable interest in pharmacological and chemical research. This study illustrates the development of a database to structure and manage data on these compounds. The design process involves the collection of user requirements, creation of a conceptual model with and Entity-Relationship Diagram (ERD), development of a logical model, and implementation in Microsoft SQL Server 2022. Data collection began with an extensive literature review and organization in an Excel spreadsheet. The resulting database improves data acquisition, organization, and accessibility. Future work will include building a website to facilitate data entry, editing, reading and extraction, and automation of data updates via external web services.
Read full abstract