Page 211 - IT-802_class_12
P. 211
b. Scope: The application must do the following:
i. Allow a user to register
ii. Provide a login and password to the user.
iii. Allow the user to select a category for the quiz.
iv. Display the quiz questions for the selected category, to a valid user
v. Generate a report to provide the result of the quiz.
vi. Allow the administrator to create, modify, and delete questions.
2. Design: The focus is on “how” the application is to be designed.
a. A Map of the Web Application Site: By identifying the pages for this site, students are encouraged to design
the structure of the sets. The determination of relationships between these pages will be crucial in the design
of a website. For example, a page will be designed with a front-end interface containing links to other pages.
Implementation will follow this design structure.
b. Database: It is decided to create the following tables in the database, along with the attributes of the tables,
their data types, the sizes of the columns in the tables:
i. Admin Login
ii. Quiz information (Here, we take two subjects)
iii. User Info
iv. Result
Table: Admin_Login
S.No. Name Type Remarks
1. Username Varchar (10) Administrator username for login
(Primary key)
2. Pasword Varchar (10) Administrator password for login
Table: Quiz Info
S.No. Name Type Remarks
1. Question_No Number (10) The question number
2. Subject Varchar (10) Subject name, e.g. English, Maths
3. Question Varchar (40) The quiz question
4. Option 1 Varchar (20) 1st option of quiz answer
5. Option 2 Varchar (20) 2nd option of quiz anwer
6. Option 3 Varchar (20) 3rd option of quiz answer
7. Option 4 Varchar (20) 4th option of quiz answer
8. Answer Varchar (10) Correct answer from option 1-4
Operating Web-Based Applications 209

