New Each assignment needs to be associated with a module

[ammarali0416]

New module information accessed via st.sesion_state.module_info:
st.session_state.module_info = {'module_id': selected_module_info, 'module_name': selected_module_name}

The assignment table now looks like this:
CREATE TABLE master.STUDYBUDDY.Assignments (
AssignmentID int IDENTITY(1,1) NOT NULL,
ClassID int NULL,
AssignmentName nvarchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
DueDate date NULL,
module_id int NULL,
CONSTRAINT PK_Assignments PRIMARY KEY (AssignmentID),
CONSTRAINT FK_ClassID FOREIGN KEY (ClassID) REFERENCES master.STUDYBUDDY.Classes(class_id),
CONSTRAINT FK_ModuleID FOREIGN KEY (module_id) REFERENCES master.STUDYBUDDY.Modules(module_id)
);

modify the new assignment functions to also add the current module id to the database