Emergency Response System (ERS) is a growing important application in today Geographic Information System (GIS). Emergency can occur anywhere, anytime and to anyone without a warning. Immediate response in emergency is extremely needed to minimize greater damage and casualties. In other word, an effective and efficient emergency response management is able to minimize unnecessary risks. ERS is a system that designed to provide assistance to emergency responder to deal with emergency situation, it also seeks to stabilize the emergency situation and reduce the possibility of secondary damage. The overall objective in GIS for emergency response is to deliver accurate, appropriate timely information to all the parties involved in an emergency case at the proper stages of the emergency. ERS is an application that deals with dynamic changes of the objects movement, therefore it requires the management of spatial and temporal data. Consequently, the implementation of Moving Objects Database (MOD) as a backend for ERS is necessary. Researches on MOD have been extensively conducted over a significant period and it remains growing importance. The goal of research on moving objects database is to extend database technology so that any kind of moving entity can be represented in a database, and powerful query languages are available to formulate any kind of questions about such movements. MOD is needed in ERS to store, querying and analyzing moving objects data. This paper addresses the generic architecture of MOD for ERS in Malaysia. Furthermore, the issue of modeling, constructing and querying moving objects trajectory in the database is presented in this paper. We propose to model the trajectory as a 3D polyline (X, Y, and T) using view in spatial DBMS. View is a dynamic virtual table that has many advantages over ordinary table, one of the advantages is it takes a very small space to store. The 3D trajectory view is based on the GPS points table. Moreover, some examples of spatio-temporal queries, like present, future and continuous queries are also presented in this paper. The generic model in this paper is specifically designed for ERS, but it is possible to be used for every application that involves moving objects data on road network.