Advanced level school Python programming. Need helps. thanks in advance. A school uses a Database Management System

 

 
 

Advanced level school Python programming. Need helps. thanks in advance.

 

Transcribed Image Text:

A school uses a Database Management System (DBMS) application to keep track of the students, their Civics Classes and the CCAS they join. The fully normalised table descriptions are as follows: Student (MatricNo, Name, Gender, CivicsClass) Civics (Class, Tutor, HomeRoom) StudentCCA (MatricNo, CCAName) CCAInfo (Name, TeacherIC) Fieldl and Field2 represent the primary and foreign keys respectively. Task 2.1 Write a Python program to create the database school.db with the four tables. Write a Python program to insert all the information from the data files, Student.csv, Civics.csv, Student CCA.csv and CCAInfo.csv, into the database school.db. Save and submit your program code as Task2_1_ .py Rename and submit the populated database as school .db. Task 2.2 Create a HTML file called index.html to display the following Particulars Form for users to submit their request to retrieve their particulars from the back-end server. Particulars Form Enter your Matriculation Number to retreive your school information: - Matriculation Number: Submit A school uses a Database Management System (DBMS) application to keep track of the students, their Civics Classes and the CCAS they join. The fully normalised table descriptions are as follows: Student (MatricNo, Name, Gender, CivicsClass) Civics (Class, Tutor, HomeRoom) StudentCCA (MatricNo, CCAName) CCAInfo (Name, TeacherIC) Fieldl and Field2 represent the primary and foreign keys respectively. Task 2.1 Write a Python program to create the database school.db with the four tables. Write a Python program to insert all the information from the data files, Student.csv, Civics.csv, Student CCA.csv and CCAInfo.csv, into the database school.db. Save and submit your program code as Task2_1_ .py Rename and submit the populated database as school .db. Task 2.2 Create a HTML file called index.html to display the following Particulars Form for users to submit their request to retrieve their particulars from the back-end server. Particulars Form Enter your Matriculation Number to retreive your school information: - Matriculation Number: Submit