We have been introduced to a software tool written in PHP called, phpMyAdmin which supports MySQL for managing databases through a web browser.
We were given a phpMyAdmin username and password to login.
We were shown by our programmer lecturer how to create tables in phpMyAdmin to create the tables we drafted in our Entity Relationship Diagram and put them on the database.
Below is a screenshot of the template for creating a new table on phpMyadmin. The table includes fields for the
- Table Name (i.e. USERS, MEMBERS)
- Field Name (i.e. member_id, member_username, member_password)
- Data type (i.e. INT, VARCHAR, TEXT, DATE)
- Length/Values (how long the data can be)
- Index (this is set to unique when using an ID data field)
- Auto Increment (allows a unique number to be generated when a new record is inserted into a table)
Below is an example of a MEMBERS table, with a unique members_id that is auto incremented.
phpmyadmin.net, 2015. Bringing MySQL to the web. Available from: http://www.phpmyadmin.net/home_page/index.php [Accessed: 24/02/2015]