Need help On a question 3 For a theme Database project .

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

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

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

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

E.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 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: