The following spreadsheets form a set of named spreadsheets with the indicated column head...

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

The following spreadsheets form 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

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.