Student Projects: From Conversation to Database

Nine classic student projects, each designed from a conversation with the person who needs it: library, school, attendance, hostel, hospital, inventory, hotel, railway reservation and online shop. Entities, relationships, keys and CREATE TABLE scripts run on SQL Server and PostgreSQL, the viva questions answered with real output, the textbook mistake repaired, and an ER diagram for every one.

9 parts · ~63 min of reading, in order, nothing assumed.

Start with Part 1

🔧 Draw your own ER diagram from CREATE TABLE statements 🔧 Check a spreadsheet for normalization problems 🧭 The series this one follows: Conversation to System Design 🧭 The next step after a project: Database Design for Developers

Student Projects: From Conversation to Database · Part 1

Library Management System Database Design: ER Diagram, Tables and SQL

A library database, designed from a talk with the librarian. Copies, members, loans, fines and reservations, with scripts run on SQL Server and PostgreSQL. Oct 16, 2026 7 min read

Student Projects: From Conversation to Database · Part 2

School Management System Database Design: ER Diagram, Tables and SQL

A school database, designed from a talk with the office manager. Sections, teachers, subjects, marks and guardians, scripts on SQL Server and PostgreSQL. Oct 16, 2026 7 min read

Student Projects: From Conversation to Database · Part 3

Attendance Management System Database Design: ER Diagram, Tables and SQL

An attendance database, designed from a talk with HR. Shifts, check-ins, a derived status, leave and holidays, scripts on SQL Server and PostgreSQL. Oct 16, 2026 7 min read

Student Projects: From Conversation to Database · Part 4

Hostel Management System Database Design: ER Diagram, Tables and SQL

A hostel database, designed from a talk with the warden. Blocks, rooms, beds, allotments, fees, mess and complaints, scripts on SQL Server and PostgreSQL. Oct 16, 2026 7 min read

Student Projects: From Conversation to Database · Part 5

Hospital Management System Database Design: ER Diagram, Tables and SQL

A hospital database, designed with its superintendent. Wards, beds, admissions, prescriptions and bills, scripts on SQL Server and PostgreSQL. Oct 16, 2026 7 min read

Student Projects: From Conversation to Database · Part 6

Inventory Management System Database Design: ER Diagram, Tables and SQL

A shop inventory database, designed from a talk with the owner. Products, suppliers, purchases, sales and a stock ledger, scripts on SQL Server and PostgreSQL. Oct 16, 2026 7 min read

Student Projects: From Conversation to Database · Part 7

Hotel Management System Database Design: ER Diagram, Tables and SQL

A hotel database, designed from a talk with the front office. Room types, rates, reservations that cannot overlap, services and bills, on both engines. Oct 16, 2026 7 min read

Student Projects: From Conversation to Database · Part 8

Railway Reservation System Database Design: ER Diagram, Tables and SQL

A railway booking database, designed with the booking office. Routes, coaches, seats, fares, bookings and waitlists, on SQL Server and PostgreSQL. Oct 16, 2026 7 min read

Student Projects: From Conversation to Database · Part 9

Online Shopping System Database Design: ER Diagram, Tables and SQL

An online shop database, designed from a talk with the owner. Variants, carts, orders that keep their prices, shipments and reviews, scripts on both engines. Oct 16, 2026 7 min read

← Learn the stack All series