In this assignment, you build a math question bank by entering math questions into a database.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Math Question Bank

Description

In this assignment, you build a math question bank by entering math questions into a database. You can also create a list of categories, such as Algebra, Geometry, Trigonometry, etc. For each math question, you can assign it to one of the categories. Then you can list all the questions in any category.

Requirements

• Database

1. You need to create a table to store all the math questions.
2. You need to create a table to store all the categories.
3. You need to create a table to store the mappings between the math questions and the categories through their IDs.

• Users' interface

Based on your own understanding, you design your users' interface. The basic consideration is: Your UI should support all the features in this project.

• Features

1. When a user comes to the web application, you display the whole page of the math questions. For simplicity, we do not require you use pagination to display questions in multiple pages − all in one page.
2. There is a text area on the page so that any user can enter a math question into the database.
3. When a question is entered, you need to makes sure that it is not empty (as our data validation).
4. You also need to provide an input field to allow the users to enter a new category.
5. When a user enters a new category, check if it already exists in the table. If it exists, do not duplicate it. Only when it is a new category and it is not an empty string, write it into the table.
6. For each math question, associate it with a dropdown list of the categories and an Assign When the user selects a category, and clicks the Assignbutton, this question belongs to this category.
7. If a question has been assigned to a category, find a way to mark this assignment to make the user aware of it, so as to avoid the user putting a question into the same category twice.
8. On top of the page, list all the categories as menu items. When a category is selected, only the questions in this category are listed.

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of