Help:COAP-3180/hw3: Difference between revisions

Revision as of 16:52, 11 November 2007

Continue the activity started in the classroom, i.e.

Define a SQL table with an SQL file
Create the table in a MySQL database by importing the file with the SQL instructions

Purpose: Become familiar with SQL table definitions and MySQL database management

Note: You will have to turn in a first version of this homework next Monday (week 4). We then will discuss what you should add to this mini-project.

Think about a simple web application that needs a database table, i.e. something that is quite similar to homework 1.
With a simple text editor create a *.sql file and that includes the necessary SQL commands
Import this file into a mySQL database
Repair errors until it works

Pick one of these. Some articles are presented as multiple pages (!)

@@ Line 18: / Line 18: @@
 # Import this file into a mySQL database
 # Repair errors until it works
+== Reading and links ==
+=== Reading ===
+Pick one of these. Some articles are presented as multiple pages (!)
+* [http://www.intermedia.net/support/sql/sqltut.asp Introduction to Structured Query Language: Version 4.11] by James Hoffman.
+* [http://www.webdevelopersjournal.com/articles/sql.html Getting Started With SQL] by Ted Brockwood
+* [http://sqlcourse.com/intro.html What is SQL?]
+* [http://www.databasejournal.com/sqletc/article.php/26861_1428721_1 Introduction to Databases for the Web: Pt. 1] by Selena Sol (most complete article)
+=== Reference ===
+* [[SQL]] (follow up the links)
+* [http://dev.mysql.com/doc/refman/5.1/en/index.html MySQL 5 reference manual]. See in particular
+** [http://dev.mysql.com/doc/refman/5.1/en/tutorial.html tutorial]
+** [http://dev.mysql.com/doc/refman/5.1/en/data-types.html data types]