Problem 39
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.
Problem 40
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.
Problem 41
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).
Problem 43
Compare a database with a database management system.
Problem 44
What is a database schema?
Problem 45
Describe the general organization of a relational database.
Problem 46
What is a field (attribute) in a database?
Problem 49
What is a key in a relational database table?
Problem 51
How are relationships represented in a relational database?
Problem 52
Define an SQL query that returns all attributes of all records in the Customer table.
