SalesStaff(EmployeeID*, FirstName, LastName, OfficeId@)
SalesStaff_Customer(EmployeeID, CustomerID*@)
Customer(CustomerID*, Name)
Office(OfficeId*, Name, Phone)


Projects(ProjectId, ProjectName, CustomerId, CustomerName,Activities(Activity1Id, Activity1Name, …, ActivityNId, ActivityNName), Employees(Employee1Id, Employee1Name, …, EmployeeNId, EmployeeNName), WorkDate, TimeSpent)

Projects(ProjectId*, ProjectName, CustomerId@)
ProjectDetails(ProjectId*, ItemId*, ActivityId@, EmployeeId@, WorkDate, TimeSpent) 
Customers(CustomerId*, CustomerName) 
Activities(ActivityId*, ActivityName)
Employees(EmployeeId*, EmployeeName) 

EmployeeID	EmployeeName	City	Department
101	Amit	Kolhapur	OBIEE
101	Amit	Kolhapur	COGNOS
102	Divya	Indore	COGNOS
103	Yodhini	Hydrabad	SIEBEL
104	Amit	Kolhapur	ETL

Employee(EmployeeID*	EmployeeName	City)
101	Amit	Kolhapur
102	Divya	Indore
103	Yodhini	Hydrabad
104	Amit	Kolhapur

Employee_Department(EmployeeID*, Department*)
101 OBIEE
101 COGNOS
102 COGNOS
103 SIEBEL
104 ETL

Department(Department*)
OBIEE
COGNOS
SIEBEL
ETL