Your firm has been hired to design, implement and secure a database management system (OLTP) for a fictitious retail company. The company sells goods (clothing, Shoes, groceries, home appliances, toys, sporting goods, furniture, and music etc.) online or via visiting one of their several stores. The departments that make up this organization consist of Human resource, Marketing, Customer relation, Logistics (distribution), Inventory/merchandise management, Sales, Purchasing, Finance, and Product management. The initial engagement will focus on the creation of the entities for Human resource, Customer relation, Marketing, and Product management • Create and populate the entities • Provide concise documentation on your implementation Example of Human Resource and Customer entities: Employee, Employee PayHistory, Department Customer, CustomerContactType, CustomerEmailAddress, Customer Phone Number
