Help:COAP-3180/hw3

The educational technology and digital learning wiki
Revision as of 16:19, 11 November 2007 by Daniel K. Schneider (talk | contribs) (New page: == Homework 3 - COAP 3180 Fall 2 2007 == ''' COAP 3180 Course Page == Summary == Continue the activity started in the classroom, i.e. * Define a SQL table with an SQL...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Homework 3 - COAP 3180 Fall 2 2007

COAP 3180 Course Page

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

  1. Think about a simple web application that needs a database table, i.e. something that is quite similar to homework 1.
  2. With a simple text editor create a *.sql file and that includes the necessary SQL commands
  3. Import this file into a mySQL database
  4. Repair errors until it works
Retrieved from "https://edutechwiki.unige.ch/mediawiki/index.php?title=Help:COAP-3180/hw3&oldid=16119"