Linkedin-Moodle (School Project)

LinkedIn-Moodle is a comprehensive database engineering project that designs a unified relational schema to bridge the gap between professional networking and academic management. It integrates the complex social interactions of LinkedIn with the structured learning environment of Moodle into a single, cohesive system.

The Problem: Disconnected Data Silos

Professional identities and academic achievements often live in separate worlds. Managing this data at scale presents architectural challenges:

• Complex Relationships → Juggling professional connections, organizational hierarchies, and academic enrollments.
• Data Fragmentation → Educational milestones (Moodle) aren't natively linked to professional profiles (LinkedIn).
• Action Tracking → Managing nested interactions like comments on posts, answers to comments, and assignment grades within a single system.
• Referential Integrity → Ensuring that weak entities (like comments or assignments) remain consistent across thousands of records.

The Solution: A Seamless Data Blueprint

I engineered an Enhanced Entity-Relationship (EER) model that serves as a bridge between career and education. This project provides the architectural foundation for a platform where learning and networking coexist.

Core Capabilities:

1. Professional Networking Engine → A robust model for users, organizations, and project tracking with a focus on career history.
2. LMS Integration → Full course management logic, including teacher-student relationships, assignment tracking, and automated grading schemas.
3. Nested Interaction Logic → Specialized handling of "Likable Content" across posts, comments, and answers to ensure high-fidelity social engagement.
4. Optimized Mapping → An iterative relational mapping process that transforms complex EER diagrams into high-performance SQL tables.

Why It Stands Out

• Academic Rigor → Built using advanced database design principles, focusing on normalization and constraint management.
• Weak Entity Mastery → Implemented sophisticated logic for weak entities (Assignments, Comments, Answers) to prevent orphaned data and maintain system-wide integrity.
• Iterative Design → The schema evolved through four distinct iterations, ensuring every relationship was stress-tested for scalability.
• Unified Identity → Creates a "Single Source of Truth" where a user’s SSN links their student identity to their professional profile.

The Impact (Architectural Value)

• Zero Data Redundancy → Achieved through careful normalization and strategic primary/foreign key mapping.
• Scalable Blueprint → Provides a production-ready roadmap for developers building EdTech or HR-Tech platforms.
• High Performance → Designed for efficient querying across deeply nested social and educational data sets.

---

Technical Highlights

The project focuses on Database Systems Engineering and pure SQL architecture:

• Enhanced Entity-Relationship (EER) modeling for high-level conceptual design.
• Relational Mapping to translate visual diagrams into logical schemas.
• Referential Constraints (CASCADE, NOT NULL) to ensure data durability.
• SQL Schema Initialization for automated database setup and testing.

My Role: Database Architect

I led the entire lifecycle of the data architecture design.

• Systems Analysis → Deconstructed the core entities of LinkedIn and Moodle to identify overlapping data points.
• Conceptual Design → Designed the EER diagram from scratch, handling complex M:N and 1:N relationships.
• Logic Implementation → Defined the constraints and triggers required to maintain integrity in a social-academic hybrid environment.
• Documentation → Produced a comprehensive Analysis Report detailing the mapping iterations and system characteristics.

The result? A sophisticated architectural foundation for the next generation of career-first learning platforms.