Help:COAP-3180/hw3
Jump to navigation
Jump to search
Homework 3 - COAP 3180 Fall 2 2007
Summary
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.
Homework tasks
- 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
Reading and links
Reading
Pick one of these. Some articles are presented as multiple pages (!)
- Introduction to Structured Query Language: Version 4.11 by James Hoffman.
- Getting Started With SQL by Ted Brockwood
- What is SQL?
- Introduction to Databases for the Web: Pt. 1 by Selena Sol (most complete article)
Reference
- SQL (follow up the links)
- MySQL 5 reference manual. See in particular