In this assignment you will create a small website to provide an interface to a database of anatomical terms. The website allows users both to search for terms, and to browse two hierarchies: inheritance and part-of.
The database provided is a subset of the Foundational Model of Anatomy (developed at the University of Washington by Cornelius Rosse, et al.1). The database contains four tables: NAMES (id INT, name VARCHAR, isSynonym SMALLINT, authority VARCHAR), DEFINITIONS (id INT, definition VARCHAR), PARTS (id INT, part INT) and SUBCLASSES (id INT, subclass INT). Note that each term is uniquely defined by its id. This id is shared across all tables, and is referenced by part and subclass. The NAMES table contains a collection of accepted names for some entity (e.g., "Lung"). Each entity has one preferred name; all other names are synonyms (i.e., the isSynonym field is true). The DEFINITIONS table contains definitions for some entities. The PARTS and SUBCLASSES tables define hierarchies relating entities to each other. The entry (1, 2) in the PARTS table means that 1 "has-part" 2.You have to construct a website with the following structure:
To accomplish this task you will need to familiarize yourself with PostgreSQL. We have pre-loaded the data into a database named cse544. You will implement Java Server Pages, which will provide a web form for user input, interface with the database instance, and return HTML content. (These are suggested tools; if you prefer different methods, use them at your own risk.)
1Rosse C, Shapiro LG, Brinkley JF. “The digital anatomist foundational model: principles for defining and structuring its concept domain.” AMIA 1998: 820–824.
