Question: 1 - Setup a webserver 2 - Create a page that allows users to submit their name and a ticket number to a SQL Express

1 - Setup a webserver

2 - Create a page that allows users to submit their name and a ticket number to a SQL Express database on the webserver. (Automatically track the date data submitted)

3 - Create a page that that displays the contents of the SQL database sorted by date and Name and then a count of the ticket numbers.

What i need to know is the syntax for the webpages and the syntax for the queries needed to access data. for the purpose of this test. let the user column be Worker_NAME and ticket ID be from the TICKET_ID column. I am rusty on SQL. database information will be provided to me later. I need the webpage data that I can fill in with the provided database info, username, and password

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Your manager has provided you the following matrix and asked that you use it to complete the design assessment phase of your testing. The manager has already performed a preliminary survey, and has...

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

43 AaBbCcDc AaBbc AaBbCc) AaBbCcDd AaBbCcDd Emphasis Heading 1 Heading 2 11 Normal 1 Normal ... Paragraph Styles Instructions Points Possible exercise begins on page 343 of your text. Start Excel....

Financial Statement Analysis Obtain a copy of the 2009 annual report for a publicly held firm. Try to obtain an annual report for a retail or manufacturing firm. Be sure that the financial statement...

TASK You are to create a forum website based on the descriptions below, that allows users to sign up and create topics and posts on those topics. SET-UP Create a folder on...

Air France-KLM (AF), a Franco-Dutch company, prepares its financial statements according to International Financial Standards. AFs financial statements and disclosure notes for the year ended...

Explain what is Human Resources Management in your words?

When deciding whether to keeg production st the cument level of output or produce more, ofrm will need to compare the: trevage variabie cost and werrage fleed cost. otel cort ment totht rovenus....

National Retail has two departments, Housewares and Sporting. Indirect expenses for the period follow. Rent $ 45,000 Advertising 25,000 Insurance 10,000 Total $ 80,000 The company occupies 4,000...

How do direct subsidies, countercyclical payments, and marketing loan subsidies differ under the Farm Act of 2002? In what way do countercyclical payments and marketing loans help reduce the...

ADVANCED ANALYSIS Suppose the equation for the demand curve for some product X is P 8 .6 Q and the supply curve is P 2 .4 Q. What are the equilibrium price and quantity? Now suppose an excise tax...

KEY QUESTION Explain how each of the following contributes to the farm problem: a. The inelasticity of demand for farm products. b. The rapid technological progress in farming. c. The modest long-run...