Reference no: EM133473948
Database Management Systems
Query Handling System
SCENARIO
The Query Handling System is designed to handle queries which are frequently asked by the students. The Query Handling System will be providing a chance for the students to clarify their doubts by posting questions. Normally it is very hard to handle all this query clarification process manually. The development of the Query Handling System will provide automation process for the clarification of uncertainties by asking the students to post the questions and so that they can get clarification.
There will be many questions that are being posted frequently by the students to various departments in the University. The University Examination Department wants to maintain all the frequently asked questions in the database subject wise. From time to time examination's department will be updating the questions and the related answers into the database.
The primary goal of the Query Handling System is to provide an environment that is both convenient and efficient for the students and lecturers through which the students can get clarity about their doubts, for the administrators of a particular department to retrieve the information from database and also for storing the information into the database.
Required Users/Rights for the Query Handling System
Modules:
• Super User
• Administrator
• Student
Super User:
• To control the data
• Appoints the administrators in each department
• Appoints the administrator to a particular department to register the admin
• Add/Delete new department(s) like computer science, chemistry, physics, mathematics, etc.
• Add/Delete new/old topic(s) to particular department(s)
• Add the question with answers and storing the data in database.
Administrator:
• Administrator can add the question with answers and it will be stored in database for students to retrieve it.
• Administrator will modify the answers.
• The student post a question in certain department the respective administrator will answer the question and a copy of the answer
will be sent to the student.
Student:
• Student post a question in certain department.
• Student check the answer for which he is posted.
• Student checks the answer for available questions.
Use MySQL to:
Leverage your SQL skills to extract and analyze data from various tables in the Query Handling System Database to answer students' questions.
1. Based on the scenario above you are required to create the application: (database, tables, queries - update, delete, etc.)
2. Each question will require you to write a multi-table SQL query, joining at least two tables using MYSQL.
3. NB* All usernames and passwords and Output Screens (screen shot) with Explanation must be included with the project.
4. PowerPoint Presentation
Each student will make an individual short (5 - 7 minutes) in class project presentation explaining your response to creating the Query Handling System.