Modification Problems and Themes -

The following spreadsheets (A - E) each have a name and certain columns. (You have to imagine what the data might be.) Answer questions 1 - 3 below for each of the spreadsheets.

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

Name of spreadsheet: COMPANY Column headings: Name, IndustryCode, GrossSales, OfficerName, OfficerTitle Assumption: Companies belong to industries. For example, Wal-Mart and Target belong to the retail industry.

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

Name of spreadsheet: COMPUTER Column Headings: SerialNumber, Make, Model, DiskType, DiskCapacity Assumption: Each computer has its own serial number.

Name of spreadsheet: PERSON Column Headings: Name, DateOfHire, DeptName, DeptManager, ProjectID, NumHours, ProjectManager Assume that employees can be assigned to more than one project. This is similar to students enrolling in more than one course.

Question 1: For each spreadsheet (A - E), 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.

Question 2: For any spreadsheet (A - E) that has more than one theme, show at least one modification problem that will occur when inserting, updating, or deleting data. Use specific column names to describe each problem.

Question 3: For any spreadsheet (A - E) 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. Use the table representation shown in the Study Guide and in class (not shown in Chapter 1 of the textbook, but will be in Chapter 2), like this:

STUDENT (StudentLastName, StudentFirstName, StudentEmail, Phone, Residence, AdviserLastName) ADVISER (AdviserLastName, AdviserFirstName, AdviserEmail)