Create a Relational Database Application

About The Project

A Company is implementing a robust RDBMS to streamline its employment application process. Our goal is to efficiently manage applications, track candidate progress, and enhance communication between recruiters and applicants.

Table Of Contents

1. About The Project
   • Table Of Contents
   • Features
   • Technologies Used
2. Database Design
3. Website Snapshots
4. Getting Started
   • Prerequisites
   • Installation
5. Run
6. Contributors
7. License

Features

• Authentication System
• Log in and log out function
• Dashboard
• Queries
• Applicant CRUD
• Application CRUD
• Education History CRUD
• Employment History CRUD
• Reference CRUD
• Print Functionality
• Search

Technologies Used

We use a number of open source projects to work properly:

• React
• Node.js
• Express
• MySQL
• bcrypt
• jsonwebtoken

Database Design

Database design plays a very important part in the Software Development Life Cycle (SDLC). This part includes creating metadata, normalization, and constructing an Entity-Relationship Diagram (ERD).

• Metadata

• Normalization

• ERD

To add, provided here is the .sql file of dbKraft (the database used) if you want to have the database ready.

Website Snapshots

Log in page

Home page

CRUD page example

Query page

Query page example

Getting Started

KRAFT is not yet accessible to the world wide web, as it is yet to be deployed. But, if you're interested in seeing the UI and experience the website yourself, you are in the right section of the README. To get started with accessing the source code, follow the steps below.

Prequisites

• Ensure that Node.js and npm are installed on your machine.

Installation

1. You can fork this repository, or you can also clone this repository directly on your local machine.

2. After cloning the repository on your local machine, access it on any IDE.

   After opening the project, you should see all the files

3. Install dependencies using,
   

   npm install
   

4. Create a .env on the server folder and type the code below. Make sure to replace YOUR_DB_PASSWORD_HERE with your actual MariaDB/MySQL/Any RDBMS password.
   

   DATABASE_PASSWORD="YOUR_DB_PASSWORD_HERE"
   

5. Configure the database connection in server/config/db.js as per your MariaDB/MySQL/Any RDBMS database environment.

6. To install the required dependencies for the client folder, see the package.json for the client-side.

7. To install the required dependencies for the server folder, see the package.json for the server-side.

Run

• Run the server on /server.
  

  node server.js
  

• With nodemon, you can run the server using,
  

  npm run server
  

• Run the client on /client.
  

  npm start
  

Contributor's Table

Name	Avatar	GitHub	Contributions
Regina Bonifacio		Feiryrej	Fullstack Developer
Isaeus Guiang		asiguiang	Database Administrator, Technical Writer

Name

Avatar
GitHub Contributions

Regina Bonifacio Feiryrej Fullstack Developer Isaeus Guiang asiguiang Database Administrator, Technical Writer Checkout My Colleague's Repository: https://github.com/feiryrej/KRAFTCompany License Distributed under the MIT License. See LICENSE for more information.

The above is the detailed content of Create a Relational Database Application. For more information, please follow other related articles on the PHP Chinese website!