Create a new database. The purpose of the database is to identify a service member and the member's posting.

Within the database, create a table called member with the following schema.

$+-----------+-------------+------+-----+---------+-------+$

$|$ Field $|$ Type $|$ Null $|$ Key $|$ Default $|$ Extra $|$

$+-----------+-------------+------+-----+---------+-------+$

$|$ SN $|$ char$(10)|$ NO $|$ PRI $|||$

$|$ surname $|$ varchar$(30)|$ YES $|$ MUL $|$ NULL $||$

$|$ givenname $|$ varchar$(20)|$ YES $||$ NULL $||$

$|$ rank $|$ char$(5)|$ YES $||$ NULL $||$

$+-----------+-------------+------+-----+---------+-------+$

Within the database, create a table called post with the following schema.

$+-------+----------+------+-----+---------+-------+$

$|$ Field $|$ Type $|$ Null $|$ Key $|$ Default $|$ Extra $|$

$+-------+----------+------+-----+---------+-------+$

$|$ SN $|$ char$(10)|$ NO $|$ PRI $|||$

$|$ unit $|$ char$(30)|$ YES $||$ NULL $||$

$+-------+----------+------+-----+---------+-------+$

Install the following script on the web server.