Concise Summary:
Concept and Inspiration:
My group for my relational databases course at San Jose State University had to come up with a project idea to learn SQL, JSP, and Tomcat. Our idea consisted of a forum application to replace the terrible app that our school currently uses for students to ask faculty and other students questions about the school. Think about an application like Quora.
Team and Team Size:
My team consisted of three of us, all coding different aspects of the project. The group members were: Lexin Ma, Nimra Naveed, and myself.
Main design goals:
Ability to post questions
Ability to create an account and sign in/log out
Ability to moderate questions with proper privledges
Proper database design for questions and user data
Multiple pages based on different question categories
Search bar to search for keywords
Proper fetching and updating of questions listed on home page from the database
Differentiation of users posting or replying to questions via unique ID
Main Challenges Faced so Far:
Learning how to use JSP files in conjunction with Java files to query database
Page Design that looks professional
Proper User privleges and error checking
Tools and Technologies Used:
Java
HTML/CSS
Tomcat Server
SQL
JSP
Javascript
MySQL Workbench Ver. 8.0 CE
Demonstration video