Create and Relate Tables

 


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 for Foreign Key. 


This was the transaction table I made which had the following content: trans_ID, trans_Description, trans_ID and trans_Cost 






This is where I had to make the Customer ID a Foreign key






This is how it looks like as a result of me making the Trans_ID the Primary Key and the Customer ID the Foreign Key






These are some customer records I made for some camera equipment for Steven Spielberg and Jeff Streeves







This was a structured tab for the Transactions of products

This was a description I wrote for both customers






This was a structure tab for the Customers of the products


Comments

Post a Comment

Popular posts from this blog

Installing Wordpress

Image
  Lab 04  In this lab,  the lecturer introduced us to WordPress, MAMP and Laragon. For this lab, we went about installing WordPress, MAMP or Laragon onto our computers. This installation was ideal for the development phase of a WordPress blog.  WordPress is a free open-source content management system that allows its users to host and create websites of their own and can be downloaded from the link www.wordpress.org .  The lecturer told us to not confuse the .org site with the .com site.  WordPress.com is a hosted version of the open-source package where you can start a blog in seconds without any technical knowledge. This is generally used for bloggers.  The first step was to download the WordPress program from WordPress.org link and when it was downloaded, we unzipped the zip file of the WordPress program and got all the content that makes up WordPress.  The second step was moving the file to our MAMP htdocs folder.   The third step wa...
Read more

Introduction to PHPMyAdmin

Image
  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...
Read more