MIS homework

profilemark39
Ch05Ex03_U7e.xlsx

Employee

ID FirstName LastName Department
1 Marvin Pine Purchasing
2 Andrea Ashley Marketing
3 Elton Maple Marketing
4 Melissa Brooks Accounting
5 Stan Calbro Human Resourse
6 Hal Scott Operations

Computer

SerialNumber Brand PurchaseCost OperatingSystem EmployeeID
400 Sony $1,750.00 Windows 8 1
500 Lenovo $900.00 Windows 7 6
200 Toshiba $1,050.00 Windows 7 6
300 Dell $1,475.00 Windows 8 3
600 Dell $1,195.00 Windows 7 4
700 Lenovo $1,325.00 Windows 7 5
900 Dell $1,800.00 Windows 7 5
100 Dell $1,750.00 Vista 2
800 HP $750.00 Windows 8 2

Sheet3