Enterprise web programming

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

TEIS database specification

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

SQL scripts

These scripts were generated for an Oracle database and may need adaptation to run on another DBMS.

Table creation script	teisro.sql
Data insertion script	teisrodata.sql

Database structure

Entities

Table	Contains	Notes
PROJECT	Details about a telemedicine project or activity	Has sub-tables (see below)
ORGANISATION	Details about an organisation (companies, universities, funding bodies, etc.)
PERSON	Details about a person
PRODUCT	Details about a telemedicine product or piece of equipment
PUBLICATION	Details about a publication (book or report)

The following tables are sub-tables of table PROJECT. Their contents can be regarded as logical extensions of the corresponding row in the main table. The data is held in these tables to make it easier to manage and store.

PROJ_FUNDING

PROJ_PATIENTS

PROJ_PLANS

PROJ_RESULTS

PROJ_TECHNICAL

Relationships

Table	Relationship (most are Many-to-Many)
BASED_AT	Maps a project on to the organisation that it is based at
FUNDER	Maps a project on to the organisation who funds it
MAKES	Maps a product on to the organisation that produces it
ORGCONTACT	Maps an organisation on to the person who is the contact for it
ORGWRITE	Maps an organisation on to the publications it has written
PARTNER	Maps a project on to an organisation that was a partner in that project
PROJECTPRODUCT	Maps a project on to the product it uses
PROJECT_CONTACT	Maps a project on to the person who is the project contact
PUBCONTACT	Maps a publication on to the person who should be contacted about it
PUBLISHES	Maps an organisation on to the publications it has published
SUPPLIES	Maps an organisation on to the project it has supplied
WRITES	Maps a person on to the publication they have authored
WRITES_ABOUT	Maps a person on to the project they have written about
WRITTEN_ABOUT	Maps a publication on to the project to which it refers

Tables to be ignored

LINK

LOG

PLAN_TABLE

PROJECTLINK

REMOTEUSER

SESSDATA

SESSION_TEMP_PROJECT

	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.