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
  • 5 Replies
  • 281 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by freesoft_2000

Dani AI

Generated

A practical way to scope this as a final-year project is to build a small, demonstrable Learning Management System (LMS) that proves solid database design, clear business logic, and end-to-end delivery. Pick a minimum viable feature set you can finish and test: authentication + role-based access (student/staff/admin), course and content CRUD, enrollment, a simple quiz/assessment engine, gradebook, and a small reporting dashboard. Include measurable success criteria in the proposal (what “working” looks like) and at least two demo scenarios (e.g., instructor creates course → student enrolls → takes quiz → grade recorded).

Technology choices should serve the above goals, not impressors. Building on ’s Java suggestion, Spring Boot + Spring Data JPA (Hibernate) accelerates CRUD, transactions, and testing; use H2 for development and migrate to SQL Server/Postgres for final testing. ASP.NET/Core + Entity Framework is just as valid if you prefer C#; pick what you can deliver well. Allocate time for security (bcrypt or PBKDF2 password hashing, input validation, ORM/parameterized queries, HTTPS) and for automated tests (unit + a couple of integration tests).

A tiny starting schema to show in the proposal (obvious extensions expected):

CREATE TABLE student (
  id INT PRIMARY KEY AUTO_INCREMENT,
  username VARCHAR(50) UNIQUE NOT NULL,
  email VARCHAR(255) NOT NULL,
  password_hash VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE course (
  id INT PRIMARY KEY AUTO_INCREMENT,
  code VARCHAR(20) UNIQUE NOT NULL,
  title VARCHAR(255) NOT NULL
);

CREATE TABLE enrollment (
  id INT PRIMARY KEY AUTO_INCREMENT,
  student_id INT NOT NULL,
  course_id INT NOT NULL,
  enrolled_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Regarding ’s idea of writing your own database: it’s an excellent research topic but high risk for a single-year project. A safer way to show originality is to implement a custom storage adapter, a simple query layer, or a pluggable import/export format on top of an existing DB. For the proposal include aims, high-level architecture (ERD + sequence), milestone schedule, test plan, and deliverables (code repo, documentation, demo).

Recommended Answers

All 5 Replies

Member Avatar for hooknc

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 :?:

Web learning sending everything to the database? That should be enough if you ask me. Look into Spring and Hibernate. Those are fresher and newer.

Regards,

Nate

Member Avatar for bondito

Thanks for ur reply. Could you shed more light on spring and hibernate, i was thinking of using asp.net and sqlserver to implement the system. Are there any better applications or programming languages to use for this system.

Member Avatar for hooknc

Thanks for ur reply. Could you shed more light on spring and hibernate, i was thinking of using asp.net and sqlserver to implement the system. Are there any better applications or programming languages to use for this system.

Well, since you're in a java forum i thought you would be using a java based solution...

Anyways, Spring is a frame work that allows for indirection, dependancy interjection, and Aspect Oriented Programming (AOP). Each is important in its own way. Hibernate is a Object/Relational Mapping tool (ORM) that allows your to persist entire object graphs instead of having to use JDBC to break apart your object graphs manually.

Regards,

Nate

Member Avatar for bondito

Thanks for your help and i will look into your suggestion.

Member Avatar for freesoft_2000

Hi everyone,

If you do not like Spring or Hibernate, you can also roll out your own database which would be really cool and a great addition to your future resume

Richard West

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.