Member Avatar for bondito

I am a final year computer science/networks student, i am going to hand in my final year project, and i was thinking of creating an online learning system which would include a database for storing student and staff details. Please i need ideas on what i can add to my project proposal, or any fresh ideas on a project in my field will help. Thanks :?:

  • 3 Contributors
  • 2 Replies
  • 231 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by Brims

Dani AI

Generated

Good starting idea from — an academic portal gives a lot of places to show database design, UI work and business rules. Building on 's enrollment suggestion, keep the project scoped so core functionality is complete and well-documented rather than half-finished extras. A clear MVP demonstrates requirements, a normalized schema, safe authentication, core CRUD, enrollment with capacity/prereq checks, and a simple grade/credit tracker.

Suggested development flow: write 6-8 short user stories, sketch an ER diagram and normalize to 3NF, implement authentication and role-based pages (student/staff/admin) first, then CRUD for courses and people. Implement enrollment logic inside a transaction so capacity/prereq rules are atomic. Add reporting (CSV export), basic resource upload and a small admin UI for test data. Deliverables that assessors expect: requirements spec, ER diagram, SQL DDL scripts, code, test cases, a short demo video and a README describing setup.

A tiny example schema to make discussion concrete:

CREATE TABLE Students (
  id INT AUTO_INCREMENT PRIMARY KEY,
  first_name VARCHAR(50),
  last_name VARCHAR(50),
  email VARCHAR(120) UNIQUE,
  password_hash VARCHAR(255)
);

CREATE TABLE Courses (
  id INT AUTO_INCREMENT PRIMARY KEY,
  code VARCHAR(12) UNIQUE,
  title VARCHAR(150),
  capacity INT DEFAULT 30,
  credits INT DEFAULT 3
);

CREATE TABLE Enrollments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  student_id INT,
  course_id INT,
  status ENUM('enrolled','waitlist','dropped'),
  grade VARCHAR(5),
  FOREIGN KEY (student_id) REFERENCES Students(id),
  FOREIGN KEY (course_id) REFERENCES Courses(id),
  UNIQUE(student_id, course_id)
);

Practical cautions and grading tips: prevent SQL injection with prepared statements, never store plain passwords (bcrypt/argon2), use DB transactions or SELECT ... FOR UPDATE to avoid race conditions on capacity, seed realistic test data and include test cases for edge situations (full course, prereq loop). For time-limited projects (see ), pick a tight feature set and document tradeoffs — depth and correctness score higher than breadth.

Recommended Answers

All 2 Replies

Member Avatar for techniner

Create an online enrollment system.

Setup 10 Courses. Each course can only have a set amount of students.

Have each student be paid up in tutiton before enrolling any single class.

Then have a credits system where a student needs 10 credits to grauate make sure they meet the criteria.. etc etc.

Or setup like BASE coruses must be taken before electives.

Should be a very good example for different types of scenarios.

Professors love to see all possiblities accounted for.

Member Avatar for Brims

Hiya this is Brims i need an idea for a final year project computer science, nothing too hard time is running out. I want to use either php or asp with database cant seem to think of any applications can someone help please :cry:

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.