Skip to content

tcvduc/hospital-management

Repository files navigation

HCMUS - CSC12001 - Information System Data Security Course Project

Prject name: Hospital Management Project

Description: A web app and window app that is created for a database administrator, system administrator manage the hospital system data and common features of some user role in the hospital system

Team

@duccao99 @tonsisouvanh

Technical stack

Frontend: html, css,bootstrap, javascript, volt-template,themesberg

Backend: nodejs,node-oracledb, electronjs, handlebars

Database: Oracle

Oracle technical stack

DAC - Discretionary Access Control

RBAC - Role-based Access Control

VPD - Virtual Private Database

SQL Injection

Encrypt & Decrypt

OLS - Oracle Label Security

Audit

Project report: Link

OLS description: Link

Some Image results

Sign-in

sign-in

View record

view-record

User-role-feature

User-role-feature

An encrypting procedure

An encrypting procedure

Encrypted Result

Encrypted Result

Audit

Audit

How to use

+ Step 1: Install and setup NodeJS platform, Oracle 18C, Oracle SQL Developer

+ Step 2: Clone this project, open and type "npm i" command in the terminal

+ Step 3: Open sql folder, run func&proc file, create DBA in queryDB, run scriptDB file

+ Step 4: Open two terminal, the first one type "npm run dev" to start the server, and the last one type "npm start" to start the electron-js.