| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST1600/Resources/Week/15/ |
Upload File : |
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)