{"repo":"jfullstackdev/rdb-table-types","free":true,"listed":false,"github":"https://github.com/jfullstackdev/rdb-table-types","clone":"git clone https://github.com/jfullstackdev/rdb-table-types.git","description":"relational database + coding = a dev superpower, so I wrote about what I’ve learned along the way …","language":null,"stars":13,"topics":["data-and-code","database","database-design","database-tables","database-tutorial","rdb","relational-databases"],"license":null,"category":"databases-storage","readme_excerpt":"Relational Database Tables and Relationships Back when I was teaching, I developed an Excel-based System to handle scoring, ranking, and providing insights for competing teams in the school’s Sportfests. Previously, these tasks were manual and time-consuming. I achieved this by leveraging structured tables, filters, sorting, and advanced formulas, occasionally enhanced with macros. At that time, I had neither knowledge of coding nor of databases, nor had I received any formal lessons in them. I never imagined that this would become the core of being a fullstack developer ! This experience was my first exposure to real-world data and sparked my curiosity in programming and database. I quickly realized how powerful data is in the modern world. And this fascination still drives me to this day. --- Before we proceed : This discussion is not a full tutorial on relational tables or database design. It assumes readers already have a basic understanding of tables and relationships. Well, anyways, the lesson might be understood easily since I did not tackle in depth the technical details, so just enjoy reading ! Relational Database Table Types 1. Regular Tables (Entity Tables) These are your main tables representing real-world entities. In an Inventory System, these correspond to all your items. In other domains, such as fintech, these could represent customers, accounts, or transactions. Regular tables store the detailed, raw data that other tables or computations build upon, forming","default_branch":null,"files":null,"tree":[],"storefront":"/r/jfullstackdev","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jfullstackdev/rdb-table-types/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}