CE-07.22

Title: 

Fully Implementing SQL3 User Defined Types in the ER Design Tools

Author(s): 

Sugam Khokhani

Oral Defence Date: 

10/05/2007

Location: 

TH 428

Committee: 

Professors Marguerite Murphy, Professor Dragutin Petkovic

Abstract: 

The Entity Relationship (ER) Model is the basis of a successful database modeling. The ER Design Tool, developed at SFSU, is a useful program that helps CSC 675/775 and CSC 730 students to learn the ER model and various implementation models. One of the main features of these tools is taking input from the user through a GUI and displaying the ER diagram and its output in different output modes, like the SQL DDL syntax, UML View, ODMG syntax, Relational Schema, etc. This design tool is implemented in Java, using Java Swing components for the GUI. The goal of this project is to fully design, develop and integrate the SQL3 User Defined Types (UDT) into the ER Design Tool. This means that after the user creates a UDT, he/she should be able to use it as a domain for any simple attribute and should be able to see the UDT output in different output modes like the ER Schema, English Description, SQL Syntax, Constraints Description, Relational Schema, UML View and the ODMG View. This implementation is fully functional and is designed and developed using the Java language and the Java Swing components.

Keywords: 

ER, UDT, Schema, SQL3.

Copyright: 

Sugam Khokhani