Database Courseware: Functionality and Classroom Usage. http://coffee.kennesaw.edu NSF Grant: 008914. Mario Guimaraes [email protected] Recent Improvements. Recovery (Logical versus Physical writes) Concurrency – Triggers SQL: distinct, outer join, order by clauses
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Database Courseware: Functionality and Classroom Usage
http://coffee.kennesaw.edu NSF Grant: 008914
Mario [email protected]
Recovery (Logical versus Physical writes)
Concurrency – Triggers
SQL: distinct, outer join, order by clauses
More description in the concurrency modules
Making more friendly w/ more help windows
1 core db class CSIS3310
1 elective db class CSIS4310
graduate Database classes
but not a standard as to what is taught.
Scenario (Problem Specification) to E-R
E-R to Tables
SQL procedural animation
SQL animation through Relational Alg.
Concurrency, Recovery, Triggers
Assign exercises related to the scenario
2) SQL queries: associates known code with unknown (multiple code windows), Reduces learning time.
3) Concurrency: allows students to control their own pace. Reduces learning time.
Students who are unsatisfied with the class as well as the satisfied students praised the software
SQL Query Animation w/Procedural Code