Please i need help in modifying or remaking the database so that i can mark answers to questions immediately.
The problem is some courses have 50 questions, while others have 100.

How can i design the db to have answers to questions for each year and course separately?
here is my existing database sql structure

    CREATE TABLE "Answer" (
    "ans_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,
    "year_id" INTEGER NOT NULL ,
    "course_id"  NOT NULL,
    FOREIGN KEY(year_id) REFERENCES "oXHFcGcd04oXHFcGcd04_year"(year_id) ,
    FOREIGN KEY(course_id) REFERENCES Course(name)
    );

    CREATE TABLE "Course" (
    "course_id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL ,
    "name" VARCHAR NOT NULL , 
    "year_id" INTEGER NOT NULL,
    FOREIGN KEY(year_id) REFERENCES "oXHFcGcd04oXHFcGcd04_year"(year_id) 
    );

    CREATE TABLE "year" 
    (
    "year_id" INTEGER PRIMARY KEY  NOT NULL ,
    "year" NUMERIC NOT NULL 
    );

I don't think there is anything wrong with you table as it is. You can get the results you want depending how how you write your SQl queries.
For clarity as your table are, let's assume a scenario where you want to get all the course from 2007. You SQL query will looks a follows.

SELECT Course.course_id, Course.Name, Year.year 
FROM Course 
INNER JOIN Year
ON Course.year_id = Year.year_id 
WHERE Year.year='2007'

The above SQL query should successfully retrieve the course id, name, year of course within 2007 as long as they exist.

let say i want to get the questions to work with what i have on ground how do i design it that i can link it to each course, year and still have all 50 questions in one column?
do i have to make my questions table have all 50+ rows to works?