Attachments:

File
Script to create the tables of the Medical Database
Script to Create the tables of the Movie Database
Script to Create the tables of the Publishing Database
SQL Queries on the Medical Database
Answers to Queries on Medical Database
Answers to Queries on Movie Database
SQL Queries on Publishing Database
Answers to Queries on Publishing Database
SQL Queries on the Movie Database
Structure and Data - Medical Database
Structure and Data - Movie Database
Structure and Data - Publishing Database

Motion Picture Database

We recommend that you have Oracle installed, and execute the movtables.sql script in order to create the tables. The Motion Picture database consists of the following tables:

MOVIE - details about movies
COMPOSER - details about musicians who have composed the music for the movie
DIRECTOR - details about directors
DIRECTOR_MOVIES - details about the director and the movies
CAST - details of the cast (actors)
MOVIE_CAST - details of the cast and the movie they acted in.

Medical Database

We recommend that you have Oracle installed, and execute the medtables.sql script in order to create the tables. The Medical database consists of the following tables:

PHYSICIAN - details about physicians
SPECIALITY - details the areas of specializations
PHYSICIAN_SPECIALITY - details the areas of specializations for physicians
EXPERIENCE_LEVEL - details the experience level based on years of service
NURSE - details of nurses
WARD - details of wards
PATIENT - details of patients
INVOICE - details of invoices

Publishing Database

We recommend that you have Oracle installed, and execute the movtables.sql script in order to create the tables. The Motion Picture database consists of the following tables:

PUBLISHER - details about publishers
AUTHOR - details about authors
TITLES - details about books
TITLEAUTHOR - details about authors and the books written by them
STORE - details about stores
SALES - details about a sale
SALESDETAIL - details about the titles purchased
DISCOUNTS - details about discounts