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
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
Sign-in
View record
User-role-feature
An encrypting procedure
Encrypted Result
Audit
+ 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.