TT380 Databases within website design
This is fourth first package of all the modules aimed at generation of basic static web pages - including site specification, building with HTML and styling with CSS with simple connectivity.
Overview
Weekly study guides
- Week 1: The role of the database in web applications
- Week 2: Scalability, Security, Open Database Connectivity (ODBC) and choosing Hosting
- Week 3: Entity-relationship modelling, diagrams and E-R diagram transformations
- Week 4: Working with a Database Manager
- Week 5: The ColdFusion markup language for Server-side scripting
- Week 6: Server-side script and database queries part 1
- Week 7: Server-side script and database queries part 2
- Week 8: Advanced queries for multiple tables
- Week 9: Aggregate functions and transaction processing
- Week 10: Full text searches
- Weeks 11-12: EMA Project
Assignments
As with TT280, TT281 and TT282, each assignment consisted of 20 multiple choice questions covering the previous four study weeks. There were three assignments covering work from weeks 1-3, 4-6 and 7-9 respectively. The remaining three weeks (10-12) were dominated by the ECA.
ECA Project
The EMA had three requirements - (i) provision of advice on issues with the proposed MySQL/ColdFusion solution and scaling out,(ii) conversion of an E-R diagram into an SQL script for database construction and (iii) production of some example ColdFusion scripts demonstrating database interactions.