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.

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. 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

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme