described above ( Employee , Invoice , InvoiceLine , Product , Department , and Job ) in order to compare and validate your code . Validated query code must be part of your paper .
Compare the code of the query you designed in Question one ( 1 ) to one that would show how much total compensation is paid to each employee for the same month .
Determine and explain the factors necessary to ensure referential integrity .
Create an object-oriented model to show how the tables are interrelated through the use of graphical tools such as Microsoft Visio , or an open source alternative such as Dia . Make sure that you are able to show the relationship types such as 1 : M , 1:1 , or M : 1 . Additionally , remember to include the determined factors from the previous assignment requirement . Note : The graphically depicted solution is not included in the required page length .
Identify which data components are the entities and attributes , and the relationship between each using an object representation diagram through the use of graphical tools such as Microsoft Visio , or an open source alternative such as Dia . Note : The graphically depicted solution is not included in the required page length .
Describe how Big Data could be used to assist in the productivity and forecasting of the organization ’ s products and resources .
Your assignment must follow these formatting requirements :
Be typed , double spaced , using Times New Roman font ( size 12 ), with one-inch margins on all sides ; citations and references must follow APA or school-specific format . Check with your professor for any additional instructions .