Lab Two - SQL Start up part 2

  

Create and Relate Tables 

 

Step 1 

This lab we're learning how to create and relate tables so to start off straight off the bat I need to create a single table, editorial video the lecturer uses movie directors and movies as his criteria for this list or management system. I have opted to put my personal touch on it and have game makers and games from my list almost approved that I've done the work myself. 

So I created my first list with titles of basic information at the game designer would have as seen in the image below. all the while keeping very sure that I have a prime key.(primary key) 

 



 

Step 2 

next was the list that would be displaying information for the games themselves, including their creator this is the shared ID that these two lists have.(what will be linking them together) 

Once again ensure that game ID in this list is set to your prime key and you might as well but then the Maker_ID as a foreign tag. 




 

Step 3 

You then want to index one of the ID's so that when you come to the relationship tag you have something to put in. 




 

 

Step 4 

Then you can start adding in information as you please which can be found in the browse tab as you can see below using methods I learned in this lab I was capable of putting four different games from two different creators that can be categorized by these lists and these rules. 




Comments

Post a Comment

Popular posts from this blog

Adobe Max 2021 from a UX and UI perspective

Image
  Adobe Max 2021 from a UX and UI perspective   Joseph Dolan   B00130057     Intro   This blog post is going to consist of my experience and my opinion on the Adobe Max 2021 Create together stream. Straight off the bat I'd like to say overall, I'm relatively excited and disappointed on this conference. they show off a lot of new and interesting collaborative tools and AI tools that will speed up peoples work process in a very interesting and intuitive way. but Adobe has still failed to realize that the biggest problem with their software's its self. Adobe software's notorious for crashing and running badly. Apartment example that I use is Adobe premiere pro and after effects these two programs constantly crash when working between one another I work on a high-end device and run into frequent problems.  so,  it is a little disappointing that they have not addressed their optimization as it's what I believe to be there  Achilles's  heel. ...
Read more

Lab 3 – SQL EXERCISES

Image
  Lab Upload Three   Joseph Dolan   B00130057     Lab 3 – SQL EXERCISES    For lab 3 we learned how to  complete  a set of  exercises to develop our understanding of SQL.     Create a database   Create tables using SQL statements   Insert data into the table using SQL   Perform Simple SQL queries   Update tables    Drop the table         Note- Part way through this lab I Ran into some problems but used other  materials  to finish blog.     Set up   To start  i  simply launched  Laragan . It's important to make sure that  your  Apache server starts correctly and you're using the correct version of  MYSQL.  And then boot up PHP my admin by logging in.     Setting up a  database   Click on the SQL table again and create database, uses to create a database and name it. use the named database to exec...
Read more