ER-Assistant
-
[ERD1]
w
Help
Employee
HH
7
=
E
Time
Sheet
PhS
SalesContact
ee
-++-
---Has----
oem
iH
SupervisoriNiT
TotalHours
SalesContactiD
OfficeLoc
Month
EmpEmail
A
SContactFirstNai
Salary
----AssignedTo
SContactLastNai
ae
Title
re
"
Client
Hh
-+Has-~
SContactPhone
=
2
oes
;
HoursWorked
SContactEmail
SEContactiD
Supervisor
=
ClientID
SEContactFirstNi
LegalName
ctLastN;
wees
Project
Commonliame
Ptt---Has----s--------2-----0-0
+H
ee
;
P+
---Works----+})
Contract
ho.
Hast
city
SEContactEmail
:
ProjectiD
State
ContractiD
,
=
oe
<p
HH
---Has~--+p
BillingContact
Manager
;
t+
------>
Oversees
D.C
GaContactO
ProjMa
BContactFirstNa!
BContactPhone
oneetnase
ContractRate
BContactEmail
MaxHours
Notes:
- Client Contact types may increase depending on its usefulness
- All contact information must be saved to ensure the ability to have an audit trail in case
something goes missing
- Records must be kept by employees for the amount of time spent on each project
- Employees are able to work on many projects at one time but must record the dates
worked on each project
- Project Managers ensure contracts are completed
-Because more than one project can be on one contract, if a contract has a maximum
number of hours. The project managers must determine the split of how many hours will
be worked on between the two projects.
Powered by TCPDF (www.tcpdf.org)
