Enterprise web programming

Units 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 units include some material that was formerly part of the WEB1P and WEB2P units.