Database design

We survey and critically compare various approaches and software products for the modeling and logical design of relational databases. In particular, we examine different information modeling methodologies, such as Information Engineering, CASE$\sp*$Method, the Three Schema Concept, as well as data modeling techniques, such as the Entity-Relationship techniques, and the Object Role Modeling technique.

In this thesis, importance of Intelligent Data Repository (IDR) and its real life applications are studied. We proposed an IDR for oncology applications which can handle large datasets and which can be used on both the intranet and the Internet. It is designed to provide one or multiple medical institutions on a global scale a common platform for patient care and consultation. The proposed application consists of two key models, Body Surface Area model and Search model, which are described in detail and their results are discussed. We have implemented the proposed IDR for oncology application using ColdFusion MX. Existing research in this area have been studied and compared. Framework of the proposed IDR, structure, front-end user interface and back-end database schema of the proposed oncology application are explained in this thesis.