Enterprise web programming

Modules ENTWA (Level 6) and APSW (Level 7)

VP database specification

This document defines the main characteristics of the PDB database used in the coursework.

Access details

Database driver class	oracle.jdbc.driver.OracleDriver (download JAR 1.5MB or visit the Oracle website)
URL	jdbc:oracle:thin:@www.herring.mech.port.ac.uk:1521:SALMON
Username	VPRO
Password	Emailed to you

The database is read-only. You should only run SELECT queries on it. Do not try to execute an INSERT or UPDATE. All accesses are logged.

SSH tunneling can be used to make connections through the firewall.

Database structure

Entities

Table	Contains	Notes
ACCESS_CONTROL	Defines whether a specific member of staff can access a course or unit
ANNUMS	List of annums (sets of feedback data)
COMMENTS	Students' answers to text questions about courses
COURSE	List of courses
COURSEUNIT	List of which units are on which courses (in which semester)
COURSE_GROUP_LINK	What groups of questions are associated with each course/unit
GROUPS	Names of groups	Unused?
GROUP_QUESTION_LINK	Which questions are included in which question groups
LIKERT	Students' answers to Likert scale questions about courses
LIKERTSCALE	Maps code to Likert scale responses
QGROUP	Groups of questions
QUESTION	Text of questions
QUESTION_TYPE	Types of questions
STAFF	List of staff who use the system
STUDENT	List of students who use the system
UNIT	List of units
UNITFEEDBACK	Students' answers to questions about units
USERS	Users of the system
USER_ROLES	Roles allocated to users

Nearly everything in the database is related to an "annum". An annum represents a set of feedback data (normally one per year, or one per semester). Courses, units and which units make up which courses (as well as which staff have access to feedback on a course or unit) all may change from annum to annum. What questions get asked might also vary from annum to annum, but has not yet done so.

SQL script (zipped) to recreate the database.

	Last updated by Prof Jim Briggs of the School of Computing at the University of Portsmouth
	The enterprise web programming modules include some material that was formerly part of the WEB1P and WEB2P units.