Welcome to a quick sharing of an ERD of a user roles and login system. Are you building your own user login system? Well, a bare essential login system actually only involves email and password… But I am sure you are looking for more, so here it is, a “simple but extended user system” – …
Welcome to a quick sharing of an ERD of an inventory management system. I am pretty sure there are already plenty of such “free inventory ER diagrams” everywhere on the Internet. So instead of going in the same direction, here’s my simple version for beginners. Hope this helps to speed up your design process. Read …
Inventory Management System ERD (Simple Version) Read More »
Welcome to a quick sharing of an ERD of an attendance management system. Now, “attendance” can cover a wide range of topics – From schools to events to companies, etc… So for this example, let us just fix it to “school”. You can change the entity names in your own project if that is not …
Attendance Management System ERD (Simple Version) Read More »
Welcome to a quick sharing of an ERD of a car rental system. Need to build an online portal for a car rental service? Well, here is my own simple version of the system, hope it helps to speed up your design process. Read on! TABLE OF CONTENTS ER Diagram Table Structure Extra …
Welcome to a quick sharing of an ERD of a hotel reservation system. Need to build a reservation system for a hotel business? Well, it doesn’t have to be complicated – Here is a simple version, hope it helps to speed up your design process. Read on! TABLE OF CONTENTS ER Diagram Table …
Welcome to a quick sharing of an ERD of an online food ordering system. Need to build an online portal for a restaurant? Well, here is my own simple version of the system, hope it helps to speed up your design process. Read on! TABLE OF CONTENTS ER Diagram Table Structure Extra Bits …
Online Food Ordering System ERD (Simple Version) Read More »
Welcome to a quick tutorial and examples on how to calculate the difference between dates in MYSQL – In minutes, days, months, and years. Yes, these are probably the most common questions. How to calculate the difference between 2 dates? How to add or minus days? How many days have passed till today? Let us …
MYSQL Calculate Difference Between 2 Dates (Simple Examples) Read More »
Welcome to a tutorial and examples on how to do MySQL search queries. Yes, this is a very common question and pitfall among beginners. How difficult can a SELECT query be? Not so straightforward, apparently. There are 3 common ways to do search queries in MySQL Exact match search (get all records that match the …
Welcome to a short tutorial on how to measure the time taken to execute a query in MYSQL. So just how long did a query take to run in MYSQL? Which query is better and faster? There are actually quite a number of ways to measure and benchmark queries in MYSQL: The simplest way is …
Welcome to a tutorial on how to import SQL files. So you have downloaded an SQL file from the Internet, and don’t know how to import it? There are 3 common ways to import an SQL file into the database: The easy way to import a SQL file without having to install any tools to …
3 Ways To Import SQL File In MySQL (Step-By-Step Guide) Read More »
