Data Storage Administration Project

Oracle database school project for year 1 semester 2 the team members include

• Gangula Karthik
• Jay Krish Vijendra
• Ng Jun ming
• Seah Pin Shien

PART 1: ORA-ENTAL DATABASE DDL SCRIPTS

Task 1: Database Table structure ✅

Task 2: Create and manage constraints ✅

Task 3: Working with sequences ✅

        - create sequences ✅
        - insert data ✅
        - use indexes ✅
        - create views ✅
        - create synonyms ✅

Do documentation (fill out the template) ✅

PART 2: DATA RETRIEVAL AND MANIPULATION TASKS (HARDWARELAND DATABASE)

Task 1: SQL statements ✅

Task 2: Send out emails to the teacher ✅