Answer to Question #238109 in HTML/JavaScript Web Application for Owen

Question

3.5 Create another table called student_res in database rgi_student that stores below information:

 MODULE (TEXT)

 FINAL_MARK (INTERGER)

NB. Again use student_reg table to retrieve studentID, firstname and display as in the table above then also use student_res table to retrieve module name and final mark obtained. Request academic record button sends an email to Richfield results department requesting student academic record.

Answer 1

CREATE TABLE student_res (
  student_id integer NOT NULL,
  module text NOT NULL,
  final_mark integer NOT NULL,
  FOREIGN KEY (student_id) REFERENCES student_reg (student_id),
  PRIMARY KEY (student_id)
);