employees employee employee.firstname employees.firstname Employees(EmpId*, EmployeeFirstName, EmployeeLastName, CompanyId, EmploymentDate) 1NF: Orders(OrderId*, CustomerId@, OrderDate) OrderDetails(OrderId*@, ItemId*, ProductId, Quantity, ProductName) 3NF: Customers(CustomerId*, CustomerName) Orders(OrderId, CustomerId, OrderDate) Products(ProductId*, ProductName) Orders(OrderId*, CustomerId@, OrderDate) OrderDetails(OrderId*@, ItemId*, ProductId@, Quantity) UNF: Projects(ProjectId*, ProjectName, CustomerId, CustomerName, Activities(Activity1Id*, Activity1Name, …, ActivityNId, ActivityNName), Employees(Employee1Id, Employee1Name, …, EmployeeNId, EmployeeNName), WorkDate, TimeSpent) 1NF: Projects(ProjectId*, ProjectName, CustomerId, CustomerName) ProjectDetails(ProjectId*@, ItemId*, ActivityId, ActivityName, EmployeeId, EmployeeName, WorkDate, TimeSpent) 3NF: Projects(ProjectId*, ProjectName, CustomerId) ProjectDetails(ProjectId*@, ItemId*, ActivityId, EmployeeId, WorkDate, TimeSpent) Customers(CustomerId, CustomerName) Activities(ActivityId, ActivityName) Employees(EmployeeId, EmployeeName)