Please use this identifier to cite or link to this item: https://hdl.handle.net/10356/156638
Title: Visualizing real-world relational database schema
Authors: Chew, Yee Hian
Keywords: Engineering::Computer science and engineering::Information systems::Database management
Issue Date: 2022
Publisher: Nanyang Technological University
Source: Chew, Y. H. (2022). Visualizing real-world relational database schema. Final Year Project (FYP), Nanyang Technological University, Singapore. https://hdl.handle.net/10356/156638
Abstract: Relational databases are prevalent in almost every industry. Formulating Structured Query Language (SQL) queries for data of interest can be challenging when relational databases grow to become large and complex. The database schema provides information to help with the queries, but the information provided is overly dense and complicated to be used efficiently in large databases, that can contain tens to hundreds of relations and tables having hundreds of attributes. As such, a better way of data visualization is needed, especially so in a world today filled with Big Data. To solve the problem of information overload in database schemas, abstraction is key. Visualization of such database schemas requires much selection on what information to be displayed on the screen. It is important to balance the amount of information displayed while maintaining the visual’s usability. A web application is developed in this project to selectively visualize information of database schemas. The application should serve to facilitate easier SQL queries in real world large databases.
URI: https://hdl.handle.net/10356/156638
Fulltext Permission: restricted
Fulltext Availability: With Fulltext
Appears in Collections:SCSE Student Reports (FYP/IA/PA/PI)

Files in This Item:
File Description SizeFormat 
Amended FYP report.pdf
  Restricted Access
amended fyp report1.85 MBAdobe PDFView/Open

Page view(s)

17
Updated on May 18, 2022

Download(s)

2
Updated on May 18, 2022

Google ScholarTM

Check

Items in DR-NTU are protected by copyright, with all rights reserved, unless otherwise indicated.