Pharmacy Management system is a database application that will cater the needs of storing, managing, querying and retrieving pharmacy data needs i.e. managing staff, customer, transaction, product and supplier records. The application is generated by an SQL script and is further beautified manually through Alex app builder.

Build a data warehouse from scratch, including full load, daily incremental load, design schema, SCD Type 1 and 2.