SQL & Others

Welcome to a sharing of an ERD of a car dealership system. So you have taken on a project for a car dealership, or have to deal with this as a school assignment? Well, here is a sharing of my simple version – Read on!     TABLE OF CONTENTS ER Diagram Table Structure Extras […]

Welcome to a sharing of an ERD of a call center management system. So you have taken on a call center project, or got this as a school assignment? Well, here is a sharing of my simple version – Read on!     TABLE OF CONTENTS ER Diagram Table Structure Extras The End   ER

Welcome to a sharing of an ERD of an online appointment system. Yes, there are plenty of such “appointment system ERDs” all over the Internet. But they all seem to be fixed to doctor appointments. So here’s my own version, one that I try to keep as general as possible – Read on!    

Welcome to a sharing of an ERD of a blogging website. So you are planning to build your own blog or CMS? Or maybe you are just curious about what goes on behind one? Well, here’s a sharing of my “simple version”, hope it helps to speed up your design process. Read on!    

Welcome to a sharing of an ERD of an eCommerce website. So you are planning to build your own eCommerce website? Or just curious what goes on behind one? Well, here’s my “not a janky school project” version, hope it helps to speed up your design process. Read on!     TABLE OF CONTENTS ER

Welcome to a quick sharing of an ERD of an online auction bidding system. Planning to start your own auctioning website or business? Here’s a simple version that you can get some inspiration from – Read on for the example!     TABLE OF CONTENTS ER Diagram Table Structure Extras The End   ER DIAGRAM

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 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 Extras The

Welcome to a quick sharing of an ERD of an advertisement management system. But before we start, there are quite a few different “types of advertisements” these days – Digital, billboard, video, flyers, brochures, etc… So just a quick disclaimer, we are not just talking about “online advertisements” here. Read on for the example!  

Welcome to a sharing of an ERD of a movie booking system. So you are planning to build a system for a movie theater? Or maybe you are just stuck with this as a school project? Well, here’s a sharing of my “simple version”, hope it helps to speed up your design process. Read on!