Advanced Database Management System Project Essay

Custom Student Mr. Teacher ENG 1001-04 5 April 2016

Advanced Database Management System Project

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 education 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
<State the improvements in the subjects company in the implementation of the system with 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 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 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 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
<Recommendations that you can give if you will enhance the system and/or the database usage>

Appendices
Screenshots
<You will place important screenshots of the system. Along with the screenshot, there should be a brief discussion on what they are about. 2- 4 sentences would be enough.> Data Dictionary
< This will contain the tables and field names of your subject. > Ex.
STUDENT <table name>|
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 >

Free Advanced Database Management System Project Essay Sample

B

  • Subject:

  • University/College: University of Arkansas System

  • Type of paper: Thesis/Dissertation Chapter

  • Date: 5 April 2016

  • Words:

  • Pages:

We will write a custom essay sample on Advanced Database Management System Project

for only $16.38 $12.9/page

your testimonials