Question

Describe a job where you would be likely to use spreadsheet software. Explain what you might use it for. (1-3 sentences. 2.5 points)

List at least five pieces of information you would want to keep track of if you were creating a customer database for your own compar
- Explain why you wouldn't want to use the customer first or last name field as the primary key for a table. What problem could this crea

Answer 1

Spreadsheet software is commonly used in jobs such as financial analysis. Some important pieces of information to include in a customer database are: name, email address, phone number, address, and purchase history. Using the customer first or last name field as the primary key can lead to problems.

Step-by-step explanation:

A job where you would be likely to use spreadsheet software is as a financial analyst. You might use it to create financial models, analyze data, and create reports. Spreadsheet software allows you to input and manipulate numerical data efficiently, perform calculations, and visualize the information using charts and graphs.

If you were creating a customer database for your own company, some pieces of information you would want to keep track of include:

1. Customer name
2. Email address
3. Phone number
4. Address
5. Purchase history

The customer first or last name field should not be used as the primary key for a table because it is not guaranteed to be unique. Using a non-unique field as a primary key can create problems, such as duplication of records or difficulty in updating and deleting specific entries.

Learn more about Spreadsheet software and customer databases