Advanced Database Management System Project Essay

INTRODUCTION Background of the Study This study is about the grading system in English of grade thee to grade six students 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). VISION Tambo Munti Kulit Elementary School is committed to educate the youth of Cavite for the new millennium, to exercise dynamic, proactive and innovative leadership It shall 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 respected 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 excellence†. MISSION Tambo Munti Kulit Elementary school is committed to provide knowledge and values necessary for the attainment of higher academic performance. It will provide youth and adults with habits and skills needed for life-long learning and deliver effective services for the common good. Problems addressed by the DBMS Pre-DBMS Typographical Error: Misspelled words caused by rapid input of data 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: There’s only one authorized room to place all of data. Current DBMS Crashing 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 of data as they have to pass it to the higher department as soon as urgent. Creator of the System The Grading system is provided by the Department of Education The Department of Education was established through the Education Decree of 1863 as the Superior Commission of Primary Instruction under a Chairman. The Education agency underwent many reorganization efforts in the 20th 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 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) formulates, implements, and coordinates policies, plans, programs and projects in the areas of formal and non-formal basic education. 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 educat ion relevant to the goals of national development. The Grading System in English consists the following: Quizzes: 15% Recitation: 20% Performance: 15% Theme: 10% Homework: 5% Project: 10% ————————————————- Periodical Exam: 25% Total: 100% Improvements with the use of the DBMS DESIGN AND CODING Entity Relationship Diagram (ERD) Relational Schema Queries used Query| Description| select* 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 tbltheme| select* from tblothers;| displays all data from tblothers| select tblstudent.lname as â€Å"Last Name†, tblquizzes.quiz_no as â€Å"Quiz Number†, tblquizzes.grade as â€Å"Grade† from tblstudent inner join tblquizzes on tblstudent.sid=tblquizzes.sid order by sid;| displays the last name of the student, together with its quizzes( quiz number and the grade)| select tblstudent.lname as â€Å"Last Name†, tblhomework.homework_no as â€Å"Homework Number†, 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 wit h 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 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 s tudent, and its periodical exam grade.| mysql> select tblstudent.sid , tblstudent.lname as â€Å"Last Name†, tblstudent.fname as â€Å"FirstName†, 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.| RECOMMENDATION Appendices Screenshots Data Dictionary < This will contain the tables and field names of your subject. > Ex. STUDENT | Field Name| Data type| Description| S_fname | Text| First name of the student| S_age| Number| Age of the student| Interview 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 >