main
Course/Inform.	Schedule/Mater.	Exercises/Tables	Oracle/Help
ELTE BSc Databases 1, 2012/2013 Spring (Hajas Csilla)
Exercises and Tables/Sample Schemas

   
Relational Algebra
> Exercise01: likes table  and create like table 
> Exercise02: products tables  and create products tables
   
SQL SELECT statement, Extended Relational Algebra
> Exercise03: dept and emp tables  and create dept, emp tables
> Exercise04: products tables  and create products tables   

SQL INSERT, DELETE AND UPDATE statements
> Exercise05: dept and emp tables  and create dept, emp tables
 
PL/SQL
> FOR UPDATE CURSOR
   
Datalog and Recursion
> Exercise06: products tables (from Relational algebra into Datalog)
> Recursion in Datalog and SQL-1999 (handouts)
> Oracle: Hierarchikus lekérd.pdf 
    

---

Oracle Sample Schemas   
   
>  HR - Human Resource  - Concepts: HR Schema  and  create_hr tables
       
       
     
 
> SH -Sales History - sh_sema.pdf
    

---

   E-mail: Hajas Csilla © ELTE Department of Information Systems

Course/Info

Schedule

Exercises

Oracle/Help

Homepage