UDC 004.43

Slavica Aleksić¹, Ivan Luković¹, Pavle Mogin², Miro Govedarica¹

¹ University of Novi Sad, Faculty of Technical Sciences,
21000 Novi Sad, Trg Dositeja Obradovića 6, Serbia
{slavica, ivan, miro}@uns.ns.ac.yu

² 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 automation 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 environments, generates relational database schemas in 3rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that generates the implementation specification of a database schema ac­cording to ANSI SQL:2003 standard. The generator may also produce a database 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 envi­ronment.