Skip to content

Latest commit

 

History

History
33 lines (19 loc) · 1.64 KB

File metadata and controls

33 lines (19 loc) · 1.64 KB

SQL Server Database Implementation - Student Admissions Portal (SAP)

The purpose of this project was to create a student admissions portal that allows students to efficiently and quickly submit a college application. Students can easily create an account, log in, and submit an application on a website. The front-end application connects to a back-end database system in SQL Server 2022. The project resulted in a robust, secure, and efficient Student Admissions Portal, significantly improving the application submission process and providing a reliable backend infrastructure.

  1. Web Server: Operating System - Windows, Mac OS Linux, or any other supported server

  2. Database Server - SQL Server and SSMS

  3. Programming Languages - C++, SQL

  4. Frameworks and libraries - .net

  5. Internet connectivity - stable, reliable internet connection

  6. Backup

  7. Security Measures

Key Contributions:

  • Team Lead & Project Manager: leading the team of three; organizing tasks; managing timelines and progress; supervising my team; testing and presenting the project
  • Database Design & Development - SQL queries: creating DB and tables; stored procedures & triggers; database testing
  • Front-End and Back-End Connectivity: providing key insights; checking team's coding part; fixing errors
  • Security Plan: hashed-passwords; user authentication

Example of the stored procedures:

image

Project SAP - Report.pdf