Content Management Systems Blog

  Lab 02 For this lab that we did, we were asked to create a database, and two tables and create a relationship between them two tables. We had to follow a video that our lecturer had linked to us to complete this lab. It was a recap of a previous lecture from last year of all the steps required to complete this lab. In order to use PHPMyAdmin we had to either download MAMP for Mac users or Laragon for PC users and then were able to run PHPMyAdmin. Essentially when we download MAMP or Laragon we could turn our Computers into databases. This lab was a bit more time-consuming this was harder than the last one but I did manage to get the hang of it in the end. The thing I found most difficult was trying to relate the two tables which I did manage in the end. The database we had to create was called SHOP.  This is a diagram which indicates relationships between two tables. This table indicates the fields and the relationships to implement. PK stands for Primary Key and FK stands f...

  Lab 01   So this is the first lab of the semester and we learned about the introduction of the PHPMyAdmin. The thing we learned about PHPMyAdmin is that it is an open-source tool written in PHP intended to handle the administration of MySQL over the World Wide Web.  The things that PHPMyAdmin will allow you to do is:  Create databases  Create and drop tables  Enter Data  Create and manage database users  Perform queries  Manage backups etc  The things we did in this lab were simple, our lecturer was just taking us through the basics of the program and operating it. We got an opportunity to get familiar with the interface and how to create a simple database. This is a database I made for Students  There were some tasks that we had to do. We had to create a table to store student data. We included data such as Student Number, Student Name and Course ID. We also made a table for Courses such as Course ID, Course Name and Commencement...