databse

connect to master as a user with create database permissions. And then run a Create Database command basically.

User's roles, permissions, lot's to set up.

A good start is to write the SQl to craete a usable database, first. Once that's OK it's just a question of firing it the DBMS.

I'd look at doing it in bits, and some sort of logging of errors. There's a lot that can go wrong.