Databases

You can create your database and tables directly through a script like PHP as bellow
<?php

// set your infomation.
$dbhost='localhost';
$dbusername='david';
$dbuserpass='mypassword';
$dbname='test';

// connect to the mysql database server.
$link_id = mysql_connect ($dbhost, $dbusername, $dbuserpass);
echo "success in database connection.";

// create the database.
$dbname=$dbusername."_".$dbname;
if (!mysql_query("CREATE DATABASE $dbname")) die(mysql_error());
echo "success in database creation.";

?> 

Find more details here >> http://www.htmlite.com/mysql005.php


As we embrace programming of databases, we should always first remind our selves on the logical design of the database that is, structuring the database basing on the requirements stipulated by the client.Normalization is done at this stage. Many database developers usually implement the physical database before sketching the structure. You can logically design the database by use of UML (Unified modelling language) especially Object Oriented systems or diagrammatically produce ERD(Entity Relationship Diagrams) or EER (Enhanced Entity Relationship diagrams).

Bellow is a question that requires both a logical and physical implementation 
Dr. Richard, runs an immunization clinic, it has Doctors and Nurses and treats patients from Monday to Friday. Using an EER diagram, design a Logical Database which records, the Patients Personal Details (Names, Sex, Age), Immunization Given (Name, Amount, Date, Time, Person Who Gave the Immunization), Appointment Details (Date, Time, Location), New Appointment details and provide an ability to record whether the Patient, has arrived, been seen, departed or did not come