Oops! Sorry my bad. It is a skip on my part. I forgot to run $ php artisan cache:clear before php artisan dreamfactory:setup. Now everything runs fine.
To summarize:
Stop your webserver/apache to perform below steps.
The dbms(in which dreamfactory system database will reside) must be running from here onwards.
First you need to create a database user and a database in the dbms to be used as dreamfactory system database.
Second, to change default database for dreamfactory you need to edit {bitnami-install}/apps/dreamfactory/htdocs/.env file.
Third, after changing the default database in {bitnami-install}/apps/dreamfactory/htdocs/.env, in your shell navigate to the dreamfactory root folder ( {bitnami-install}/apps/dreamfactory/htdocs/ ) and run below commands in order:
$ php artisan config:clear
$ php artisan cache:clear
$ php artisan dreamfactory:setup
//Answer the on screen prompts
Restart Apache
NOTE: No need to create any tables/relations manually. They will be created automatically when you run $ php artisan dreamfactory:setup . This cmd will ask you to create first admin user for dreamfactory instance.
Thanks.