/Sabiduria_DB_Copia

"Sabiduría Digital" is a streamlined enrollment system for educational institutions, utilizing SQLite and JavaScript. It facilitates quick, paperless student registration, tailored to specific institutional needs.

Primary LanguageJavaScript

Sabiduría Digital - Educational Information System

Logo de Sabiduría

Transforming Aspirant Acquisition Through Innovative Technology

GitHub lellerena GitHub JuandiGo1 GitHub Almor21 GitHub Slrosales GitHub jfbenitezz

Introduction

The Sabiduría Digital project transforms the applicant acquisition process through innovative technology. This system integrates web development with database management to optimize administrative workflows, enhance user experience, and support decision-making processes.

Features

  • Intuitive and interactive user interface for both applicants and administrative staff.
  • Automated applicant acquisition process.
  • Data-driven insights for informed decision-making.
  • Progressive web application with JavaScript and SQLite for robustness and efficiency.

System Requirements

  • Node.js (version 14 or higher)
  • Modern web browser (e.g., Chrome, Firefox, Safari)
  • SQLite3

Installation

  1. Clone the repository:

    git clone https://github.com/JuandiGo1/Sabiduria-DB.git

  2. Navigate to the project directory:

    cd Sabiduria-DB

  3. Install dependencies:

    npm install

  4. Initialize the database:

    node seed.js

Admin dashboard use

npm run start:admin

Usage

To start the server, run the following command:

npm start

Access the application by navigating to http://localhost:3000 in your web browser.

Database Schema

The system utilizes a relational database with the following tables:

  • Programa: Contains details about educational programs offered.
  • Requisitos: Lists the requirements for each program.
  • Objetivos: Holds objectives for each program.
  • Requisitos_cumplidos: Tracks which requirements have been fulfilled by applicants.
  • Aspirante: Stores information about applicants.
  • Usuario: Manages user authentication.
  • Admin: Admin credentials and management.
  • Telefono: Contact information for applicants.
  • Direccion: Address information for applicants.
  • Pago: Payment transactions related to applicants.
  • Area: Defines study areas within programs.
  • Asignatura: Describes subjects taught within each area.

For more details on the database schema, please refer to the schema.sql file.

Entity–Relationship Model

Relational Model

Team

  • Felipe Benítez (Model Lead)
  • Laura Gómez
  • Luis Llerena (Backend Lead)
  • Juan Maestre
  • Edinson Noriega (Frontend Lead)

:D