kixrvh
contestada

1. 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)
2. List at least five pieces of information you would want to keep track of if you were creating a customer database for your own company. Complete sentences are not necessary. (2.5 points)
3. 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 create? (1-4 sentences. 3.0 points)
4. Describe a report that a company might want to create and run on a regular basis. (1-3 sentences. 3.0 points)
5. List at least two types of internal events that a company could plan in order to improve employee morale. (1-2 sentences. 2.0 points)
6. List at least two types of external events that a company could plan in order to increase sales or publicity. (1-2 sentences. 2.0 points)

Respuesta :

antonsandiego
1. Spreadsheet software is commonly used in databases. So there are many different jobs like sales manager or HR. It's very useful to store the data about sales and customers in the spreadsheet, as it provides you a possibility to create customer database and analyze your sales. There are many useful software which will help you with analyzing databases in spreadsheets. You can use Orange or something else.

2. Here's my list:
    1. Customer's ID
    2. Product ID
    3. Quantity that had been sold
    4. Price
    5. When it had been sold
    6. Seller's ID

3. There could be a customer with the same name or surname. It could cause a mess in your database if the customer wants payback for something and there will be the customer with the same name. I think that the primary key should be consisted of unique Customer's ID number.

4. It's quite difficult to answer this question. It depends on what kind of DBMS your company uses. It's very important.

5. My favorite types are:
Intervention. It will help you to find out if there some issues about relationship between you and your staff. You should listen to your staff and respect their opinion.
Communication. That will help you to find out the way your staff communicating with each other and then find out if there's something wrong with someone's behavior.

6. In my view the best ways to increase sales and publicity are:
Events like buy one/two get another free could really increase company's sales and publicity.

Communication with publicity by appearing on channels, popular websites or video hostings would really increase publicity.

It should be noted that a Spreadsheet software is commonly used in databases.

Spreadsheet

The pieces of information that one can keep track of include Customer's ID, Product ID, Quantity sold, Price, Seller's ID, etc.

Using customer first or last name field as the primary key for a table can lead to issues when there are multiple surnames.

A report that a company may want to run on a regular basis is the number of sales made let day.

Learn more about spreadsheet on:

https://brainly.com/question/4965119

Otras preguntas