technifyed

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

My projects

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

ER modellingNormalisationWriting queries

Materials and tools

  • Computer with SQLite or any free database

Tools and software

SQLSQLite

Expected cost₹0Nothing to buy
Estimated duration1–2 weeks5 build steps, plus the report

Step-by-step roadmap

  1. Start

    You will finish with: an ER diagram, a schema, sample data and ten working queries.

  2. 1

    Prerequisites

    Nothing special to know first. Then collect the 1 item in the materials list.

  3. 2

    Learn

    • How to model entities and relationships
    • What normalisation removes
    • How to write joins
  4. 3

    Plan

    List the features for version one, sketch the screens or data flow and pick the tools. Keep the first version small.

  5. 4

    Build

    1. Interview someone who runs the system and list what must be stored.
    2. Draw an entity-relationship diagram.
    3. Normalise to third normal form and create the tables.
    4. Insert realistic sample data.
    5. Write ten queries, including joins and grouped totals.
  6. 5

    Test

    Try it with wrong, empty and unusual input, and ask someone else to use it without your help.

  7. 6

    Document

    Write a README: what it does, how to run it, screenshots and what you learned. Report structure

  8. 7

    Present

    Show a live demo of one complete task, then the design and the hardest problem you solved. Presentation structure · Viva questions

  9. 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

  1. BasicDesign three tables and write five simple queries.
  2. This projectDesign a database for a hostel or library
  3. 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).

Working as a team

Solo or up to 2. Suggested roles:

FrontendBackendData or modelDesignTestingDocumentationPresentation

Report and presentation

Report structure

  1. Title and summary
  2. Problem and target user
  3. Features
  4. Tools and technology
  5. Design: architecture, data model or screens
  6. Implementation
  7. Testing
  8. Results and screenshots
  9. Challenges
  10. Future improvements
  11. References

Presentation structure

  1. The problem
  2. Who it is for
  3. Live demo
  4. How it is built (one diagram)
  5. The hardest part
  6. Testing and results
  7. What you learned
  8. 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.

  • Intermediate
  • 1–2 weeks
  • Free
Visualization · Computer onlyView

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".

  • Intermediate
  • 1–2 weeks
  • Free
Data Analysis · Computer onlyView

Data · Data Science

Analyse traffic accidents with open data

Use official accident statistics to find when, where and why accidents happen in your state.

  • Intermediate
  • 1–2 weeks
  • Free
Data Analysis · Computer onlyView

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.

  • Intermediate
  • 1–2 weeks
  • Free
Web App · Computer onlyView

Software Development · APIs

Build a REST API for a bookstore

Design and document an API with endpoints for books, authors and orders, with tests.

  • Intermediate
  • 1–2 weeks
  • Free
Software Project · Computer onlyView

Programming · Java

Build a library management system

Manage books, members, issue and return with fines, backed by a database.

  • Intermediate
  • 2–4 weeks
  • Free
Software Project · Computer onlyView

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.

  • Intermediate
  • 2–4 weeks
  • Free
Web App · Computer onlyView

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.

  • Intermediate
  • 1–2 weeks
  • Free
Data Analysis · Computer onlyView

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.

  • Intermediate
  • 1–2 weeks
  • Free
Software Project · Computer onlyView

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.

  • Intermediate
  • 1–2 weeks
  • Free
Art Project · Computer onlyView

Same difficulty and budget

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.

  • Intermediate
  • 1–2 weeks
  • Free
Mobile App · Computer onlyView

Artificial Intelligence + Marketing

Cluster customers into groups

Group customers by spending behaviour with k-means and describe each group in plain words.

  • Intermediate
  • 1–2 weeks
  • Free
AI/ML Project · Computer onlyView

Enter your email and the official page opens. Phone is optional.