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

Question

3.3 Create another table called student_info in database rgi_student that stores below information:

 STD_BALANCE (INTERGER)

 DUE_DATE (DATE)

 ATTENDANCE (INTERGER)

NB. Use student_reg table to retrieve studentID, firstname and display as in the table above then also use student_fees table to retrieve balance and its due. Return button takes the student back to the home page.

Answer 1

CREATE TABLE student_info (
  student_id integer NOT NULL,
  std_balance integer NOT NULL,
  due_date data NOT NULL,
  attendance integer NOT NULL
  FOREIGN KEY (student_id) REFERENCE student_reg (student_id),
  PRIMARY KEY (student_id)
);