Advanced Database Management System Project Essays

Advanced Database Management System Project Essays Advanced Database Management System Project Essay Advanced Database Management System Project Essay Introduction Background of the Study This survey is about the scaling system in English of class thee to rate six pupils of Tambo Munti Kulit Elemantary School. under the counsel of Mrs. Gina G. Espineli. instructor of English. The school is located at barangay Tambo Munti Kulit. Indang. Cavite. The public school is besides under the Department of Education ( well-known as DepEd ) . Vision Tambo Munti Kulit Elementary School is committed to educate the young person of Cavite for the new millenary. to exert dynamic. proactive and advanced leading It shall be a school wherein leaders are developed to go competent and responsible members of the Filipino society ; equipped with maximal potencies so that they shall be valued and respected in the planetary community ; antiphonal to the demands of a technologically forward society ; and who are above all. humane and morally unsloped. It shall continuously function by its doctrine of Quality Education for All and shall ever be guided by its end of living up to a national civilization of excellence . Mission Tambo Munti Kulit Elementary school is committed to supply cognition and values necessary for the attainment of higher academic public presentation. It will supply young person and grownups with wonts and accomplishments needed for life-long acquisition and present effectual services for the common good. Problems addressed by the DBMS Pre-DBMS Typographic Mistake: Misspelled words caused by rapid input of informations as they have to go through it to the higher section every bit shortly as pressing. Time-wasting: It can take a piece to manually add or seek informations. Improper categorization of informations: It is hard to screen tonss of informations into groups. Misplace of Data: There are some instances that the records can be lost or misplaced doing it difficult to recover. Limited: They can non make back-ups. as they have to take it a long clip. Not Secured: There’s merely one authorised room to put all of informations. Current DBMS Crashing plan and can non be retrieved: One of the jobs that is caused by bugs. Slow procedure of informations: This is due to low memory ( largely hardware jobs ) Typographical Mistake: Misspelled words caused by rapid input of informations as they have to go through it to the higher section every bit shortly as pressing. Godhead 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 bureau underwent many reorganisation attempts in the twentieth century in order to better specify its intent vis a vis the altering disposals and charters. The present twenty-four hours Department of Education was finally mandated through Republic Act 9155. otherwise known as the Governance of Basic Education act of 2001 which establishes the authorization of this bureau. The Department of Education ( DepEd ) formulates. implements. and coordinates policies. programs. plans and undertakings in the countries of formal and non-formal basic instruction. It supervises all simple and secondary instruction establishments. including alternate learning systems. both public and private ; and provides for the constitution and care of a complete. adequate. and incorporate s ystem of basic instruction relevant to the ends of national development. The Rating System in English consists the followers: Quizs: 15 % Recitation: 20 % Performance: 15 % Subject: 10 % Homework: 5 % Undertaking: 10 % - - - - - - - - - - - - - - - - - Periodic Exam: 25 % Entire: 100 % Improvements with the usage of the DBMS lt ; State the betterments in the topics company in the execution of the system with the DBMS gt ; DESIGN AND CODING Entity Relationship Diagram ( ERD ) Relational Schema Questions used Query| Description| select* from tblstudent ; | expose all informations from tbl student| select* from tblquizzes ; | displays all informations from tblquizzes| select* from tblhomework ; | expose all informations from tblhomework| select* from tbltheme ; | expose all informations from tbltheme| select* from tblothers ; | displays all informations from tblothers| choice tblstudent. lname as Last Name . tblquizzes. quiz_no as Quiz Number . tblquizzes. class as Grade from tblstudent inner articulation tblquizzes on tblstudent. sid=tblquizzes. sid order by sid ; | displays the last name of the pupil. together with its quizzes ( quiz figure and the class ) | choice tblstudent. lname as Last Name . tblhomework. homework_no as Homework Number . tblhomework. class as Grade from tblstudent inner articulation tblhomework on tblstudent. sid=tblhomework. sid order by sid ; | displays the last name of the pupil. together with its preps ( prep figure figure and the class ) | choice tblstudent. lname as Last Name . tbltheme. theme_no as Theme Number . tbltheme. class as Grade from tblstudent inner articulation tbltheme on tblstudent. sid=tbltheme. sid order by sid ; | displays the last name of the pupil. together with its subjects ( theme figure and the class ) | choice tblstudent. lname as Last Name . tblothers. reci_grade as Recitation from tblstudent inner articulation tblothers on tblstudent. sid=tblothers. sid order by sid ; | displays the last name of pupil. and its recitation grade| choice tblstudent. lname as Last Name . tblothers. perf_grade as Performance from tblstudent inner articulation tblothers on tblstudent. sid=tblothers. sid order by sid ; | displays the last name of the pupil. and its public presentation grade| choice tblstudent. lname as Last Name . tblothers. proj_grade as Project from tblstudent inner articulation tblothers on tblstudent. sid=tblothers. sid order by sid ; | displays the last name of the pupil. and its undertaking grade| choice tblstudent. lname as Last Name . tblothers. peri_grade as Periodical from tblstudent inner articulation tblothers on tblstudent. sid=tblothers. sid order by sid ; | displays the class of the pupil. and its periodical test class. | mysql gt ; choice tblstudent. sid. tblstudent. lname as Last Name . tblstu dent. fname as FirstName . tblstudent. mname as Middle Name . tblstudent. degree as Grade . avg ( tblquizzes. grad vitamin E ) as Quizzes . tblothers. reci_grade as Recitation . tblothers. perf_grade as Performance . avg ( tbltheme. class ) as Themes . avg ( tblhomework. class ) as Homework . tblothers. proj_ class as Project . tblothers. peri_grade as Periodical . ( ( avg ( tblquizzes. class ) *0. 15 ) + ( tblothers. reci_grade*0. 20 ) + ( tblothers. perf_grade*0. 15 ) + ( avg ( tbltheme. class ) *0. 10 ) + ( avg ( tblh omework. class ) *0. 05 ) + ( tblothers. proj_grade*0. 10 ) + ( tblothers. peri_grade*0. 25 ) ) as Final gt ; from tblstudent gt ; interior articulation tblquizzes on tblstudent. sid=tblquizzes. sid gt ; interior articulation tblothers on tblstudent. sid=tblothers. sid gt ; interior articulation tblhomework on tblstudent. sid=tblhomework. sid gt ; interior articulations tbltheme on tblstudent. sid=tbltheme. sid gt ; group by sid gt ; order by lname ; | displays the pupil umber. last name. first name. in-between name. class. quizzes. recitation. public presentation. subjects. prep. undertaking. periodical test. and laso the concluding class based on the expression given by the section of educaton. | Recommendation lt ; Recommendations that you can give if you will heighten the system and/or the database use gt ; Appendixs Screenshots lt ; You will put of import screenshots of the system. Along with the screenshot. there should be a brief treatment on what they are about. 2- 4 sentences would be plenty. gt ; Data Dictionary lt ; This will incorporate the tabular arraies and field names of your topic. gt ; Ex. STUDENT lt ; table name gt ; | Field Name| Data type| Description| S_fname | Text| First name of the student| S_age| Number| Age of the student| Interview Images lt ; This will incorporate the images that shows the interview conducted with the topic. gt ; Interview questionaire lt ; Questionnaire/s used for obtaining the information for this research gt ;