The following spreadsheets form a set of named spreadsheets with the indicated c

Question

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

Name of spreadsheet: EQUIPMENT

Column headings: Number, Description, AcquisitionDate, AcquisitionPrice

Name of spreadsheet: COMPANY

Column headings: Name, IndustryCode, Gross Sales, OfficerName, OfficerTitle

Name of spreadsheet: COMPANY

Column headings: Name, IndustryCode, Gross Sales, NameOfPresident

Name of spreadsheet: COMPUTER

Column headings: SerialNumber, Make, Model, DiskType, DiskCapacity

Name of spreadsheet: PERSON

Column headings: Name, DateOfHire, DeptName, DeptManager, ProjectID, NumHours, ProjectManager

1.31 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 any spreadsheet that has more than one theme, show at least one modification problem that will occur when inserting, updating, or deleting data.

1.33 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.

p.s. please no photographed notebook paper. I don't see well and its hard for me to study from

Explanation / Answer

Name of spreadsheet: EQUIPMENT
Column headings: Number, Description, AcquisitionDate, AcquisitionPrice

Theme: Equipment acquisition details

Name of spreadsheet: COMPANY
Column headings: Name, IndustryCode, Gross Sales, OfficerName, OfficerTitle

Theme: Company details, sales details, officer details (assuming there are many officers in a company)

Name of spreadsheet: COMPANY
Column headings: Name, IndustryCode, Gross Sales, NameOfPresident

Theme: Company details, sales details, Company wise presidents (assume 1 president per company)

Name of spreadsheet: COMPUTER
Column headings: SerialNumber, Make, Model, DiskType, DiskCapacity

Theme: computer configuration details

Name of spreadsheet: PERSON
Column headings: Name, DateOfHire, DeptName, DeptManager, ProjectID, NumHours, ProjectManager

Theme: Person details, manager details

Since there are 2 spreadsheets with name COMPANY that contain gross sales, insertion/update/deetion of Gross sales in 1 table can cause modification problem since the other table will have outdated data.

The columns in both the COMPANY spreadsheets can be split up as:

Name of spreadsheet: SALES
Column headings: IndustryCode, Gross Sales

Name of spreadsheet: OFFICERS
Column headings: IndustryCode, OfficerName, OfficerTitle

Name of spreadsheet: COMPANY
Column headings: Name, IndustryCode, NameOfPresident

The spreadsheet PERSON can be split up as:

Note: Person ID is a new field

Name of spreadsheet: PERSON
Column headings: Person ID, Name, DateOfHire, DeptName, DeptManager

Name of spreadsheet: PROJECT
Column headings: Person ID, ProjectID, NumHours, ProjectManager

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.