          AQIL BURNEY 1 , NADEEM MAHMOOD 1 , KAMRAN AHSAN 2 1 Department of Computer Science (UBIT) University of Karachi Karachi)75270, Karachi PAKISTAN burney@uok.edu.pk http://www.drburney.net nmahmood@uok.edu.pk 2 Faculty of Computer Engineering and Technology & Health Sciences Department Staffordshire University UNITED KINGDOM k.ahsan@staffs.ac.uk   Time is one of the most difficult aspects to handle in real world applications, especially in database systems. Relational database management systems proposed by Codd offer very little built)in support for managing time varying data and theory of temporal semantics. Many temporal extensions of the relational model have been proposed and some of them are also implemented. The proposed system is based on an ontology of health Care terminology including patients vital data, activities and as well as the treatment data. We will propose a conceptual temporal model for handling time varying attributes in the relational database model with minimal temporal attributes. The proposed model is easy to define, manage and incorporates the important and relevant features in the target temporal relational model. Furthermore we have illustrated implementation of the model on patient database and also present the requirement analysis: work flow for managing patients in hospital environment. In response to rising health care costs, reliability, privacy, security and changing expectations concerning the quality of health care, data management is very important in improving health care services.   Relational database, temporal semantics, ontology, temporal relational model, health care management.   The relational model [11] is based on a brand of mathematics called relational algebra. Codd used that concept to manage huge amounts of data very effectively. Codd and others have extended the notion to apply to database design. Thus they were able to take advantage of the power of mathematical abstraction and the expressiveness of mathematical notation to develop a simple but powerful structure for databases [20]. A relation has to be in first normal form (FNF), meaning that the domains of the attributes in its schema may only be of scalar data types. In other words, a relation can be considered as a subset of the Cartesian product of all the attribute domains contained in its schema. The relational data model only support functionality to access a single state of the real world, called a snapshot. The transition from one database state to another (updates) thereby giving up the old state. There exist, however, many application domains which need to have access not only to the most recent state, but also to past and even future states, and the notion of data consistency must be extended to cover all of these database states. Due to the FNF assumption in the relational model, there is a restriction in expressing the data structures. To overcome this drawback, the relational model has been extended [13] to support, non first normal form (NFNF) or nested relations. Efforts to incorporate the temporal domain into database management system have been ongoing for more than a decade and dozens of temporal models have been proposed [6], [8], [10], [17] and a few of them have been implemented [1], [9], [29], [30]. Designing effective, secure[28] and useful healthcare information systems which handles temporal data is a great challenge for software engineers. It includes very complex information that evolves with time. Relational model is a very powerful model and well accepted model among the vendors. There are number of extensions to this model which incorporates time varying data. In this paper we investigate the patient data management (PDM) with respect to the time varying nature of data and propose a conceptual temporal relational schema for PDM. RECENT ADVANCES in ARTIFICIAL INTELLIGENCE, KNOWLEDGE ENGINEERING and DATA BASES ISSN: 1790-5109 237 ISBN: 978-960-474-154-0