Development of the query handling system

Assignment Help Database Management System
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.

Reference no: EM133473948

Questions Cloud

Discuss controversy of hiring police officer applicants : Discuss the controversy of hiring police officer applicants who have used drugs in the past. Whatis your opinion? Support your opinion.
Why pharmaceutical companies need to follow both glp and gmp : Explain in detail the major differences between GLP and GMP. Why pharmaceutical companies need to follow both GLP and GMP?
How would new health care administrators navigate the needs : How would new health care administrators navigate the needs and expectations of differing stakeholders: recognize and strategize for a win-win every time?
Find an example of a school health program : Using the Internet, the South University Online Library, or any other resource, find an example of a school health program engaged in capacity-building.
Development of the query handling system : ITT304 Database Management Systems - development of the Query Handling System will provide automation process for the clarification of uncertainties
What is a continuous variable : What is a continuous variable? How does a continuous variable differ from other variables?
Do you think that prisoners have too many rights : Do you think that prisoners have too many rights (after all, once incarcerated, you lose many rights along with your freedom)? Why or why not?
How much probable cause is needed to secure arrest : How much probable cause is needed to secure an arrest/search warrant on an individual. Is there a difference between a stop, a frisk or an arrest?
Most critical issue in policing today : Identify what you believe is the most critical issue in policing today, but more importantly identify what you believe is the solution to the critical issue.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd