Help:COAP-3180/week8

Week 8 - COAP 3180

Term project presentation

(Monday)

• See Help:COAP-3180/term project term project page

Summary

(Monday)

• Final lecture, reminder of the most important subjects addressed etc.

Final exam

Main subjects

• web application architecture (high level principles)

• SQL:

   * SELECT
         o SELECT ... WHERE, INSERT ... ORDER
         o Joins (select from two tables) 
   * CREATE
         o Data types: Integer, Float, VarChar, text
         o DEFAULT, NOT NULL, Auto increment
         o Keys
         o Primary keys 
         o Foreign keys 
   * INSERT (both forms(
   * UPDATE / DELETE
   * DROP 

• Database design:
  • Simple 2-3 table architectures
  • 1 to N and N to N relations between tables

• XML