Some great points about prototypes and Entity Relationship models / UML, but I'd like to add a point on "application databases".

I believe the data should be modelled as a database...

Some of my thoughts on this:

The table name should reflect a row in the table so should be book not books.

The primary key would be better as a number -...