mahmoudalnkeeb

JWT-Based Authentication and Authorization System in Node.js

1. User Registration:

• Users provide registration details (e.g., username, email, password) through a registration form.
• Server receives the registration request, validates the input data, and securely hashes the password before storing it in the database.
• Upon successful registration, the server responds with a success message or redirects the user to the login page.

2. User Authentication:

• Users provide login credentials (username/email and password) through a login form. The server validates the credentials, checks the user's existence, and verifies the provided password against the stored hashed password.

mahmoudalnkeeb

Principles of Database Normalization

Database normalization is a systematic approach to organizing data in a database to reduce redundancy and improve data integrity. The process involves decomposing large tables into smaller, related tables and defining relationships between them. Normalization typically progresses through several forms, each addressing specific types of anomalies and dependencies.

First Normal Form (1NF)

1NF requires that each column in a table contains atomic (indivisible) values and that each column contains only one type of data.

Example: A table with multiple phone numbers in one column is not in 1NF. To convert it, split the phone numbers into separate rows:

mahmoudalnkeeb

MOP-X: TEMPLATE

---

Change Details 1

Change Resources 1

Change Timelines 1

mahmoudalnkeeb

PostGres Basic Syntax

meta commnds

 \c connect
 \q exit
 \dt display table
 \l list of databases

create database