CS1106 Project

Table of Content

• CS1106 Project
  • Description
  • ER Model
    • Proposed ER Models
    • Final ER Model
  • Relational Schema
    • Final Schema
  • Tech Stack
  • MySQL

Description

The Basic idea for this project is to create an online platform where students from the same college/university can come and ask questions from from there fellow mates.

The Platform will have:

• User Accounts (Sign Up / Sign In) Functionality
• Ability to Posting Questions
• Answer Question
• Database Connectivity
• Password Resetting Functionality
• Ability to vote answers
• Searching Functionality

ER Model

Proposed ER Models

• By @akathecoder

• By @rg12301

• By @nonitmittal

Final ER Model

Relational Schema

Final Schema

Tech Stack

Technology	Used for
ReactJS	Frontend
NodeJS, ExpressJS	Backend
MySQL	Database
AWS	Hosting
Algolia	Search Functionality

MySQL

• Create New User
• Create & Insert SQL queries