preview

Advanced Database Management System Project

Better Essays
Open Document

Midterm Project Documentation for ITEC 65 – Advanced Database Management System Grading System In English III to VI/Tambo Munti Kulit Elementary School Prepared By: Emer John C. Epineli September 2, 2013 Submitted to: Mr. James Angelo V. Aves Table of Contents INTRODUCTION 3 Background of the Study 3 Problems addressed by the DBMS 3 Creator of the System 4 Improvements with the use of the DBMS 4 DESIGN AND CODING 6 Entity Relationship Diagram (ERD) 6 Relational Schema 6 Queries used 7 RECOMMENDATION 10 Appendices 11 Screenshots 11 Data Dictionary 11 Interview Images 11 Interview questionaire 11 INTRODUCTION Background of the Study This study is about the grading system in English of …show more content…

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

Get Access
Related
Get Access