yes, you can install Power CMS locally.
The database is created when you run the Power CMS install script. The install script will prompt for the MySQL Server name, username and password and the name of the database to use, if you specify a database that already exists, the tables will be added to that database, if you specify a new database name a new database will be created.