Help:COAP-3180/week8: Difference between revisions
Jump to navigation
Jump to search
m (Created page with '== Week 8 - COAP 3180 == === Term project presentation === (Monday) * See Help:COAP-3180/term project term project page === Summary === (Monday) * Fi…') |
(No difference)
|
Revision as of 01:02, 24 February 2010
Week 8 - COAP 3180
Term project presentation
(Monday)
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