6. Tech used → SQL Server → DDL: CREATE, ALTER, constraints, index → DML: INSERT, UPDATE, soft DELETE, hard DELETE in transaction, MERGE → Queries:JOINs, CASE, DATEDIFF, CAST, COALESCE 🔗GitHub: github.com/babatunde-cp/gran… #SQL #DataAnalytics #DbDesign #Datafam @iam_daniiell

Designed a Clinic Appointment & Diagnostics Platform. ERD covering- -patients -doctors -appointments -consultations -diagnostic -tests -reports -payments Implemented proper normalization, PK/FK relationships #DBDesign #ERDiagram @ChaiCodeHQ @Hiteshdotcom @piyushgarg_dev

I am late , But not the least , Completed all 5 ER diagrams , due to some reason to able to submit it earlier, I enjoyed designing these db's U can check them on github.com/MEHULARORA11/Web-… thnx for this amazing assignment @nirudhuuu shubham sir @Hiteshdotcom #chaicode #DBdesign

Just Completed the IPL DB Design Assignment @surajtwt_ @nirudhuuu @ChaiCodeHQ #ipl #dbdesign

IPL DB design is done 🏏 Improvement suggestions are welcome... @nirudhuuu @ChaiCodeHQ @Hiteshdotcom @piyushgarg_dev @BlazeisCoding @devwithjay @surajtwt_ #chaicode #learninpublic #dbdesign

This IPL system is easily my most detailed design so far: handled many-to-many properly modeled season-based changes separated static vs changing data Not perfect, but finally feels like I understand what I’m building. Would love feedback 🙌 @Hiteshdotcom @nirudhuuu #dbdesign

Another step in backend learning -IPL management database design through system-teams,player,owner,sponsors &more ✨️ #chaicode #dbDesign @ChaiCodeHQ @Hiteshdotcom @nirudhuuu @surajtwt_

Completed the assignment for Smart Elevator Control DB design. @ChaiCodeHQ @nirudhuuu #chaicode #DBDesign

ERD asignment Day 5/5: Designed a Smart Elevator Control System – ER Diagram 🛗 Multi-building support | Elevator–floor mapping (M:N)| Ride requests & allocations | Status & maintenance tracking | Analytics-ready ride logs @ChaiCodeHQ @Hiteshdotcom @nirudhuuu #dbDesign #ERD

Day 5: Smart Elevator Control er diagram, the flow was little bit complicated,took a while to understand would love ur feedback 🤠Really enjoyed doing the db assignments these week @Hiteshdotcom @piyushgarg_dev @nirudhuuu @ChaiCodeHQ @yntpdotme #chaicode #dbdesign

Day 5 DB Design : Smart Elevator Control Last but definitely not the least 😉 Tried to keep it clean and simple for understanding . Feel free to give feedback . @ChaiCodeHQ @Hiteshdotcom @piyushgarg_dev @nirudhuuu #DBDesign

Past few days, having fun in making in ER diagrams.😎 So this is ER design for Smart Elevator Control. 👍 Building -> zones -> shaft -> elevators -> ride Feedback please ? 🫡🫡 #dbDesign @ChaiCodeHQ @Hiteshdotcom @piyushgarg_dev @nirudhuuu #LearningInPublic

Done the Smart Eleveter control DB design . @Hiteshdotcom @nirudhuuu @yntpdotme @ChaiCodeHQ #chaicode #DBdesign #WebDev

Completed all (5/5) db design assignments today. Designed a Smart Elevator Control System managing multiple buildings, elevators, ride requests, maintenance, and usage logs. Thanks to @Hiteshdotcom , @nirudhuuu Sir for their guidance. open to feedback. #DBDesign #PostgreSQL

Done with the last DB design assignment - Smart Elevator Control This was the toughest of all but definitely learned a lot from it. Open to suggestions! @nirudhuuu #backend #dbdesign

Complete new DB design on "Smart Elevator Control" 🛗 Making elevators smarter… one schema at a time. 😄 github.com/SmitaSubudhiDev/d… @ChaiCodeHQ @Hiteshdotcom @nirudhuuu #chaicode #dbdesign Let me know your thoughts 👇

Designed a DB schema for a Smart Elevator System Focused on: • Elevator_Floor (many-to-many) • Request → Assignment → Ride flow • Clean separation of dynamic data Took a few iterations to get it right. Open to feedback. #ChaiCode #DbDesign

Smart Elevator Control quite interesting this was among all, enjoyed the dbDesign series. code - buildings [icon: building, color: blue] { id string pk name string city string created_at datetime } floors [icon: layers, color: blue] { id string pk building_id string fk floor_number int floor_label string } shafts [icon: box, color: green] { id string pk building_id string fk shaft_number string shaft_type string } elevators [icon: upload, color: green] { id string pk shaft_id string fk status string current_floor int capacity_kg int last_serviced_at datetime } elevator_floor_service [icon: git-merge, color: purple] { id string pk elevator_id string fk floor_id string fk } rideRequests [icon: arrow-up, color: orange] { id string pk floor_id string fk direction string requested_at datetime status string } rideAssignment [icon: check-circle, color: orange] { id string pk rideRequest_id string fk elevator_id string fk assigned_at datetime status string } rideLogs [icon: file-text, color: yellow] { id string pk rideAssignment_id string fk elevator_id string fk from_floor int to_floor int started_at datetime ended_at datetime duration_seconds int } maintenanceRequests [icon: tool, color: red] { id string pk elevator_id string fk status string note string scheduled_at datetime resolved_at datetime created_at datetime } maintenanceHistory [icon: clock, color: red] { id string pk maintenanceRequest_id string fk changed_status string changed_at datetime changed_by string remarks string } // Relationships buildings.id <> floors.building_id buildings.id <> shafts.building_id shafts.id <> elevators.shaft_id elevators.id <> elevator_floor_service.elevator_id floors.id <> elevator_floor_service.floor_id floors.id <> rideRequests.floor_id rideRequests.id <> rideAssignment.rideRequest_id elevators.id <> rideAssignment.elevator_id rideAssignment.id <> rideLogs.rideAssignment_id elevators.id <> rideLogs.elevator_id elevators.id <> maintenanceRequests.elevator_id maintenanceRequests.id <> maintenanceHistory.maintenanceRequest_id @Hiteshdotcom @nirudhuuu @ChaiCodeHQ @BlazeisCoding @yntpdotme #chaicode #cohort #dbdesign

Day 4 DB Designing : Comic-Con Parking System This one literally took some effort, but at last completed on time. Feel free to give feedback. @ChaiCodeHQ @Hiteshdotcom @piyushgarg_dev @nirudhuuu #DBDesign

maybe , but will shift to dbdesign from tmrw to make it more clean 👍