Question: I have a modification problems and theme question . The following spreadsheets (A - E) each have a name and certain columns. (You have to

I have a modification problems and theme question .

The following spreadsheets (A - E) each have a name and certain columns. (You have to imagine what the data might be.) Answer questions 2 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 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!