Data · Databases
Design a database for a hostel or library
Model a real system as tables, normalise it and answer ten questions with SQL.
- DifficultyIntermediate
- Estimated time1–2 weeks
- Budget₹0
- ClassClass 12 to college
- TeamSolo or up to 2
- You needComputer only
Prerequisites: None beyond your class work
Original · by TechnifyedData AnalysisSoftware ProjectFree to doComputer onlyResearch orientedWell documented
Overview
Model a real system as tables, normalise it and answer ten questions with SQL.
Why build this?
Good table design is the foundation of every application, and this project shows you can do it for a real system.
What you will learn
- How to model entities and relationships
- What normalisation removes
- How to write joins
Skills you will use
Materials and tools
- Computer with SQLite or any free database
Tools and software
Step-by-step roadmap
Start
You will finish with: an ER diagram, a schema, sample data and ten working queries.
- 1
Prerequisites
Nothing special to know first. Then collect the 1 item in the materials list.
- 2
Learn
- How to model entities and relationships
- What normalisation removes
- How to write joins
- 3
Plan
List the features for version one, sketch the screens or data flow and pick the tools. Keep the first version small.
- 4
Build
- Interview someone who runs the system and list what must be stored.
- Draw an entity-relationship diagram.
- Normalise to third normal form and create the tables.
- Insert realistic sample data.
- Write ten queries, including joins and grouped totals.
- 5
Test
Try it with wrong, empty and unusual input, and ask someone else to use it without your help.
- 6
Document
Write a README: what it does, how to run it, screenshots and what you learned. Report structure
- 7
Present
Show a live demo of one complete task, then the design and the hardest problem you solved. Presentation structure · Viva questions
- 8
Publish
Put the code on GitHub with the README and, if you can, deploy a live demo.
Expected outcome
An ER diagram, a schema, sample data and ten working queries.
Other versions of this project
Beginner version
Design three tables and write five simple queries.
Advanced version
Add indexes, measure query time before and after, and write two triggers.
Make this project better
- BasicDesign three tables and write five simple queries.
- This projectDesign a database for a hostel or library
- AdvancedAdd indexes, measure query time before and after, and write two triggers.
Ways to do this project
Text marked "You write this" is a prompt for your own work; everything else is specific to this project.
- Research question
- You write thisOne question you can answer with data, narrow enough to finish in the time you have.
- Hypothesis
- You write thisWhat you expect to find, and why.
- Variables
- You write thisWhat you change or compare, what you measure, and what you hold constant.
- Methodology
- You write thisDescribe the method in enough detail that someone else could repeat it: sample, tools, procedure.
- Data collection
- You write thisSay what you will record, how many times, and how you will keep the records safe.
- Analysis
- You write thisChoose the table, chart or test that answers the question; report averages with their spread.
- Limitations
- You write thisList what could have affected the result: small sample, instrument limits, things you could not control.
Literature review
Find five to eight sources (your textbook, review articles, reports) and note what each says about your question. Group them by idea, not one after another, and end with what is still not known.
References
List every source you used in one style throughout (author, year, title, where it was published, link and the date you opened it).
Use this as the outline of your README or case study.
- Problem
- You write thisThe problem in one or two sentences.
- Why it matters
- Good table design is the foundation of every application, and this project shows you can do it for a real system.
- What was built
- An ER diagram, a schema, sample data and ten working queries.
- Technology
- SQL, SQLite
- Architecture
- You write thisOne diagram: the parts and how data moves between them.
- Implementation
- You write thisThe 5 build steps in your own words, with one code or design decision you are proud of.
- Challenges
- You write thisThe hardest bug or decision, and how you got past it.
- Results
- You write thisNumbers: accuracy, speed, users, survey answers.
- Demo and code
- You write thisA link to a live demo or a short video, and to the GitHub repository.
- Lessons learned
- You write thisWhat you would do differently next time.
- Future improvements
- Add indexes, measure query time before and after, and write two triggers.
- Problem
- Model a real system as tables, normalise it and answer ten questions with SQL.
- Target user
- You write thisOne specific person: who they are and when they would use this.
- Solution
- Model a real system as tables, normalise it and answer ten questions with SQL.
- First version (MVP)
- Design three tables and write five simple queries.
- Tech stack
- SQL, SQLite
- Architecture
- You write thisA quick sketch of the parts and how they connect.
- Demo
- You write thisThe one scenario you will show live, start to finish, in under two minutes.
- Stretch goals
- Add indexes, measure query time before and after, and write two triggers.
Team roles
Plan by length
24-hour
- Hours 0–2: agree the problem, the user and the one thing the demo must show
- Hours 2–16: build only the first version
- Hours 16–20: test the demo path end to end and fix what breaks
- Hours 20–24: slides, a 2-minute demo script and a backup recording
48-hour
- Evening 1: problem, user, sketch and task split
- Day 1: first version working end to end
- Day 2 morning: one stretch goal and testing
- Day 2 afternoon: polish, slides and demo practice
1-week
- Day 1: research the problem and talk to two possible users
- Days 2–4: first version
- Day 5: stretch goals
- Day 6: testing and write-up
- Day 7: demo video and presentation
Working as a team
Solo or up to 2. Suggested roles:
Report and presentation
Report structure
- Title and summary
- Problem and target user
- Features
- Tools and technology
- Design: architecture, data model or screens
- Implementation
- Testing
- Results and screenshots
- Challenges
- Future improvements
- References
Presentation structure
- The problem
- Who it is for
- Live demo
- How it is built (one diagram)
- The hardest part
- Testing and results
- What you learned
- What comes next
Viva questions
Try answering before you open each one.
What is a foreign key?
A column that refers to the primary key of another table.
Why normalise?
To avoid storing the same fact in several places.
What is a join?
Combining rows from two tables using a related column.
Resources
Source and attribution
Original
Written by Technifyed. Free to use for your own school or college project; write the report in your own words. Added 1 Oct 2026.
Similar projects
More Data projects
Data + Operations, HR and Supply Chain
Build a sales dashboard
Turn a public retail dataset into a one-page dashboard that answers a manager's questions.
Data + Statistics and Probability
Analyse cricket data to test a common belief
Use ball-by-ball public data to test a claim such as "winning the toss wins the match".
Data · Data Science
Analyse traffic accidents with open data
Use official accident statistics to find when, where and why accidents happen in your state.
Data + Environmental Science
Build a dashboard of your city's air quality
Pull official air-quality readings and show daily, weekly and seasonal patterns.
Same tools
Software Development · Backend
Create a URL shortener with a database
Build a service that turns long links into short codes, redirects visitors and counts clicks.
Software Development · APIs
Build a REST API for a bookstore
Design and document an API with endpoints for books, authors and orders, with tests.
Programming · Java
Build a library management system
Manage books, members, issue and return with fines, backed by a database.
Software Development · Full Stack
Develop a campus lost-and-found portal
Build a site where students post lost and found items with photos and get matched.
Two-subject alternatives
Literature and English + Data
Analyse word use in a novel with a computer
Count words and character mentions in a public-domain novel and see what the numbers reveal.
Environmental Science + Data
Analyse 50 years of your city's temperature data
Download long-term temperature records and test whether your city has warmed, and by how much.
Electronics and Communication + Data
Filter noise from an audio recording
Record speech with a hum, find the hum's frequency and remove it with a digital filter.
Music, Theatre and Writing + Data
Turn data into music
Map a year of temperature or rainfall data to pitch and rhythm and compose a short piece from it.
Same difficulty and budget
Robotics, IoT and Hardware + Mechanical Engineering
Design a mechanical part in CAD and simulate its stress
Model a bracket, apply a load in simulation and redesign it to be lighter and still strong.
Software Development · Mobile Apps
Build a habit tracker with streaks
Create an Android app to tick off daily habits and see streaks and a calendar heat map.
Artificial Intelligence · Deep Learning
Classify handwritten digits with a neural network
Train a small neural network on the MNIST digits and study where it goes wrong.
Artificial Intelligence + Marketing
Cluster customers into groups
Group customers by spending behaviour with k-means and describe each group in plain words.