The following are a set of named spreadsheets with the indicated column headings. Use these spreadsheets

The following are a set of named spreadsheets with the indicated column headings. Use these spreadsheets to answer exercises 1.30 through 1.32.

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)

1.30 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.32 For the spreadsheets that have 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.