UDC 004.43 A Generator of SQL Schema Specifications Slavica Aleksić 1 , Ivan Luković 1 , Pavle Mogin 2 , Miro Govedarica 1 1 University of Novi Sad, Faculty of Technical Sciences, 21000 Novi Sad, Trg Dositeja Obradovića 6, Serbia {slavica, ivan, miro}@uns.ns.ac.yu 2 Victoria University of Wellington, Wellington, P.O. Box 600, New Zealand pmogin@mcs.vuw.ac.nz Abstract. IIS*Case is an integrated CASE tool that supports the auto- mation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environ- ments, generates relational database schemas in 3 rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that gener- ates the implementation specification of a database schema according to ANSI SQL:2003 standard. The generator may also produce a data- base schema specification for Microsoft SQL Server or Oracle DBMSs. The paper describes SQL Generator's traits, considers aspects of its application, and shows its use in the implementation of a complex da- tabase constraint using procedural mechanisms of a particular relational DBMS. SQL Generator is implemented in Java and Oracle JDeveloper environment. 1. Introduction Integrated Information Systems*Case (IIS*Case) V.6.2 is a tool that provides the automation and an intelligent support for performing complex and highly formalized design and programming tasks in the development of an informa- tion system. It is designed to provide complete support for: (i) developing da- tabase (db) schemas that are complex with regard to the number of concepts used, and (ii) software applications of an information system. The form type is one of the main IIS*Case concepts. It is semantically rich enough to enable expressing the elements of the static and dynamic struc- tures in an application domain. By means of form types, a designer creates simultaneously a model of the structure and behavior of various business documents, and a conceptual db schema. Starting from the created concep- tual schema, IIS*Case automatically generates a relational db schema in 3 rd normal form (3NF) with all relevant data constraints. Detailed information about IIS*Case and its main concepts may be found in several authors' refer- ences, as well as in [7, 9, 13, 18, 19]. IIS*Case is designed to provide a fast generation of db schemas and appli- cation prototypes. Although the concept of the form type is highly formalized,