Graduate Project


Visual SQL analyzer project report Public Deposited

Downloadable Content

Download PDF


Attribute NameValues
  • Structure Query Language (SQL) is widely used to access data stored in relational database systems. Although a powerful and flexible language, SQL can also be complex and hard to learn. For most new SQL users, it's easy to write SQL statement by following SQL grammar and syntax rules, but it's hard to know if the statement expresses what the user really wants. In most cases, a visual representation can help the user interpret and understand the SQL Statement being represented. An effective graphical representation often conveys a concept immediately and more clearly than a literal explanation. To help new users to learn SQL, we have developed a tool to help them understand the SQL statements, and check if the semantics matches their intentions. For this project we developed a simple Visual SQL Analyzer tool to translate SQL statement into Visual diagrams to show what the database will do with statement, so that the user could understand and confirm their intentions. The implementation of our tool has five tables and ten fields per table limitation and only implements the six most common SQL statements. However, it can be extended. The visual representation used in our project was introduced in the book "A Visual Introduction to SQL", and has been used in other system such as MS SQL Server. our system is the only web_based and free tool.
  • 2001 best estimate for issue date and commencement year based on available information.
Resource Type
Date Issued
Degree Level
Degree Name
Degree Field
Degree Grantor
Commencement Year
Committee Member
Academic Affiliation
Rights Statement
Peer Reviewed



This work has no parents.