Database Design
SQL Query Animations
Concurrency

Database Design

• Introduction
• Convert E-R to Tables 1:N (Employee Work in Department)
• Convert E-R to Tables 1:N Recursive (Employee Manages Employee)
• Convert E-R to Tables 1:1 (Employee is Assigned to Parking Space)
• Convert E-R to Tables 1:1 (Faculty Chairs Department)
• Convert E-R to Tables N:N (Employee works_on Projects)
• Convert E-R to Tables N:N Recursive (Projects have Alternative Projects)
• Generalization (Employee is a Secretary, Technician or Engineer)
• Normalization Tutorial (obs: under development, VB downloadable, 1024 x 768 res.or higher)
• Normalization Exercise (obs: under development)

SQL Query Animations     Database Design     Concurrency    Feedback

SQL query animations (downloadable in Visual Basic 6.0)
Go to File Menu -> Resolutions to set pgm. to 1024 x 768 or 800 x 600

• Introduction
• Index
• Restriction
• Union without eliminating duplicates
• Union eliminating duplicates
• Division
• Join
• Join with 1 table - renaming (Employee in same city)
• Join with 1 table - renaming (Employee in same department)
• Not In
• Not Equal
  

SQL query animations

• Introduction
• Construction: Projection/Restriction/Multiplication/Join/Intersection/Difference/Functions/Group By/Having
• Animating SQL with Procedural Code: Projection/Restriction/Mult/Join/Intersection/Difference/Functions/Group By/Having
• Advanced SQL Queries (under development)

SQL Query Animations     Database Design     Concurrency     Feedback

Concurrency (java applets)

• Introduction
• Lost Update/Record Locking/Deadlock/Serial Locking: Introduction
• Lost Update/Record Locking/Deadlock/Serial Locking: Transferring Money Example

Tests (under development)

• Introduction
• Database Design - E-R and UML
• Database Design - Normalization
• Relational Algebra
• SQL
• Oracle - Database Administration

Feedback (Questions? Comments? )

Student Evaluation Form (On-Line) ,
Instructor Evaluation Form (On-Line)
Student Evaluation Form (Hard Copy)
Instructor Evaluation Form (Hard Copy)
or Contact mguimara@kennesaw.edu