You can think of a database as a collection spreadsheet files. Spreadsheets have Columns and Rows. Most Spreadsheets have columns with simular data values like Address, State,
City and so on. A table in a Databases has fields corresponding with spreadsheet columns and records coresponding to spreadsheet rows. I have created two sets of libraries in both perl and PHP that are automatically generate forms to insert, update, delete and search records in the database. All these fields were written in PHP so they can be easily added to WordPress or standard HTML pages.