WordPress has a great Database structure to handle almost CMS functionality, However some plugin needs a specific database table to interact with wordpress functionality.  

Here is a simple plugin which create new table in database when admin activate the plugin.

Here is a detail reference of function dbDelta

Note : Avoid new custom table if you can handle using default wordpress tables. i.e. options, post and post meta 

Find More Article for Plugin development Here