Create an ASP Navigation Page that allows Visitors to Search

Create an ASP query page that allows visitors to enter search criteria that includes selecting a category and/or entering keyword text and create a results page that allows the visitor to select the URL in the database record. Search Page The search page ([login to view URL]) will contain two fields; “Search Category” and “Keyword Search”. These two fields will be combined (AND operation). The search category will have a down list of the search categories which the visitor can select. The default search category is 1 (ALL). The search list should be displayed in alphabetical search order (A to Z) and the person can only select 1 category. The keyword search will display as blank. The default search criteria is any group of characters (wild character *). If the visitor selects “All Categories” and does not enter any keywords, a message should display “Please Select a Category or enter Keywords to Search.” For consitent appearance, the search page should replace the index text in this page: [login to view URL] Search Results Page This search results page ([login to view URL]) will display matching records (maximum of 20 records) that include a link that the visitor can select to redirect them to the URL (Article_URL) The category (Subject_Category) should be searched first (if a category has been selected) which will be followed by searching for matching keyword in title (Article_Name), keywords (Article_Keywords), and description (Article_Description). For consitent appearance, the search results page should replace the index text in this page: [login to view URL] Database Files Articles ArticleID – Key for article record Article_Name – text name of the article Aritcle_Description – text that describes the articles Subject_Categories SubjectID – Key for subject categories Subject_Name – Name of Category Subject Subject_Keywords – Words related to the subject content Article_Category_Details ArticleDetailID – Key for article detail record ArticleID – Foreign key – for articles listed in Articles table SubjectID – Foreign key – for category in subject table Sample Database [login to view URL]