So these are the spreadsheets For an Assignment . i have everything broken down . Only thing im stuck on is the third question here is the third question :

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

I got the tables set up like this i need to find what to put in the Assignment table left, need your help . here is the tables i have :

PERSON (Name, DateOfHire)

DEPARTMENT(DeptName, DeptManager)

PROJECT(ProjectID, NumHours, ProjectManager)

ASSIGNMENT()

: PERSON,DEPARTMENT,PROJECT,and ASSIGNMENT

Assume an employee has more than one assignment to a project.

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.