and increase sales . For your hired role , you will be responsible for creating and maintaining an enterprise-wide database system that will hold the sales and inventory data for the organization . The designed database will help operations in supporting its new business marketing strategy . Using the concepts presented throughout the course , you will develop a plan to create this database and establish a design that aligns with the product sales initiatives of the organization .
Write a twelve to fifteen ( 12-15 ) page paper in which you :
1 . Identify the potential sales and department store transactions that can be stored within the database .
2 . Design a database solution and the potential business rules that could be used to house the sales transactions of the department store .
3 . Evaluate all relationships of each entity within your database solution using the Crow ’ s Foot notation . Include all data elements , entities , relationships ( such as 1 : M , 1:1 , M : N ), and cardinalities for the department store database in your diagram . Note : The graphically depicted solution is not included in the required page length .
4 . Research the Internet for best practices of how retail stores use databases for retaining customers and increasing sales and complete the following :
a . Justify how Big Data tools could be used for forecasting sales and inventory of the department store .
b . Propose two ( 2 ) SQL Stored Procedures that use SQL functions to help sales associates perform explanatory or predictive analytics .