Databases Course Work

Databases - Assignment 2: Video Library.

PL/SQL Stored Proceedures

• Part 1: PL/SQL proceedure for renting a video.
  
  
• Part 2: PL/SQL proceedure for returning a video.
  
  
• Part 3: PL/SQL proceedure for producing a report of overdue videos.
  
  

  Creating Video Shop Schema and Tuples

• Video Schema.
  
  
• Video Tuples.
  
  

  Removing Video Shop Schema and Tuples

• Drop Schema
  
  
• Delete Tuples.
  
  

  PL/SQL Blocks

• Block used to Test/Develope Part 1.
  
  
• Block used to Test/Develope Part 2.
  
  
• Block used to Test/Develope Part 3.
  
  

  JDBC

• Java Interface Program.