Database Labs. Course materials and exercises for learning how to organize and manage data.
github.com/rogerluan/Banco-de-Dados-PUC-Campinas-2017
Vaya's read on this project
Problem, audience, market, and the verdict — sign in to see it.
Updates
June 2017
- removed debugging logs
- fixed log
- added more logs
- changed trigger to trigger after operations
- added more log
- added more logs
- added logging
- Fixed non-boolean integers
- Fixed delete statement
- Added verification cases to treat deletion, insert and updates properly.
- fixed the name of the log_mov foreign key
- added 6 table update statements to test the backup functionality
- updated foreign key name
- created backup script
- added set serveroutput on
- changed all functions to return strings
- changed return type of the function
- return an error string in a function
- added city validation to all the functions
- Changed return type