☑️ Designing database schema according to business logic
☑️ Adding the necessary privileges
☑️ Creating db objects
☑️ Inserting sample data
💡 Working on new features
🚀 Generally, I am using this project and repo to develop my Oracle SQL and PLSQL skills, so it will be constantly being developed and expanded with new features.
Database project created as a final part of Oracle SQL/PLSQL Introduction course organized by Corporate Readiness Certificate (CRC) and driven by ING Hubs Poland.
ORACLE database to support online banking application. It alllows to:
BUSINESS LOGIC:
◾ creating new accounts, deactivating accounts
◾ transactions management, data reporting and analyzing
◾ storing historical data pre-change eg. the personal data of customers
◾ account number format to the IBAN standard
◾ validation of pesel number, customer age and other data
TECHNICAL AND OTHERS:
◾ storing logs from the db operations eg. packages initializing, logging parameters of subprograms and others
◾ finding and compiling all invalid database objects
◾ Oracle Database 21c XE
Clone repository
$ git clone https://github.com/pawelp0499/online-banking-database.git
Choose correct directory
$ cd online-banking-database
Run the script below by pressing F5 to import current state of database
prompt 'importing db'
@full-path-to-cloned-online-banking-database-repository\db_dump.sql;
◾ Smartphone icons created by Freepik - Flaticon
◾ Data quality icons created by khld939 - Flaticon
Copyright (c) 2022 Paweł Pechta