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
   206   207   208   209   210   211   212   213   214   215   216