ICT, Database, Linux & eLearning

 Preface This blog is intended to provide an option for full stack development using the LAMP, XAMP or WAMP stack with MariaDB as the backend for RDBMS MIS application development. RDBMS Logical Design The following QuickDBD website offers a good online application that will help you draw database diagrams quickly. It also offers an online tool for you to create a logic model of your database system and it also can automatically generate an SQL statement to create that database in your SQL database. QuickDBD FAQ   Install XAMPP Download and install Apache XAMPP for your operating system from their website following their installation instructions. You may encounter installation problems if you are using Windows 11. This will mainly be related to port conflicts. Windows 11 may be using port 80 for IIS. If this is the case and an error warning is issued from the XAMPP control panel then you could change the port to 8012 or some other unused port. If you are unfamiliar you can ch...

 Termux is a free and open-source emulator for Android which allows for running a Linux environment on an Android device. The link below is a YouTube tutorial on using Termux to support a MariaDB server with phpMyAdmin. Termux phpMyAdmin I am using Termux on my mobile and tablet to install and test MariaDB, Python, SQL, etc. in addition to my PC. So far I have been able to install Termux from Google Play Store, install MariaDB and phpMyAdmin and am able to use it with a browser to work on the database via the localhost. The following tutorial outline the steps I used.  I was unable to install Termux on Bluestacks (Android simulator) in Win 11 on my laptop. Step 1 - Install Termux on your mobile device from Google Play Store and > Open the application. At the  - $ prompt enter: apt update && apt upgrade -y Next enter - $ apt install php mariadb phpmyadmin -y Your current working directory is the termux home directory. Go to the root directory/file system dir wit...

MIS (Management Information System) and ERP (Enterprise Resource Planning) systems are both types of information systems that play important roles in managing and organizing business operations. While there is a relationship between MIS and ERP systems , they are not the same thing and serve different purposes within an organization. What is MIS? MIS refers to a broader concept that encompasses the use of technology, people, and processes to gather, store, analyze, and disseminate information for effective decision-making and management of an organization. MIS focuses on providing managers with the necessary information and reports to support their decision-making processes at various levels of the organization. What is ERP? On the other hand, ERP systems are a specific type of enterprise software that integrates various business functions and processes into a unified system. ERP systems typically include modules for different areas such as finance, human resources, supply chain man...

Step 1:  Install MariaDB and PHPMyAdmin in Synology NAS Drive Connect to your Synology NAS Dashboard. Select >  Package Center > MariaDB 10 > Install. Once the database is installed the next time you open Package Center it will show an Open button. Select > Open and note the Enabled TCP/IP connection Port. The default is 3306 but a different port number may be allocated such as 3308. Similarly install phpMyAdmin. If it is installed the button will show Open. To run phpMyAdmin you will need to launch it from your browser to Synology NAS Drive IP Address. The NAS IP Address is shown on the lower right hand corner of the Dashboard under System Health. e.g. LAN1   192.168.1.232 Step 2:  Access phpMyAdmin from your browser To access your phpMyAdmin you need to enter the IP Address of your NAS drive as shown in the Dashboard. You can now Import a csv table from your spreadsheet like the table shown below. You can edit and change records and fields with php...