Advanced Database Management System Project Essay

INTRODUCTIONBackground of the StudyThis study is some the grading system in English of grade thee to grade six-spotstudents 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 in the public eye(predicate) school is also under the incision of pedagogy (well- cognize as DepEd). visual modalityTambo Munti Kulit Elementary School is committed to educate the youth of Cavite for the new millennium, to case dynamic, proactive and innovative leadership It sh tout ensemble be a school wherein leaders are developed to become competent and responsible members of the Filipino social club equipped with maximum potentials so that they sh solely be valued and respected in the global community responsive to the demands of a technologically advancing participation and who are above all, humane and morally upright. It shall continuously serve by its philosophy of Quali ty Education for All and shall always be maneuver by its goal of living up to a national agriculture of excellence. MISSIONTambo Munti Kulit Elementary school is committed to stick out noesis and values necessary for the attainment of higher(prenominal) academic performance. It impart provide youth and adults with habits and skills needed for life-long learning and deliver effective services for the public good. Problems addressed by the entropybase management systemPre-DBMSTypographical Error Misspelled haggle caused by rapid input of info as they hold back to tornado it to the higher department as soon as urgent. Time-wasting It can take a while to manually add or search data. Improper variety of data It is difficult to sort lots of data into groups. Misplace of entropy 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 unless one autho rized room to place all of data. Current DBMSCrashing program and cannot be retrieved 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 system of rulesThe Grading system is provided by the part of Education The Department of Education was established through the Education Decree of 1863 as the Superior explosive charge of Primary Instruction under a Chairman. The Education agency underwent some reorganization efforts in the 20th century in instal to recrudesce define its purpose vis a vis the changing administrations and charters. The present day Department of Education was eventually mandated through Republic 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) formulationtes, implements, and coordinates policies, plans, programs and projects in the areas of formal and non-formal basic education. It supervises all elementary and vicarious education institutions, including alternative learning systems, both public and private and provides for the origination 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%Recitation 20%Performance 15%Theme 10% preparation 5%Project 10%- day-by-day Exam 25% wide-cut 100%Improvements with the use of the DBMS DESIGN AND CODINGEntity Relationship plot (ERD)Relational SchemaQueries usedQuery Descriptionselect* from tblstudent displays all data from tbl student select* 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 da ta from tblothers select tblstudent.l title as put up cite, tblquizzes.quiz_no as Quiz itemise, tblquizzes.grade as array from tblstudent home(a) wedlock tblquizzes on tblstudent.sid=tblquizzes.sid order by sid displays the delay name of the student, unitedly with its quizzes( quiz number and the grade) select tblstudent.lname as utmost Name, tblhomework.homework_no as Homework turning, tblhomework.grade as Grade from tblstudent inner join tblhomework on tblstudent.sid=tblhomework.sid order by sid displays the last 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 last 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 tblother s on tblstudent.sid=tblothers.sid order by sid displays the last name of student, and its recitation 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.per f_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, jump 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 entropy Dictionary This will contain the tables and field names of your subject. Ex.S TUDENT Field Name Data type DescriptionS_fname Text First name of the studentS_age Number Age of the student query 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