Develop a customer service tool to keep track of customers

Reference no: EM13874348

You have been asked to develop a customer service tool to keep track of customers and sales at a hardware supply company. The final product of this tool will include a MySQL database that includes all of the customer information, Web forms that will be used by Customer Service agents to enter and to retrieve customer information, and the PHP page that will submit information from the forms to the MySQL database.

For this assignment, you will only create the database table in MySQL.

The database table should include the following:

Customer Name
Customer Company
Customer Position/Title
Customer Phone Number
Customer Address
Customer e-Mail Address
Date of last order

Design and create the database table in MySQL using phpMyAdmin. When completed, submit a screenshot from phpMyAdmin to show the table you have created in the database. Paste the screenshot into a Microsoft Word document.

Reference no: EM13874348

Questions Cloud

Research paper - the rapture : Write one research paper of ten (10) pages. The paper must interact with a minimum of 10 scholarly resources and be appropriately footnoted, (3¬4 footnotes per page minimum). Choose from the following topics: The Rapture and Thessalonians 2:1-12

Minimum pressure to which the refrigerant : Consider a refrigeration system using refrigerant- 134a as the working fluid. If this refrigerator is to operate in an environment at 30°C, what is the minimum pressure to which the refrigerant should be compressed? Why?

Meet the criteria of the new negro : Write a skeleton outline, including your thesis statement and the main point of each paragraph.

Heating element in the water : By placing it on an electric range and By placing a heating element in the water. Which method is a more efficient way of heating water? Explain.

Develop a customer service tool to keep track of customers : You have been asked to develop a customer service tool to keep track of customers and sales at a hardware supply company. The final product of this tool will include a MySQL database that includes all of the customer information, Web forms that will ..

Explain advantages and disadvantages of privatisation : Question : Explain about advantages and disadvantages of privatisation in 3 to 4 pages

Functions have identified for a business or personal task : Identify three (3) Microsoft Excel 2013 functions that you believe to be the most useful within the application. Next, describe one (1) way in which you would consider utilizing each of the functions you have identified for a business or personal tas..

Why hotel manager understand theory of peak-load pricing : Explain why a hotel manager should understand the theory of peak-load pricing. Explain using the theory of peak-load pricing why price ceilings on the pool price are not efficient.

Who chooses what and why and what is the outcome : For this essay, choose one of the following four moments in the Aeneid and answer the questions: Moments- The Trojans' decision to bring the Trojan horse into Troy: Aeneid 2.1J345. In the first body paragraph, you must indicate: Who chooses what and..

User Account

All Pages