Fruit Over Simplified Relational Database
- tutorial.sql: fruit2Tables.sql.html html links add <pre> tag to SQL file, scripts create both fruit and inventory table - same as fruit.sql.html
- Homework intermediate.sql run query and add comments on what each query does
- PHPMyAdmin Intro: fruit1Table.sql create only the fruit table - assignment pmaIntro.sql
- Advance PHPMyAdmin fruit table scripts:
- fruitAlter.sql Make sure all primary, future foreign keys and engines are equivalent
- fruitPurge.sql - drops everything created in PHPMyAdmin videos,
- fruit5Tables.sql creates all 5 fruit table then run fruitAlter.sql script, finally add views created in pmaView.sql.
- Create fruit5TablesAltered.sql, five fruit tables that have been altered, by fruitAlter.sql - just execute views created in pmaView.sql. Note fruitAlter.sql adds column shipDate to orders.
- assignment pmaReset.sql partially completed sources fruitReset.sql.
- fruitTrigger.sql Advance triggers and foreign constraints - fruitConstraintTest.sql used to test constraints, note fruitTrigger.sql adds import time to shipDate order 23, and adds table:myError.
- fruitRoutineCreate.sql | fruitRoutineTest.sql | fruitRoutine.sql procedures orderInvoice, orderInvoiceVerySimple, and function getImageURL.
- fruitTransactionCreate.sql | fruitTransactionTest.sql | fruitTransaction.sql functions: testFruitExistence and procedures testFruitTransaction, testTransaction
- Display Table Data and Web Interface