Intro to mySQL

Overview
- In the SQL projects of CS377, you are to express a number of queries using the mySQL database system.
  You can access the MySQL system using 2 different methods:

The Java GUI mySQL application

I have provided an easy way for you to access the MySQL server running on holland.mathcs.emory.edu
Run the following Java application on any Linux computer in the MathCS lab
(Or if you are logged in remotely, use lab0z.mathcs.emory.edu - with X window forwarding turned on !):
you can specify an optional size for the characters used in the application.
The available SIZE parameters are:
The default size is m (medium).
You will see the following window:
Enter spjDB into the Database field and click SELECT.
If you see a success message, you can enter the query into the top window and click EXECUTE to execute the SQL command (on the spjDB database).
Let me know if you have problem connecting to the database with this application.

supplier(snum, sname, status, city)
- snum = supplier number (key)
- sname = supplier name
- status = supplier status (how good he/she is)
- city = location of the supplier
This relation contains information on the suppliers
part(pnum, pname, color, weight, city)
- pnum = part number (key)
- pname = part name
- color = color of the part
- weight = weight of the part
- city = city where the part is made
This relation contains information on the parts used in the projects.
proj(jnum, jname, city)
- jnum = project number (key)
- jname = project name
- city = city where the project takes place
This relation contains information on the projects
spj(snum, pnum, jnum, qty):
- snum = supplier number (foreign key)
- pnum = part number (foreign key)
- jnum = project number (foreign key)
- qty = quantity
The meaning of a tuple in the spj relation is: supplier `snum' supplies the part `pnum' to the project `jnum'.

Summary:

The SPJ database keep track on projects, suppliers used to supply to the projects, parts used in the projects and shipment of parts.
We maintain information the projects in project, information on the suppliers in supplier and information on parts that we need in part.

The spj relation tells us which supplier is shipping which part to which project.

The key of each relation is as follows:

Notice that (snum, pnum, jnum) is not a key in the spj relation.

That means that a supplier can have multiple shipments of the same part to the same project (the quantity will be different :)).

For example, the spjDB contains these tuplese:

       select * from supplier
       
       select * from part
       
       select * from proj
       
       select * from spj

new