Sell your lecture notes and other study documents.
Test yourself and make money with homemade quiz questions.
Offer documents and quizzes together as a bundle and sell more.
Work as a tutor and help students with their studies.
View requests and send a proposal how you can help.
CIS 515 Week 2 Assignment 2 Database Systems And Database Models(8 pages word paper)
Assignment 2: Database Systems & Database Models
CIS 515 Strategic Planning for Database Systems
Assignment 2: Database Systems & Database Models 2
1. Query to determine the commission paid to specific employees in the month of December
After information is gathered about the employee; most of what was mentioned before, and input
into the system a query can be designed to pull that information from the tables. In order to pull
information from tables the SELECT function is used to determine the information that is needed
and the FROM function tells from what tables to pull it (Coronel, Morris & Rob, 2012). The
coding that was used to find information on commissions paid to employees was: SELECT
FROM Employee, Invoice
WHERE (Department ID =2);
The asterisk next to employees indicates that all the information under the employee table was
used to generate the search. In this query information was pulled from the employee and invoice
tables. The WHERE function more specifically states the department which can be changed
and it would generate new information. The query currently only shows employee commission
information for employees who work in department two.
SET LIN 250;
COLUMN "Commission Paid" FORMAT $99,990.00
SELECT e.EmpNumber, e.EmpLastName, i.InvNumber, i.InvDate,
e.CommissionRate ||'%' as "Commission Rate", ((e.CommissionRate/100)*i.InvAmount) as
FROM Employee2 e, Invoice2 i
WHERE e.EmpNumber = i.EmpNumber
AND i.InvDate >= '01-DEC-12'
AND i.InvDate <='31-DEC-12';
Download all 8 pages for € 6,49
871 documents uploaded
14 documents sold
Help in all Courses Dq's,Assignments and MCQS,Midterm & Final Exams(Expert in Commerce field )
Experience: 10 Years in online teaching field.
Do you make summaries or do you have any completed assignments? Upload your documents to Knoowy and earn money.
Upon registration you agree to our privacy statement and terms and conditions .
At Knoowy you buy and sell the best studies documents directly from students. Upload at least one item, please help other students and get € 2.50 credit.