Database analysis
make Database specifications for any application
Database design diagrams with elegant DB images that will be used in documentation, presentations and research.
Conceptual schema, ER diagrams and Process Diagrams
Database modifications (migrate your database from one DBMS to another one (Example: from Mysql to Access)
Fix Database bugs
Insert random data into your database for testing cases
Normalize your Database
Test your database functionality
Database implementation (create Tables, relations and views) and SQL scripts using:
MS Access
MySQL
SQL Server
PostgreSQL
Oracle
IBM DB2
SQLite
PL/SQL scripts: Functions, Triggers, Stored Procedure
Explaining How to:
Install any of Database management system (DBMS):
Backup, Restore, import and export database
Create database schema and draw DB design diagram
Create Tables and constrains; primary key, foreign key, unique key,..etc
Normalize Database
Create Views and
Create functions
Create Triggers
Create Stored Procedures
