Query Processing in GIS

  • Course: CSE2004 Database Systems (VIT)
  • Tech Stack: Java, SQL, Apache Web Server, NetBeans (IDE), MySQL, PHP, phpMyAdmin
  • This project demonstrates the significance of query processing and the use of frontends and connectivity tools in creating a functional database system, thus enhancing our understanding of database management and system interaction.
  • We focuse on query processing, where the scope is to facilitate easy management of orders by users.
  • Here, we create a fully functioning query processing system that connects MySQL to Java for easy management of orders.
  • The project includes features such as logging in with valid credentials, searching for specified products, listing products from various categories, viewing customer details, placing and displaying orders, and showing order summaries.
  • We can also sort out information based on various factors such as employee details, branch-wise data, and stock of products.
PHP MyAdmin

User Login Screen

User Desktop Screen

Category Screen

ER Diagram