CIS 515 STUDY Learn Do Live /cis515study.com CIS 515 STUDY Learn Do Live /cis515study.com | Page 5

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.