(Solved): The following spreadsheets form a set of named spreadsheets with the indicated column headings. Us ...

The following spreadsheets form a set of named spreadsheets with the indicated column headings. Use these spreadsheets to answer exercises \( 1.37 \) through 1.39. A. Name of spreadsheet: EQUIPMENT Column headings: Number, Description, AcquisitionDate, AcquisitionPrice B. Name of spreadsheet: COMPANY Column headings: Name, IndustryCode, Gross Sales, OfficerName, OfficerTitle C. Name of spreadsheet: COMPANY Column headings: Name, IndustryCode, Gross Sales, NameOfPresident D. Name of spreadsheet: COMPUTER Column headings: SerialNumber, Make, Model, DiskType, DiskCapacity E. Name of spreadsheet: PERSON Column headings: Name, DateOfHire, DeptName, DeptManager, ProjectID, NumHours, ProjectManager Chapter 1 Getting Started 65 1.37 For each of the spreadsheets provided, indicate the number of themes you think the spreadsheet includes and give an appropriate name for each theme. For some of them, the answer may depend on the assumptions you make. In these cases, state your assumptions. 1.38 For any spreadsheet that has more than one theme, show at least one modification problem that will occur when inserting, updating, or deleting data. 1.39 For any spreadsheet that has more than one theme, break up the columns into tables such that each table has a single theme. Add ID columns if necessary, and add a linking column (or columns) to maintain the relationship between the themes.