ICS 324  Database Systems (Labs)

Announcements:

Syllabus

Labs

Lab 1:     Introduction/Syllabus

Lab 2:     Database Tools (doc)  (pdf)

Lab 3:    Conceptual Modeling using ER (doc)  (pdf)

Lab 4:    Exercises on ER (doc)    (Pdf)

Lab 5:    Exercises on EER (doc)    (Pdf)

Lab 6:    Project  (doc)    (Pdf)

             Detailed Description  

            Problem Statement Examples    1    2    3    4

Lab 7:    Relational Mappings (doc)    (pdf)

lab 8:    Relational Algebra (doc)

Lab 9:    SQL - Data Definition Language (DDL) (doc)

                Demo database

                File structure for each relation (Example)

Lab 10:    SQL - Data Manupulation Language (DML) (doc)

Lab 11:    SQL  -  Basic Query (doc)

Lab 12:    SQL  - Advanced Query (doc)    Demo Data 10g