LEMON BLOG

"CBDB3403 Database Design and SQL Queries" is one of my subject for studies in Open University Malaysia (OUM) and above is the assignment question. Before we began with the database development, the first rule of thumb is to always careful examine to requirement of the assignment's question. With that being said, we can design the database based on the assignment's requirement. Refer above for the extracted assignment's question.

If you've ever wished for an easy way to watch Malaysia's best local TV channels in one place, your wish just came true! LEMON WEB-TV is here to give you seamless access to RTM1, RTM2, TV3, OKEYTV, RTM Sukan, RTM Berita, TV7, and RTM Parliament—all from the comfort of your browser. Whether you're a fan of drama, news, sports, or even live parliamentary debates (yes, some of us enjoy those!), this platform has you covered.

Ever struggled with removing backgrounds from images? We've all been there—spending hours trying to cut out objects manually or dealing with complicated software like Photoshop. But what if I told you there's an easier, faster, and completely free way to do it? Meet LEMON Background Remover—the one-click AI tool that removes backgrounds in seconds!

Ah, Visual Basic 6 (VB6). If you were writing software in the late '90s or early 2000s, you probably have some fond (or maybe traumatic) memories of this classic IDE. Back in the day, VB6 was the go-to tool for rapid application development. It was quick, it was simple, and it let developers build Windows applications without breaking a sweat. Released in 1998, it reigned supreme until Microsoft decided to push .NET and eventually dropped support for it in Visual Studio.

It all started this morning when my friend casually asked, "Hey, can you generate a QR code for me?" No problem, right? I mean, there are tons of free QR code generators online. But here's the catch—many of them come with annoying limitations. Some slap you with scan limits, others try to make you sign up for an account, and the worst ones? They lock your QR code behind a paywall like it's some kind of VIP lounge.

Malaysia is known for its rich and diverse food culture, from Nasi Lemak and Roti Canai to Satay and Char Kuey Teow. With such delicious food available everywhere, it's easy to overindulge and sometimes lose track of our health. That's why having a BMI (Body Mass Index) calculator is essential—it helps you understand your weight category and take steps to maintain a healthy lifestyle.

Creating a comprehensive Solution Requirement Specification (SRS) document is crucial for ensuring that all stakeholders align on the scope, requirements, and expectations of a project. A well-structured SRS outlines the objectives, functional and non-functional requirements, and the necessary workflows to achieve a successful implementation. Below are key steps to drafting an effective SRS document, based on best practices.

Managing monthly finances can be challenging, especially when it comes to calculating deductions for taxes and social security contributions. To make this process easier, a new web application has been developed to help Malaysians calculate their net monthly earnings by factoring in statutory deductions such as PCB (Potongan Cukai Bulanan), SOCSO, EIS, and EPF.

LEMON WEB-RADIO is an innovative online platform that brings Malaysian radio stations directly to the digital world, providing users with an easy and convenient way to enjoy live radio streams. By offering a wide selection of local stations, it captures the essence of Malaysia's dynamic radio culture, showcasing a diverse range of genres from pop and rock to traditional and local music. Whether you're a fan of the latest hits or enjoy nostalgic tunes, LEMON WEB-RADIO ensures there's something for every listener.

LEMON GuitarTabber is a feature-rich web application designed for guitar enthusiasts who want to explore, learn, and play their favorite songs with ease. The platform provides a vast collection of guitar tabs, allowing users to search for songs and view professionally formatted tablature right in their browser. Powered by AlphaTab JS, the app delivers smooth and accurate playback, bringing tabs to life with real-time audio and visual synchronization. Whether you're strumming along to classics or mastering complex solos, LEMON GuitarTabber offers a user-friendly experience for guitarists of all skill levels.

I have developed a web-based application that provides real-time access to Malaysian highway CCTV feeds, making it easier for users to monitor traffic conditions and road situations. This application allows individuals to view live footage from major highways across the country, empowering them with the information they need to make informed travel decisions. By offering seamless access to reliable traffic visuals, it enhances both convenience and road safety for commuters and travelers alike.

The LEMON Port Scanner is a modern, web-based tool designed for professionals, enthusiasts, and anyone needing to perform quick and efficient port scans on IP addresses or domain names. It provides a user-friendly interface and is equipped with features to simplify the often technical task of identifying open ports on a target server. This tool is ideal for network diagnostics, troubleshooting, and gaining insights into port activity for enhanced system security and connectivity.

I have been exploring the features and potential applications of the new Google Cloud Vision API, a powerful tool for analyzing visual data. This exploration led me to develop the LEMON FACE-APP, a simple yet effective application designed to detect and analyze facial expressions. The app focuses on emotions like Happiness, Anger, Sorrow, Surprise, and Confidence, providing a detailed breakdown of the expressions it detects. This has given me an excellent hands-on opportunity to understand the workings of the API and experiment with its capabilities in a practical project.

Maintaining a high Service Level Agreement (SLA) uptime percentage is essential for businesses that rely on digital services. The downtime calculator I use is an indispensable tool for generating accurate and insightful yearly SLA reports. With its ability to compute uptime percentages based on downtime inputs in days, hours, and minutes, this calculator ensures that I have precise metrics to present to stakeholders. It simplifies the process of tracking service performance, enabling me to quickly determine how well my systems are adhering to industry standards and internal benchmarks.

Today marks the beginning of an exciting project: developing a WebTV platform for streaming popular Malaysian television channels. The platform will be integrated directly into a website, allowing users to access their favorite local channels with ease and convenience. This initiative aims to create a centralized space for Malaysians to enjoy their preferred TV programs seamlessly online.