Member Avatar for iamy1204

i am a al atudent...i hv to do a pjt about creating a database of sports day...although i hv learnt some sql about database...but i really don't know how to start to create a database.....eg...use wt software..wt have to include inside.....how can i show my product to my teacher...the pjt guideline said that we hv to create a prototype...wt's that? anyone plz help me ......i have to do this project in this summer holiday....

  • 2 Contributors
  • 2 Replies
  • 117 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by iamy1204

Dani AI

Generated

— short, practical plan to get this done while your teacher is away. Build a small, focused system that proves the idea instead of a full production product. Keep scope to core pieces you can finish in a few days: participants, events, results, and a schedule. That gives you something concrete to show and lets you demonstrate database design, queries, and a simple interface or report.

A sensible workflow you can follow:

  • Define the questions the database must answer (examples: "Who won each event?", "What is the schedule for a competitor?"). Those drive the tables and fields.
  • Sketch an entity diagram on paper or with a simple tool (participants, teams, events, results, venues, categories).
  • Implement a tiny working slice: create tables, insert sample data, run a few queries, and export screenshots. A short SQL DDL script plus a handful of sample rows often convinces a teacher.
  • Optionally add one small UI or report (Excel pivot/Access form/simple PHP+HTML) so you can demo input and output.

A minimal example schema (use this as a starting point):

CREATE TABLE Participants (
  participant_id INTEGER PRIMARY KEY,
  first_name TEXT NOT NULL,
  last_name TEXT NOT NULL,
  class TEXT
);

CREATE TABLE Events (
  event_id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  category TEXT
);

CREATE TABLE Results (
  result_id INTEGER PRIMARY KEY,
  event_id INTEGER NOT NULL,
  participant_id INTEGER NOT NULL,
  rank INTEGER,
  time_seconds INTEGER,
  FOREIGN KEY(event_id) REFERENCES Events(event_id),
  FOREIGN KEY(participant_id) REFERENCES Participants(participant_id)
);

Presentation checklist: include the diagram, the DDL script, sample data, screenshots of a few queries/reports, and a one-page README explaining assumptions and how to run the demo. Keep notes on design choices (keys, relationships, how you handle ties or disqualifications). Building this small, polished prototype will satisfy the project requirement and make grading straightforward — it also aligns with the idea mentioned about showing design plus a working slice.

Recommended Answers

All 2 Replies

Member Avatar for Phaelax

Hopefully, English isn't your first language. If this is for your class, why not ask your teacher? I'm sure he/she would have explained a little something about how to proceed before demanding students create a database on their own.

If asking for a prototype, it could be something as simple as a diagram showing the described tables: their names, fields, relationship to other tables. Ask your teacher if the prototype is a working demonstration or just a UML diagram.

Member Avatar for iamy1204

oh...thanks....but since our teacher is very impatient and now is summer holiday...he is not in school....he supposes us do it all by our own....that's why i am so worried .....regarding the prototype....now i know is just some diagram showing the content...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.