271 MySql Inventory assignment

Write an SQL script to create all the tables from your perl catalog system. (Usually there were 3: the association table and the two tables that linked to it).

Write another script to add at least 3 rows of data that link together into each table.

Then, write a select statement that could be used to do the search that your perl catalog system provided. It needs a where clause and all three tables.

If you are able, also change your perl web script to use that search statement. The web site page user interface wont change, but inside it will read from the MySQL database instead of reading from the files

Copy the following to notepad to submit to moodle:

• select * from each table
• your select statement and its output
• if your web page was changed to use the database instead, write a note telling me to check it, along with the web address and your database password if I need it to run the lookup.
• If your webpage was changed to use the database instead, also upload the new perl script to moodle.

See these helpful page for instructions on creating and inserting data:

Create a table :

http://dev.mysql.com/doc/refman/4.1/en/creating-tables.html

http://www.tutorialspoint.com/mysql/mysql-create-tables.htm

Insert a row:

http://dev.mysql.com/doc/refman/5.6/en/insert.html

http://www.w3schools.com/sql/sql_insert.asp

select statement

people love sqlzoo: http://sqlzoo.net/wiki/SELECT_basics

http://www.w3schools.com/sql/sql_select.asp

http://dev.mysql.com/doc/refman/5.0/en/select.html