CIS 515 Discussion Student Response Essay
|Assignment ID Number||AFFGEHU83939HD|
|Type of Document||Essay|
CIS 515 Discussion post responses.
Respond to the colleagues posts regarding:
· A relational Database Model allows database users to analyze data thoroughly. To accomplish this, advanced commands such as UNION and INTERSECT may be used. Describe a business scenario where a UNION relational set operator may be used to merge two similar data sets. Within the context of your business scenario, analyze the analysis and data consistency advantages of using a UNION operator rather than simply merging two data sets into one result table.
VHs post states the following:
A relational Database Model allows database users to analyze data thoroughly. To accomplish this, advanced commands such as UNION and INTERSECT may be used. Describe a business scenario where a UNION relational set operator may be used to merge two similar data sets. Within the context of your business scenario, analyze the analysis and data consistency advantages of using a UNION operator rather than simply merging two data sets into one result table.
Union command in the SQL combines with the results of two or more SELECT statements. In order for them to work each statement have to produce the same number of column. Data types have to be the same and the columns should be in the same order. For example, subset of employee information have to be selected from multiple tables within the database. Regardless of the department where the data is coming from hence employees for work.
SQL statement looks like this:
SELECT FName, LName, EEID, Position, Salary; FROM Finance; WHERE Salary>= 2500 UNION.
In a relational database model, the data can be analyzed by using the advance commands like UNION and INTERSECT. In a UNION relational set operator are used to with the combination of consumers data or data across database or across servers. UNION command have the ability to multiple tables with datasets that have the similar structures or vital information about the consumers or employees into one combined datasets.
Suppose you are tasked with finding common data elements amongst various data sets. Specify how an INTERSECT operator may assist you in accomplishing this task. Construct a query that can perform the same function as the INTERSECT operator without using the “INTERSECT” syntax within the query.
INTERSECT operator is almost the same as UNION command but the difference is the two SQL statements. UNION can act like an OR operator as well while INTERSECT command can act by an AND operator. See below how UNION query can function the same performance with the INTERSECT operator without INTERSECT syntax being used in the query.
SELECT EMPLOYEE. FIRSTNAME
FROM EMPLOYEE D
INNER JION CUSTOMER J
ON M. FIRSTNAME=CUSTOMER. FIRSTNAME
GROUP BY EMPLOYEE.FIRSTNAME, EMPLOYEE.LASTNAME, EMPLOYEE.ADDRESSLINE1, EMPLOYEE.CITYSTATEZIPCODE
CIS 515 Discussion Student Response Essay
0 – 1 Points
2 – 3 Point
4 – 5 Points
Unprofessional communication; many errors; no APA
Minor grammar, spelling, and APA errors
Postings are professional and in standard written English with APA
Complete addressing of assessment criteria
Criteria not fully addressed
Minimal response to criteria; minor aspects missing
All criteria are fully addressed
Evidence of critical thinking or extending information
Critical thinking or extending information not evident
Obvious responses to questions; little thought evident
Posts demonstrate critical thinking with evidence base from research or experience
No connections provided
Minimal connections provided to readings/activities
Clear connections to readings/activities
Submitted an overview / summary of the case selected for analysis. Also identified those procedural steps to be analyzed.
Did not provide an adequate overview or summary of the selected case or failed to identify those steps to be analyzed.
Provides an adequate overview or summary of the selected case and steps to be analyzed though may not be clear or complete.
Case overview is clearly presented including all appropriate investigative steps to be analyzed.
Tired of getting an average grade in all your school assignments, projects, essays, and homework? Try us today for all your academic schoolwork needs. We are among the most trusted and recognized professional writing services in the market.
We provide unique, original and plagiarism-free high quality academic, homework, assignments and essay submissions for all our clients. At our company, we capitalize on producing A+ Grades for all our clients and also ensure that you have smooth academic progress in all your school term and semesters.
High-quality academic submissions, A 100% plagiarism-free submission, Meet even the most urgent deadlines, Provide our services to you at the most competitive rates in the market, Give you free revisions until you meet your desired grades and Provide you with 24/7 customer support service via calls or live chats.