Chapter 12

For Exercises 1-20, mark the answers true or false as follows: A. True B. False A cell in a spreadsheet can contain only raw data.

A spreadsheet is useful for performing what-if analysis.

What-if analysis can affect only one value at a time in a spreadsheet.

A database table is a collection of records, and a record is a collection of fields.

E-commerce is the process of keeping financial records, such as accounts payable, online.

For Exercises 21-25, match the solution to the question. A. dynamic D. range B. function E. schema C. circular F. field A spreadsheet is ____ in that it responds to changes in the data by immediately updating all affected values.

A spreadsheet formula may operate on a ____ of cells, such as C4..C18.

What is a spreadsheet circular reference? Why is it a problem?

Name some what-if analysis questions that you might ask if you were using a spreadsheet to plan and track some stock purchases. Explain how you might set up a spreadsheet to help answer those questions.

What is what-if analysis?

For Exercises 39-42, use the paper spreadsheet form supplied on the textbook's website or use an actual spreadsheet application program to design the spreadsheets. Your instructor may provide more specific instructions regarding these questions. Design a spreadsheet to track the statistics of your favorite major league baseball team. Include data regarding runs, hits, errors, and runs batted in (RBIs). Compute appropriate statistics for individual players and the team as a whole.

Design a spreadsheet to maintain a grade sheet for a set of students. Include tests and projects, giving various weights to each in the calculation of the final grade for each student. Compute the average grade per test and project for the whole class.

Assume you are going on a business trip. Design a spreadsheet to keep track of your expenses and create a summary of your totals. Include various aspects of travel such as car mileage, flight costs, hotel costs, and miscellaneous expenses (such as taxis and tips).

Compare a database with a database management system.

What is a database schema?

Describe the general organization of a relational database.

What is a field (attribute) in a database?

What is a key in a relational database table?

How are relationships represented in a relational database?

Define an SQL query that returns all attributes of all records in the Customer table.

Define an SQL query that returns the address of every customer in the Customer table who lives on Lois Lane.

Define an SQL statement that deletes the customer with a Customerld of 103 .

What is an ER diagram?

How are entities and relationships represented in an ER diagram?

How are attributes represented in an ER diagram?

What are cardinality constraints, and how are they shown in ER diagrams?

What are the three general cardinality constraints?

What were some of the webbased technologies that allowed e-commerce to become viable?

What is big data? How does it relate to spreadsheets and databases?

Name three challenges in big data analysis.