Advanced Database Management System Project Essay

INTRODUCTIONBackground of the StudyThis study is about the grading system in English of identify thee to grade sixstudents of Tambo Munti Kulit Elemantary School, under the guidance of Mrs. Gina G. Espineli, teacher of English. The school is located at barangay Tambo Munti Kulit, Indang, Cavite. The public school is also under the department of Education (well-known as DepEd). VISIONTambo Munti Kulit Elementary School is committed to educate the youth of Cavite for the new millennium, to exercise dynamic, proactive and innovative leadership It sh all(prenominal) be a school wherein leaders are developed to become competent and responsible members of the Filipino society equipped with maximum potentials so that they shall be valued and prize in the global community responsive to the demands of a technologically advancing society and who are above all, humane and morally upright. It shall continuously serve by its philosophy of Quality Education for All and shall always be guided by its goal of living up to a national culture of morality. MISSIONTambo Munti Kulit Elementary school is committed to provide knowledge and values necessary for the attainment of higher(prenominal) academic performance. It forget provide youth and adults with habits and skills indispensable for life-long learning and deliver effective services for the common good. Problems addressed by the DBMSPre-DBMSTypographical Error Misspelled words caused by rapid input of information as they have to pass it to the higher department as soon as urgent. Time-wasting It can take a while to manually add or search data. Improper classification of data It is difficult to sort lots of data into groups. Misplace of Data There are some cases that the records can be lost or misplaced making it hard to retrieve. Limited They cannot create back-ups, as they have to take it a long time. Not Secured Theres only one authorized room to place all of data. Current DBMSCrashing program and cannot be retrieve d One of the problems that is caused by bugs. Slow process of data This is due to low memory (mostly hardware problems) Typographical Error Misspelled words caused by rapid input ofdata as they have to pass it to the higher department as soon as urgent. Creator of the SystemThe Grading system is provided by the Department of Education The Department of Education was established done the Education Decree of 1863 as the Superior Commission of Primary Instruction under a Chairman. The Education agency underwent many reorganization efforts in the twentieth century in order to better define its purpose vis a vis the changing administrations and charters. The present day Department of Education was eventually mandated through nation Act 9155, otherwise known as the Governance of Basic Education act of 2001 which establishes the mandate of this agency. The Department of Education (DepEd) formulates, implements, and coordinates policies, plans, programs and projects in the areas of formal and non-formal basic raising. It supervises all elementary and secondary education institutions, including alternative learning systems, both public and private and provides for the establishment and maintenance of a complete, adequate, and integrated system of basic education relevant to the goals of national development. The Grading System in English consists the followingQuizzes 15% physical exertion 20%Performance 15%Theme 10% preparedness 5%Project 10%-Periodical Exam 25%Total 100%Improvements with the use of the DBMS DESIGN AND CODINGEntity Relationship Diagram (ERD) relative SchemaQueries usedQuery Description allot* from tblstudent displays all data from tbl student award* from tblquizzes displays all data from tblquizzes select* from tblhomework displays all data from tblhomework select* from tbltheme displays all data from tblthemeselect* from tblothers displays all data from tblothers select tblstudent.l figure of speech as Last Name, tblquizzes.quiz_no as Quiz Number, tblquizzes.grade as Grade from tblstudent interior(a) join tblquizzes on tblstudent.sid=tblquizzes.sid order by sid displays the put up name of the student, together with its quizzes( quiz number and the grade) select tblstudent.lname as Last Name, tblhomework.homework_no as grooming Number, tblhomework.grade as Grade from tblstudent inner join tblhomework on tblstudent.sid=tblhomework.sid order by sid displays the furthermost name of the student, together with its homeworks( homework number number and the grade) select tblstudent.lname as Last Name, tbltheme.theme_no as Theme Number, tbltheme.grade as Grade from tblstudent inner join tbltheme on tblstudent.sid=tbltheme.sid order by sid displays the live on name of the student, together with its themes( theme number and the grade) select tblstudent.lname as Last Name, tblothers.reci_grade as Recitation from tblstudent inner join tblothers on tblstudent.sid=tblothers.sid order by sid displays the fail name of student, and its r ecitation grade select tblstudent.lname as Last Name, tblothers.perf_grade as Performance from tblstudent inner join tblothers on tblstudent.sid=tblothers.sid order by sid displays the last name of the student, and its performance grade select tblstudent.lname as Last Name, tblothers.proj_grade as Project from tblstudent inner join tblothers on tblstudent.sid=tblothers.sid order by sid displays the last name of the student, and its project grade select tblstudent.lname as Last Name, tblothers.peri_grade as Periodical from tblstudent inner join tblothers on tblstudent.sid=tblothers.sid order by sid displays the grade of the student, and its periodical exam grade. mysql select tblstudent.sid , tblstudent.lname as Last Name, tblstudent.fname asFirstName, tblstudent.mname as Middle Name, tblstudent.level as Grade, avg(tblquizzes.grad e) as Quizzes, tblothers.reci_grade as Recitation, tblothers.perf_grade as Performance, avg(tbltheme.grade) as Themes, avg(tblhomework.grade) as Homework, tblothers.proj_ grade as Project, tblothers.peri_grade as Periodical, ((avg(tblquizzes.grade)*0.15)+(tblothers.reci_grade*0.20)+(tblothers.perf_grade*0.15)+(avg(tbltheme.grade)*0.10)+(avg(tblh omework.grade)*0.05)+(tblothers.proj_grade*0.10)+(tblothers.peri_grade*0.25)) as Final - from tblstudent- inner join tblquizzes on tblstudent.sid=tblquizzes.sid - inner join tblothers on tblstudent.sid=tblothers.sid - inner join tblhomework on tblstudent.sid=tblhomework.sid - inner join tbltheme on tblstudent.sid=tbltheme.sid - group by sid- order by lname displays the student umber, last name, first name, middle name, grade, quizzes, recitation, performance, themes, homework, project, periodical exam, and laso the final grade based on the formula given by the department of educaton.RECOMMENDATIONAppendicesScreenshots Data Dictionary This will contain the tables and field names of your subject. Ex.STUDENT Field Name Data type DescriptionS_fname Text First name of the studentS_age Number fes ter of the studentInterview Images This will contain the images that shows the interview conducted with the subject. Interview questionaire Questionnaire/s used for obtaining the information for this research