Advanced Database Management System Project - 1284 Words

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 lt;State the improvements in the subjects company in the implementation of the system with the DBMSgt; 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, tbl theme.grade as Grade from tblstudent inner join tbltheme on tblstudent.sid=tbltheme.sid order byShow MoreRelatedMy Department For Software Issues And Problems Essay803 Words   |  4 Pagesfor both electronic and regular mail. At San Jose State I use Word to create academic papers and projects. These are usually in a strict APA format and require extensive footnotes, endnotes, and captions. At the Public Health Department, MS Word is pivotal for my work. I use it to compose emails and other correspondence. I use it to create directories, reports, and records. I use it hourly. Advanced. * Excel: I have been using Excel since the 1980s. I use developer tools to simplify data entryRead MoreAll About Visual Basic1713 Words   |  7 PagesMicrosoft Visual Basic is new evolution in current era, whenever we need to develop any window-based application then we use VB. There have a lot of versions in VB like VB.6, VB.7, VB.NET etc we use VB.6 version to make this project. The basic idea of introducing visual Basic to the world was to provide a rapid Application Development Environment to the developer. Visual basic provides the first example of successful component object modeling programming in which third Party available componentsRead MoreManagement 3211270 Words   |  6 PagesMGT 321 System Build Project For this project, you will design a system for the organization of your choosing. This could be for a current or former employer or some fictitious organization (Banks Against Blight LLC). The system you design might be data storage, telecommunications, e-commerce, accounting information, manufacturing process system, inventory management, or some other system approved by your instructor.   You will discover (or create, if you choose a fictional organization) andRead MoreStudent1258 Words   |  6 Pagescom I am a hard working, energetic individual with strong project management, relationship management and communication skills and have a proven track record for achieving set objectives and goals. SUMMARY * Broad Project Management experience across a multitude of industries including Airline, Broadcasting amp; Media, Telecommunications, Banking amp; Finance and IT amp; Engineering. * Excellent Relationship Management skills with a proven track record of successfully collaboratingRead MoreThe Application Of A Project1291 Words   |  6 Pages Part 1 1.0 PROJECT DRIVERS 1.1 The User Business or Background of the Project Effort 1.2 Goals of the project 1.3 Client, Customer and other Stakeholders 1.4 Users of the Product 2.0 PROJECT CONSTRAINTS 2.1 Mandated Constraints 2.2 Implementation environment of the current system 2.3 Partner Applications 2.4 Anticipated workplace environment 3.0 FUNCTIONAL REQUIREMENTS 3.1 The Scope of the Work 3.2 The Scope of the Product 3.3 Functional and Data Requirements 4.0 NON-FUNCTIONAL REQUIREMENTS 5.0Read MoreAdmissions Essay for Postgraduate Study at The University of Durham584 Words   |  3 PagesI am an international student from China who is going to graduate from Birmingham City University with a degree in Computing Business E-Systems and Technology. This is a personal statement on applying for the postgraduate study at the University of Durham. To achieve a master degree is a goal in my life plan, when I decided to study bachelors degree in the U.K. During two years of academic study of computer science in Birmingham City University, I enjoyed the British approach to education. ItRead MoreBusiness Intelligence Vs. Business Analytics Essay1660 Words   |  7 Pagesdecades. BIA refers to: (1) the technologies, systems, practices, and applications that (2) analyze critical business data to (3) help an enterprise better understand its business and market (research paper). Traditionally, business intelligence (BI) has been used as an umbrella term to describe the concepts and methods to improve business decision making by using fact-based decision support systems. BI also includes the underlying architectures, tools, databases, applications, and methodologies. BI’sRead MoreEvaluation And Evaluation Of The Bureau Of Preparedness And Response Systems728 Words   |  3 Pages This position is primarily responsible for evaluating, assessing, and analyzing information regarding the Bureau’s programs and the County Health Department (CHDs) preparedness and response systems. In addition, this position also assists on coordinating and managing CHD preparedness and support projects working with CHDs planners, regional preparedness staff and Bureau of Preparedness and Response units. Work may be required beyond normal business hours/days. The duties and responsibilities forRead MoreBenefits of a Database Information Gathering Techniques1090 Word s   |  5 PagesBenefits of a Database amp; Information Gathering Techniques Ian Keller Strayer University Introduction to Relational Database Management Systems CIS 111 Professor Jonathan C. Thrall April 26th, 2012 Databases are very important to every person in the world today. Whatever you do in you daily routine you are bound to come in contact with some form of database and our world has become so dependent on it that most people won’t even realize the importance of databases. A database is a bunchRead MoreWhat Is Structured And Unstructured Data?722 Words   |  3 Pagesrelational databases such as Oracle, DB2, HANA, MySQL, and SQL Server still handle structured data for enterprise applications like ERP and CRM and financial systems. Most of these databases have added some level of in-memory features exception to SAP HANA, which runs the entire database in-memory so that users can gain insights into data faster. NoSQL databases, including MongoDB, Redis Labs, Cassandra, and the graph database, Neo4J, have also emerged. Some of these tools run the entire database in-memory