rdbms-ca

A collection of 12 RDBMS and MySQL programs covering SQL DDL, DML, PL/SQL, Joins, CRUD APIs, password hashing, AI book recommendation, and more. Perfect for learning and reference.

Installation

npm install rdbms-ca

Usage

List all programs

const rdbms = require('rdbms-ca');

rdbms.programs.forEach(p => {
  console.log(`${p.id}. ${p.name} — ${p.file}`);
});

Read a specific program

const rdbms = require('rdbms-ca');

const content = rdbms.getFileContent('Joins.js');
console.log(content);

Get file path

const rdbms = require('rdbms-ca');

const filePath = rdbms.getFilePath('CRUD_API.js');
console.log(filePath);

Copy all programs to your project

const rdbms = require('rdbms-ca');

const copiedFiles = rdbms.copyAllTo('./my-rdbms-programs');
console.log('Copied:', copiedFiles);

Get all file paths

const rdbms = require('rdbms-ca');

const paths = rdbms.getAllFilePaths();
console.log(paths);

Included Programs

| # | File | Description | |---|------|-------------| | 1 | AI_Book_Recommondation_System.js | AI Book Recommendation System | | 2 | Arithmetic_Operations.js | Arithmetic Operations (PL/SQL) | | 3 | CRUD_API.js | CRUD API with Express & OracleDB | | 4 | DDL_Commands_ALTER_MODIFY.js | DDL Commands (ALTER, MODIFY) | | 5 | DML_Commands_INSERT_UPDATE.js | DML Commands (INSERT, UPDATE) | | 6 | Electricity_Bill.js | Electricity Bill Calculation | | 7 | Employee_Bonus.js | Employee Bonus Calculation | | 8 | FOR_Loop.js | FOR Loop (PL/SQL) | | 9 | Grade_Calculation.js | Grade Calculation | | 10 | Joins.js | SQL Joins (INNER, LEFT, RIGHT, FULL) | | 11 | PL_SQL_CRUD_Operations.js | PL/SQL CRUD Operations | | 12 | Password_Hashing.js | Password Hashing with bcrypt |

License

MIT