#100DaysOfCodeChallenge

Day 48: Introduction to the MERN Stack

The MERN Stack (MongoDB, Express.js, React.js, Node.js) is one of the most powerful tech stacks for building modern full-stack web applications. It offers a seamless JavaScript-based development experience, making it a top choice for developers and businesses alike. But what makes MERN stand out? Let’s break it down.

Why is the MERN Stack So Popular?

JavaScript Everywhere: Developers can work with a single language across the frontend, backend, and database, reducing complexity and improving productivity.

Fast & Scalable: MongoDB’s NoSQL structure enables rapid data retrieval, Node.js handles thousands of requests efficiently, and React optimizes rendering performance.

Full Flexibility: MERN allows developers to create everything from small apps to enterprise-level solutions, from static sites to dynamic applications.

Huge Community Support: With an extensive ecosystem of libraries, tools, and frameworks, developers can find solutions, templates, and best practices easily.

How the MERN Stack Works

A MERN application follows a structured workflow where all components work together to handle frontend interactions, backend processing, and database management. Here’s how the data flows:

React Frontend – Users interact with the UI. React handles user input and makes API calls.

Express.js & Node.js Backend – Express processes requests, applies business logic, and interacts with the database.

MongoDB Database – Data is stored and retrieved in a flexible, JSON-like format.

API Response Cycle – Data is sent back to React, which dynamically updates the UI.

Real-World Applications of MERN

Many successful startups and enterprises use the MERN stack due to its efficiency. Some common use cases include:

E-commerce Platforms: MERN enables seamless shopping experiences with dynamic product catalogs, real-time inventory updates, and secure payment integrations.

Social Media Applications: Features like user authentication, live updates, and messaging can be efficiently managed using MERN.

SaaS Products: Subscription-based platforms rely on MERN for interactive dashboards and cloud-based functionalities.

Project Management & Collaboration Tools: MERN’s flexibility makes it perfect for building real-time apps like Trello and Notion clones.

Future of the MERN Stack

With JavaScript evolving and frameworks like Next.js and Remix gaining traction, MERN continues to adapt. The integration of serverless functions, GraphQL, and AI-driven automation will further enhance its capabilities.

Ready to start your MERN journey? Stay tuned for Part 2: Setting Up a MERN Project from Scratch!

100daysofcode lebanon-mug

MERN1920×1080 29.6 KB

Day 49: Setting Up the MERN Stack – The Right Way with Vite!

The MERN stack (MongoDB, Express, React, Node.js) is one of the most powerful full-stack combinations. But setting it up right is key! And let’s face it—Create React App is dead . The best way to set up React now is with Vite .

Here’s a step-by-step guide to setting up a full MERN stack project from scratch.

Step 1: Installing Node.js & npm

First, install Node.js from nodejs.org (choose the latest LTS version).

Once installed, check if it’s working by running:
node -v
npm -v

If both return version numbers, you’re good to go .

Step 2: Setting Up the Backend (Express.js)

Now, let’s set up Node.js & Express.

Create a new project folder:
mkdir mern-app && cd mern-app

Initialize a Node.js project:
npm init -y

Install Express:
npm install express

Create a new file called index.js and add this:

javascript

CopyEdit

const express = require('express');  
const app = express();  

app.get('/', (req, res) => {  
    res.send('MERN Backend is running!');  
});  

app.listen(5000, () => {  
    console.log('Server is running on port 5000');  
});  

Start the server:
node index.js

If you see “Server is running on port 5000”, your backend is working!

Step 3: Connecting MongoDB

Now, let’s connect MongoDB. You can use MongoDB Compass (local) or MongoDB Atlas (cloud-based).

Install Mongoose:
npm install mongoose

In index.js, connect MongoDB:

javascript

CopyEdit

const mongoose = require('mongoose');  

mongoose.connect('mongodb://localhost:27017/mernapp', {  
    useNewUrlParser: true,  
    useUnifiedTopology: true  
})  
.then(() => console.log('MongoDB Connected'))  
.catch(err => console.error(err));  

If it logs “MongoDB Connected”, your database is now linked!

Step 4: Setting Up React with Vite

Forget Create React App—Vite is faster and better.

Inside mern-app, create a React app with Vite:
npm create vite@latest client -- --template react

Navigate into the client folder:
cd client

Install dependencies:
npm install

Start the React app:
npm run dev

Your frontend should now be running at localhost:5173!

Step 5: Connecting Frontend & Backend

To allow React to communicate with Express, you need to set up a proxy.

Open client/vite.config.js and add this:

php

CopyEdit

export default defineConfig({  
  server: {  
    proxy: {  
      '/api': 'http://localhost:5000'  
    }  
  }  
});  

Now, React can make API calls to Express without CORS issues!

100daysofcode lebanon-mug

Day 50: Structuring a MERN Project for Scalability

The MERN stack (MongoDB, Express.js, React, Node.js) is great for building full-stack apps, but if your project is poorly structured, it will lead to bugs, messy code, and maintenance nightmares.

A well-structured backend makes your code more scalable, readable, and secure. This post will guide you through structuring your MERN backend properly using the MVC (Model-View-Controller) pattern.

Why Structure Your Backend Properly?
Separation of concerns → Business logic is separate from database & routes
Scalability → Adding features is easy
Better collaboration → Multiple developers can work efficiently
Recommended Folder Structure

/server
├── controllers/ → Handles logic
├── models/ → Defines data structure
├── routes/ → API endpoints
├── middleware/ → Security & validation
├── config/ → Database & environment variables
├── utils/ → Reusable helper functions
├── index.js → Main server file

Models: Defining Data Structure
Models define how data is stored in MongoDB.
Example: User Model (models/User.js)
Defines user schema
Encrypts passwords
Adds timestamps automatically

const mongoose = require(‘mongoose’);
const UserSchema = new mongoose.Schema({
name: { type: String, required: true },
email: { type: String, required: true, unique: true },
password: { type: String, required: true },
role: { type: String, enum: [“user”, “admin”], default: “user” }
}, { timestamps: true });
module.exports = mongoose.model(“User”, UserSchema);

Controllers: Handling Business Logic
Controllers process requests and interact with models.
Example: User Controller (controllers/userController.js)
Registers a user
Hashes passwords
Handles login authentication

const User = require(‘…/models/User’);
const bcrypt = require(‘bcrypt’);
const jwt = require(‘jsonwebtoken’);
exports.registerUser = async (req, res) => {
try {
//Code Logic Here
} catch (error) { res.status(500).json({ error: error.message }); }
};

Routes: Managing API Endpoints
Routes define API paths and call controllers.
Example: User Routes (routes/userRoutes.js)
Links API endpoints to controllers
Keeps routing separate from business logic

const express = require(‘express’);
const { registerUser, loginUser } = require(‘…/controllers/userController’);
const router = express.Router();
router.post(‘/register’, registerUser);
router.post(‘/login’, loginUser);
module.exports = router;

Bringing It All Together: The Main Server File (index.js)
Loads environment variables
Connects to MongoDB
Sets up routes

image22000×1500 41.5 KB

100daysofcode lebanon-mug

Day 51: Securing Your Node.js Application: Best Practices for Environment Variables, Authentication, and Middleware Security

In today’s digital landscape, security is non-negotiable. Whether you’re building a small side project or an enterprise-level application, securing your Node.js application should be a top priority. Exposing sensitive credentials, neglecting authentication protocols, or ignoring middleware security can lead to devastating consequences, including data breaches and unauthorized access.

In this guide, we’ll explore three crucial aspects of Node.js security:

Environment Variables: Keeping Credentials Safe

One of the most common security mistakes developers make is hardcoding sensitive credentials directly into their source code. Exposing database connection strings, API keys, or secret tokens in your codebase is a major security risk.

Use .env Files to Store Secrets

A better approach is to use environment variables. The dotenv package allows you to load environment variables from a .env file into process.env.

Install dotenv:

npm install dotenv

Configure dotenv in your application:

require(‘dotenv’).config(); const mongoURI = process.env.MONGO_URI;

This ensures that sensitive data is never exposed in your repository. Best practice: Add .env to .gitignore to prevent it from being committed.

Secure Authentication & Authorization with JWT

Authentication ensures that users are who they claim to be, while authorization determines what they can access. A widely used method for secure authentication in Node.js applications is JSON Web Tokens (JWT).

Install JWT:

npm install jsonwebtoken

Generate a JWT Token

When a user logs in, issue a signed token that can be used for subsequent requests. const jwt = require(“jsonwebtoken”); const token = jwt.sign({ userId }, process.env.JWT_SECRET, { expiresIn: “7d” });

Middleware to Verify JWT

To protect routes, use a middleware function to validate JWTs before processing requests. Check the picture for relavent code.

Protecting Routes

Use the authentication middleware to secure sensitive routes.

Middleware Security: Helmet & CORS

Middleware plays a crucial role in securing your Node.js application by protecting it from common web vulnerabilities.

Helmet: Secure HTTP Headers

Helmet helps protect your app by setting various HTTP headers that prevent cross-site scripting (XSS), clickjacking, and other attacks.

Install Helmet:

npm install helmet

Use Helmet in Your App:

const helmet = require(“helmet”); app.use(helmet());

CORS: Controlling Cross-Origin Requests

Cross-Origin Resource Sharing (CORS) determines how your web app handles requests from different domains. By default, browsers block cross-origin requests, but in some cases, you may need to allow them.

Install CORS:

npm install cors

Configure CORS:

const cors = require(“cors”); app.use(cors({ origin: “https://yourfrontend.com” }));

auth726×632 32.7 KB

100daysofcode lebanon-mug

Day 54 | Understanding CORS: Why Your API Might Be Rejecting Requests

Ever tried to fetch data from an API, only to see a frustrating error in the console—something about “CORS policy” blocking your request? If you’re developing web applications, you’ve likely encountered this issue. Let’s break it down.

What is CORS?
Cross-Origin Resource Sharing (CORS) is a security mechanism implemented by web browsers that controls which domains can access resources on a server. By default, browsers enforce the Same-Origin Policy (SOP), which blocks requests between different origins to prevent malicious attacks.

Origin? In the web context, an “origin” is defined by three components:
Protocol (HTTP or HTTPS)
Domain (e.g., example.com)
Port (e.g., :3000 for development)

If any of these differ between the frontend and backend, the request is considered cross-origin and may be blocked unless explicitly allowed.

How CORS Works
When a browser sends a cross-origin request, it checks whether the server allows such requests by including special CORS headers in the response.

If the response contains Access-Control-Allow-Origin: * (or the specific requesting domain), the browser permits the request.
Otherwise, the request is blocked, leading to the infamous CORS error.

Types of CORS Requests
Simple Requests – Directly sent without a preflight check (e.g., GET requests without custom headers).
Preflight Requests – When using POST, PUT, DELETE, or custom headers, the browser first sends an OPTIONS request to check if the actual request is allowed.

Fixing CORS Issues
If you’re dealing with CORS errors, here are some common solutions:
Server-Side Configuration: Modify the backend to allow cross-origin requests using appropriate headers, e.g.,
Access-Control-Allow-Origin: [your frontend url]
Access-Control-Allow-Methods: GET, POST, PUT
Access-Control-Allow-Headers: Content-Type

Use a Proxy: If modifying the backend isn’t an option, configure a proxy on your frontend (e.g., in webpack.config.js or API Gateway).

CORS Middleware: If using Express.js, add:
javascript
const cors = require(‘cors’);
app.use(cors({ origin: '[your frontend url] });

Final Thoughts
CORS isn’t a bug—it’s a security feature. Understanding how it works helps in designing secure, scalable web applications without unnecessary headaches.
Have you run into CORS issues before? Let’s discuss your workarounds in the comments!

100daysofcode lebanon-mug

Day 55: RTK Query & Store.js: Simplifying API State Management in Redux Toolkit

Modern React applications need efficient data fetching and caching. Instead of manually managing API calls with useEffect and useState, RTK Query simplifies this by integrating API state directly into Redux Toolkit.

What is RTK Query?
RTK Query is a data-fetching and caching tool within Redux Toolkit. It automates caching, refetching, and state updates, making API interactions more efficient.

Configuring Redux Store (store.js)
To integrate RTK Query, the Redux store is configured with configureStore, where the API service is added to the reducers and middleware.
Example: The store includes authApi.reducerPath in the reducers and appends authApi.middleware to handle caching and async requests efficiently.

Defining an API Service
A typical RTK Query API service uses createApi, specifying a base URL and defining API endpoints. These endpoints can be queries (for fetching data) or mutations (for sending data).
For example, an authentication API service might have:
A mutation for logging in (loginUser) that sends a POST request.
A query for fetching user details (getUserProfile).
RTK Query automatically generates React hooks for these, such as useLoginUserMutation and useGetUserProfileQuery, making it easy to interact with APIs in components.

Using RTK Query in Components
Once the API service is set up, these hooks can be used in React components. Calling useLoginUserMutation triggers a login request, while useGetUserProfileQuery automatically fetches user data and handles loading and error states.

Why Use RTK Query?
Reduces Boilerplate: No need for managing state, useEffect, or additional API handling.

Automatic Caching & Re-fetching: Avoids redundant API calls and keeps data fresh.

Built-in Error Handling: Simplifies network request management.
By structuring the Redux store with RTK Query, applications become more scalable, maintainable, and performant, ensuring a better developer and user experience.

100daysofcode lebanon-mug

Day 56 | Mastering React Router: Navigating the Web Like a Pro

Building a seamless single-page application (SPA)? Then React Router should be your best friend. It’s the go-to library for managing navigation in React apps, ensuring users move between views effortlessly without full-page reloads.

But here’s the catch—many developers underutilize or misconfigure React Router, leading to sluggish performance, broken navigation, or confusing user experiences. Let’s break down some key insights:
React Router: The Core Features You Need to Know
Dynamic Routing: Unlike traditional static routing, React Router uses component-based routing, meaning routes are determined at runtime, adapting dynamically.
Nested Routes: Components can have child routes, keeping your UI structured and your code organized. Example:

jsx
<Route path=“/dashboard” element={}>
<Route path=“settings” element={} />

Protected Routes: Need authentication before accessing certain pages? Wrap your routes in a higher-order component (HOC) to check for user permissions.
URL Parameters & Query Strings: Fetch dynamic data based on URL parameters.
jsx
Copy code
<Route path=“/profile/:userId” element={} />
Then access userId using useParams().
Lazy Loading with Suspense: Speed matters. Load components only when needed using React.lazy().

jsx
const Dashboard = React.lazy(() => import(“./Dashboard”));

Common Mistakes That Slow You Down
Using Hash Routing When You Don’t Need It
Unless you’re building for legacy browsers, stick with BrowserRouter for clean URLs.
Forgetting Instead of in v6+
If you recently upgraded, remember Switch is deprecated—use Routes instead.
Not Handling 404s Properly
Always include a wildcard route for unmatched paths:

jsx
<Route path=“*” element={} />

The Bottom Line
React Router is more than just “links and paths”—it’s a powerful tool that can make or break user experience. Optimize routing logic, leverage performance boosters, and avoid common pitfalls to build apps that feel fluid and intuitive.

What are your biggest challenges with React Router? Drop your thoughts below!

100daysofcode lebanon-mug

Day 57 | The Problem with Vibe Coding: Why Students Should Still Learn to Code

There’s a growing narrative that students shouldn’t bother learning to code because AI can do it for them. This idea, often disguised as “vibe coding” (where people rely on AI-generated code without understanding how it works), is dangerous. The reasoning? Just as calculators perform math, kids don’t need to learn arithmetic, right? Wrong.

Learning to Code is Not About Typing Code

People misunderstand the purpose of coding education. It’s not about memorizing syntax—it’s about problem-solving, logic, and breaking down complex tasks. Great developers aren’t just code generators; they are problem solvers who understand system design, efficiency, and optimization.

Just because an AI can generate code snippets doesn’t mean it can build maintainable, scalable, and secure software on its own. If students rely on AI without understanding the underlying logic, they become copy-paste engineers, not actual software engineers.

The Future of Software Engineering is Changing—But Not in the Way You Think

Yes, AI is evolving. Yes, AI-assisted coding (GitHub Copilot, ChatGPT, etc.) is making development faster. But rather than replacing programmers, AI is augmenting them.

AI is great at: Generating boilerplate code Suggesting fixes for common errors Speeding up development workflows

But it’s terrible at: Understanding the business logic behind software Debugging complex, system-wide issues Writing code that is reliable and secure without human oversight

Andrew Ng, one of the most respected AI researchers and professors, shares this viewpoint: AI isn’t replacing programmers—it’s making them 10x more effective. But to take advantage of this, developers need strong fundamentals.

Telling Students “Don’t Learn to Code” is Bad Advice

Imagine telling an aspiring writer not to learn grammar because spellcheck exists. Or telling a surgeon they don’t need anatomy because robotic assistants exist. It’s the same logic when people argue students shouldn’t learn to code.

Yes, AI-generated code is impressive. But without foundational knowledge, how do you know if that code is efficient, secure, and actually works?

The best engineers of the future won’t just know how to code. They’ll know how to think in code—leveraging AI as a tool, not a crutch.

The bottom line? Students should absolutely keep learning to code. But they should also learn how to code with AI, not instead of AI.

What’s your take on AI-assisted coding? Is it making people better engineers or just making them dependent on AI? Let’s discuss!

100daysofcode lebanon-mug

Day 58: Mastering Backend Testing with Postman

One of the most powerful tools in a developer’s arsenal is Postman. It helps track down the source of issues by simulating API requests and verifying responses before integrating with the frontend. Let’s break down how Postman makes backend testing efficient and how to seamlessly transition from backend to frontend testing.

How Postman Simplifies Backend Testing
Postman is more than just an API testing tool—it’s a comprehensive platform that can be used to test endpoints, validate responses, and debug issues. Here’s how it helps identify the root cause of bugs:

1. Isolate Backend Issues Early
   By directly hitting backend APIs, you can determine whether an issue is rooted in the backend or arises from frontend integration. For instance, if an API call fails in Postman but works on the frontend, the issue likely lies in how the frontend handles the response.

2. Test with Precision and Efficiency
   Instead of blindly navigating the entire system, use Postman to make precise API calls with various inputs and observe how the backend responds. This saves time and gives clarity on where the problem originates.

3. End-to-End API Testing
   Postman supports testing complete user flows by chaining multiple API requests. This is particularly useful when simulating multi-step processes such as user registration and login.

Best Practices for Effective Testing
To make your testing organized and effective, here are some essential practices:

1. Organize Endpoints with Collections
   Group your endpoints into collections based on functionality:
   User Management Collection: Test all user-related endpoints like registration, login, and profile updates.

Product Management Collection: Group product CRUD operations.
Order Processing Collection: Include endpoints related to placing and tracking orders.

By structuring your collections this way, you’ll maintain clarity and make it easier to test related endpoints in bulk.

2. Follow the Happy Path First
   Start by testing the happy path—the optimal scenario where everything works as intended. Once validated, move on to edge cases and negative testing to see how the system handles unexpected inputs.

3. Use Environment Variables
   Instead of hardcoding URLs or credentials, use environment variables. This makes it simple to switch between development, staging, and production environments without manually editing every request.

4. Automate with Test Scripts
   Postman’s scripting feature allows you to run assertions after every request. For instance:
   javascript
   pm.test(“Status code is 200”, function () {
   pm.response.to.have.status(200);
   });

This simple script checks that the response status is 200 OK and alerts you if it’s not, making error tracking more manageable.

5. Document Your Tests
   Good documentation not only helps you but also your team. Add descriptions to your requests and collections to explain their purpose and how to use them.

100daysofcode lebanon-mug

postman762×926 55.4 KB

Day 59 | Understanding Different SWE Career Paths

Breaking into software engineering can be overwhelming, especially with roles like backend, frontend, full-stack, DevOps, mobile, and data engineering. Understanding the differences early on can set you up for success in interviews and unlock better opportunities.

Why Does It Matter? Imagine preparing for a backend engineering role by mastering frontend frameworks—sounds counterproductive, right? Knowing the differences helps you focus your learning and prep strategically. Each role demands unique skills and coding practices, and understanding them can save you time and effort.

Backend Engineers: Leetcode Kings Backend engineers handle logic and data management. They master algorithms and data structures (Leetcode is essential) and work with languages like Python, Java, or Go. System design and scalability are crucial skills. Focus on complex problem-solving and competitive programming.

Frontend Engineers: UX Artists Frontend engineers bring visual elements to life and ensure smooth user interaction. They excel in HTML, CSS, JavaScript frameworks (React, Angular), and UI/UX design. Interviews often test dynamic interfaces and DOM manipulation.

Full-Stack Engineers: Versatile Builders Full-stack engineers handle both frontend and backend tasks. They know frameworks like MERN or LAMP, API design, and integration. Interviews cover building full applications and bridging client-server logic.

DevOps Engineers: Deployment Experts DevOps engineers maintain smooth software deployment and CI/CD processes. They master tools like Docker, Jenkins, and cloud platforms (AWS, GCP). Be ready to discuss automated testing and server reliability.

Mobile Engineers: App Builders Mobile engineers develop apps for iOS and Android using Swift, Kotlin, or cross-platform frameworks (Flutter, React Native). Key topics include performance optimization and hybrid vs. native approaches.

Final Thoughts Understanding software engineering roles early on gives you a major edge. Target your learning, build relevant projects, and practice role-specific interview questions. Master the right skills to become the software engineer you aspire to be!

100daysofcode lebanon-mug

Day 60 | Boost Performance Without Breaking the Bank: Server Optimization Tips for SWE

When your application starts slowing down, the knee-jerk reaction is to pay for more server space. But why not first squeeze every bit of performance out of your existing setup? Here’s a technical deep dive into some crucial optimizations that can make a world of difference before you open your wallet.

1. Indexing Matters
   Poor indexing is one of the primary culprits behind sluggish database queries. Before investing in bigger servers, take a close look at your database schema:
   Create Indexes on Frequently Queried Fields: Identify columns that are frequently involved in WHERE, JOIN, and ORDER BY clauses.
   Composite Indexes: Combine multiple columns when they are commonly used together.
   Clustered vs. Non-Clustered: Choose wisely based on your data retrieval patterns.
   Regularly Update Statistics: Keep the query optimizer informed about data distribution.

2. Optimize Your Queries
   Even well-indexed databases can struggle if your queries are inefficient.
   Use Query Profiling Tools: PostgreSQL’s EXPLAIN, MySQL’s EXPLAIN ANALYZE, or SQL Server’s Query Analyzer are invaluable.
   Minimize Select Statements: Instead of SELECT *, specify only the columns you need.
   Avoid Subqueries When Possible: Use joins or common table expressions (CTEs) instead.
   Batch Your Updates: Instead of executing multiple small updates, combine them into one.
   Prepared Statements: Leverage them to improve performance and security.

3. Caching Is Your Best Friend
   If your application constantly retrieves the same data, you’re wasting server resources. Implement caching at multiple levels:
   In-Memory Caching: Use Redis or Memcached for rapid data retrieval.
   HTTP Caching: Leverage response caching and cache headers for static resources.
   Application-Level Caching: Cache expensive computations and frequently accessed data.
   Database Query Caching: Store the results of common queries.

4. Efficient Data Storage
   Bloated databases can drastically slow performance. Keep your data lean and mean:
   Archive Old Data: Move less frequently accessed data to cheaper storage solutions.
   Partitioning: Split large tables to reduce the scanning effort.
   Data Compression: Compress old logs and rarely accessed datasets.
   Garbage Collection: Periodically clean up temporary tables and expired data.

5. Load Balancing and Traffic Distribution
   If your application is highly trafficked, distributing the load can significantly improve performance:
   Reverse Proxying: Use NGINX or HAProxy to balance incoming requests.
   Horizontal Scaling: Add more instances rather than increasing individual server specs.
   Content Delivery Networks (CDN): Serve static assets from edge locations for quicker delivery.

Stay tuned for a part 2!

100daysofcode lebanon-mug

Day 62 | Kickstarting My SQL Series: The Foundation of Data Modeling with the ER Model!

Hey #LinkedInCommunity! Excited to launch my SQL series with a deep dive into one of the most fundamental concepts in database design—the Entity-Relationship (ER) Model!

Where It All Began

The ER model was introduced in 1976 by the brilliant Professor Peter Chen (Chen Pin-Shan) . His groundbreaking paper laid the foundation for how we visualize and structure data relationships today. Before ER, database design was more abstract—Chen gave us a clear, graphical way to map entities, attributes, and relationships.

Why Does the ER Model Matter?

Visual Clarity : It turns complex data structures into easy-to-understand diagrams.

Blueprint for Databases : Serves as the first step before writing SQL schemas.

Improves Efficiency : Helps spot design flaws early, saving time and headaches later.

Key Components

Entities → Real-world objects (e.g., Customer, Product)

Attributes → Properties of entities (e.g., CustomerID, ProductName)

Relationships → How entities interact (e.g., Customer buys Product)

Stay tuned for Part 2, where we’ll translate ER diagrams into SQL tables!

Discussion Time!

How has the ER model helped you in your projects?

Any database design challenges you’ve faced?

#sql 100daysofcode lebanon-mug

Day 63 |:mag: Mastering Weak Entity Sets, Cardinalities, Specialization & Generalization in Databases!

Data modeling is the backbone of efficient databases, and understanding key Entity-Relationship (ER) model concepts is crucial. Let’s break down four essential concepts:

Weak Entity Sets
Not all entities are independent! Some lack a primary key and must rely on a strong entity through a relationship set. These are called weak entity sets and must have:
A discriminator (partial key) to differentiate among instances.
A total participation constraint, meaning they must be linked to a strong entity.
A supporting relationship, called an identifying relationship, that connects them to a strong entity.
Example: Consider an Employee-Dependent relationship. A Dependent (child/spouse) doesn’t have a unique identifier but can be identified using Employee_ID + Dependent_Name. Without linking to an Employee, the Dependent entity has no existence in the database.

Cardinalities & Relationship Constraints
Cardinality defines how many instances of an entity can be related to another. Understanding this ensures data integrity and efficient queries.
Types of Cardinality:
One-to-One (1:1): Each entity in A maps to at most one entity in B.
Example: A person has one passport, and each passport belongs to one person.
One-to-Many (1:M): An entity in A maps to multiple entities in B.
Example: A manager supervises multiple employees, but each employee has only one manager.
Many-to-Many (M:N): Each entity in A relates to multiple entities in B, and vice versa.
Example: Students enroll in multiple courses, and each course has multiple students.

Specialization vs. Generalization
As databases grow, organizing data becomes vital. This is where specialization and generalization help refine entity structures.
Specialization (Top-Down Approach):
We start with a generic entity and divide it into sub-entities based on distinguishing characteristics.
Example: A Vehicle entity specializes into Car and Bike . Cars have a fuel type, while bikes may not.
Generalization (Bottom-Up Approach):
Here, we merge multiple similar entities into a higher-level super-entity to avoid redundancy.
Example: A Doctor and a Nurse share common attributes (e.g., Name, Salary), so they generalize into MedicalStaff.
Why Does This Matter?
Weak entity sets prevent orphaned data in relationships.
Cardinalities enforce integrity, ensuring logical data mapping.
Specialization adds precision, while generalization reduces redundancy.

Mastering these concepts leads to better data normalization, query performance, and scalability!

Which of these have you used in your projects? Drop your thoughts in the comments!

100daysofcode lebanon-mug

Picture13690×3046 273 KB

Day 64: Understanding the Relational Model and Ensuring Consistency

Databases are everywhere, powering applications that range from social media platforms to financial systems. But how do we make sure that the data inside them is reliable, consistent, and useful? Today, we’re diving into the relational model, one of the most robust ways to manage structured data. We’ll also explore how to maintain database consistency—a critical aspect that ensures your data remains trustworthy.

Relational Model Basics

The relational model, introduced by E. F. Codd in 1970, revolutionized data storage by structuring data into tables (relations). It offers a logical way to represent data independently from the physical storage. Let’s break down the essential terms in both informal and mathematical contexts:

The relational model is fundamentally about relations (or tables), where each relation consists of tuples (or rows), each described by a set of attributes (or columns). The domain of an attribute defines its possible values, like numbers or strings.

Consistent vs. Inconsistent Databases

Let’s say you manage a database of student records. A consistent database might have a student with ID 123 listed as “John Smith” in both the Enrollment and Grades tables. An inconsistent database could show the same ID linked to two different names across these tables. Such inconsistencies are more than just nuisances—they can undermine trust and break system functionality.

Maintaining Database Consistency

Maintaining consistency is crucial to ensure that data across tables and applications remains accurate and reliable. Here are some key techniques:

1. Normalization

Breaking data into smaller, non-redundant tables reduces the chances of inconsistency. Normalization ensures that one piece of information is stored only once.

2. Constraints

Apply integrity constraints like primary keys, foreign keys, and unique constraints to enforce data consistency. This means that records are uniquely identified and linked properly between tables.

3. ACID Properties

Database transactions should follow ACID (Atomicity, Consistency, Isolation, Durability) principles to ensure that operations either complete successfully or leave the database unchanged. This is especially important when performing multiple updates or batch operations.

4. Data Validation

Validate data both at the application level and database level. Use triggers or check constraints to automatically verify data before insertion or update.

5. Backup and Recovery

Maintaining consistency also involves periodic backups and implementing recovery mechanisms. This helps revert to a previous consistent state in case of system failures.

Common Pitfalls

1. Circular References: Linking tables in a circular way can result in inconsistencies and difficulties in maintaining data integrity.
2. Improper Use of NULL: Overuse or misuse of NULL values can lead to ambiguity in data interpretation.
3. Schema Drift: Unplanned changes to the database schema can introduce inconsistencies.

Key Takeaways

Maintaining a consistent database is not just about technical correctness but also about maintaining data integrity and trustworthiness. By understanding the relational model and implementing consistency practices, you can build reliable and scalable systems.

Got thoughts on relational models? Share your experiences or challenges in the comments below!

100daysofcode lebanon-mug

Day 65 | SQL Basics: Schema, Tables, Primary & Foreign Keys Explained!

In the world of SQL, structuring your data efficiently is the key to building scalable and organized databases. Whether you’re just starting out or brushing up on your skills, understanding schemas, tables, primary keys, and foreign keys is crucial! Let’s dive into the essentials!

Schema

A schema is like a container for your database objects - think of it as an organizational unit! It holds tables, views, and other objects, allowing for better structure and access control.

Imagine you’re managing a company database. You might have a schema named CompanyDB to hold all related tables, such as employees, departments, and projects.

Syntax:

sql

CREATE SCHEMA CompanyDB;

Tables

Tables are where your data lives! They consist of rows and columns, each column having a specific data type (like INTEGER, VARCHAR, or DATE).

For example, in our company database, we might have:

Employee table for personal details

Dependent table for employee dependents

Department table for different departments

Project table for ongoing projects

WorksOn table to track which employee works on which project

Syntax:

sql

CREATE TABLE Employee (

emp_id INT PRIMARY KEY,

first_name VARCHAR(50),

last_name VARCHAR(50),

dept_id INT

);

Primary Key

A primary key uniquely identifies each row in a table. No two rows can have the same primary key, ensuring data integrity.

In the Employee table, the emp_id column is the primary key, making each employee uniquely identifiable.

Syntax:

sql

PRIMARY KEY (emp_id)

Foreign Key

A foreign key creates a link between two tables. It enforces relationships and maintains referential integrity between data. For instance, the WorksOn table needs to link employees to projects.

Syntax:

sql

CREATE TABLE WorksOn (

emp_id INT,

proj_id INT,

hours_worked DECIMAL(5,2),

FOREIGN KEY (emp_id) REFERENCES Employee(emp_id),

FOREIGN KEY (proj_id) REFERENCES Project(proj_id)

);

Example: Database Design

Here’s how the design fits together:

Employee table holds employee data.

Dependent table stores employee-dependent details.

Department table keeps department info.

DepLocation table tracks where departments are located.

Project table holds project details.

WorksOn table records which employees are assigned to which projects.

These tables are linked through primary and foreign keys, creating a robust relational database that minimizes redundancy!

Why It Matters

Efficient database design helps maintain data consistency and integrity. By leveraging schemas and relational keys, you’re building a scalable structure that can grow with your data needs.

Whether you’re a beginner or a pro, mastering these SQL fundamentals will set you up for success. Happy coding!

100daysofcode lebanon-mug

sql2250×1345 166 KB

Day 66 |:rocket: Overcoming Imposter Syndrome as a Junior Software Engineer

Let’s talk about something many of us in tech rarely say out loud: Imposter Syndrome. That nagging feeling that you’re not good enough, that you don’t belong, or worse — that someone’s going to “find out” you’re faking it.

As a junior software engineer, I’ve felt it. You’ve probably felt it.

Why It’s So Common in Tech

Software engineering moves fast. Every day there’s a new framework, a new best practice, or a GitHub repo that makes you question your existence.

We work in environments that often reward output over learning, and it’s easy to feel like you’re falling behind — especially when:

You’re struggling to understand legacy code

You can’t fix a bug after 3 hours of trying

Everyone seems to “get it” except you

Spoiler: They don’t. They’re just googling faster.

Imposter Syndrome ≠ Incompetence

In fact, feeling like an imposter is often a sign of growth. You’re challenging yourself. You’re out of your comfort zone — and that’s where learning happens.

But it can be paralyzing if left unchecked.

What Actually Helps

Talk About It

Open up to teammates, mentors, or LinkedIn folks. You’ll be surprised how many people feel the same.

Join a CS Club or Tech Community

Seriously, don’t go through this journey alone. Whether it’s a university CS club, a local dev group, or an online community — surrounding yourself with others who are learning, building, and sharing is game-changing. You’ll learn faster, feel less isolated, and stay inspired.

Track Your Progress

Keep a “brag doc” — a list of bugs you fixed, features you shipped, or even concepts you understood better. Watch how far you’ve come!

Ask Questions — Fearlessly

Asking doesn’t make you look dumb. It shows you’re engaged and willing to grow.

Stay Curious & Excited

Let your passion lead you. Tinker with side projects, explore new tech, attend hackathons — curiosity is your superpower. The more excited you stay, the faster the fear fades.

Don’t Compare Your Chapter 1 to Someone Else’s Chapter 20

Your senior might seem like a wizard now, but they were once stuck on their first null pointer exception too.

Practice Self-Compassion

Tech is hard. You’re not supposed to know everything. You’re supposed to learn.

Final Thought

If you’re a junior SWE battling self-doubt, just remember:

You’re not an imposter. You’re a beginner. And beginners grow.

Stay curious. Stay excited. Keep learning. You’ve got this.

100daysofcode lebanon-mug

Day 67 | Why Mastering DSA Still Matters in 2025

Whether you’re building scalable systems, optimizing a product, or cracking the next coding interview — Data Structures & Algorithms (DSA) remain foundational to success in tech. Yet many overlook it, dismissing it as “just interview prep” or “academic theory.” That mindset is costing developers long-term growth.
Here’s why DSA still matters — and why I’m starting this new series:
Problem Solving Muscle
At its core, DSA trains your brain to approach challenges methodically. It’s like going to the gym for your logic — improving how you think, not just what you code.
Real-World Optimization
Understanding time and space complexity isn’t just for whiteboard interviews. It translates directly to efficient code in real-life applications:
• A faster search algorithm in an e-commerce backend
• Memory-optimized data handling for edge devices
• Reduced latency in real-time systems
Systems Design Foundation
Before you scale, you simplify. Before you scale, you structure. Knowing when to use a hash map over a tree or why a heap can outperform a queue — that’s DSA in action. It gives you the building blocks that enable high-level design.
Interview-Ready, Yes — But Career-Ready Too
Mastering DSA isn’t just about passing tech interviews. It’s about having confidence when faced with ambiguous problems and being able to engineer clean, efficient, maintainable solutions.

What’s Next?
In the coming weeks, I’ll be diving into practical DSA topics:
Hidden performance traps in common algorithms
Real-world DSA use cases from backend, frontend, and data
Simplifying complex topics like recursion, graphs, and dynamic programming

100daysofcode lebanon-mug