CIS 515 All Assignments CIS 515 All Assignments | Page 4

www.foxtutor.com/product/cis-515-week-2-assignment-2-database-
systems-and-database-models-(2-papers)
CIS 515 WEEK 2 ASSIGNMENT 2 DATABASE SYSTEMS AND DATABASE MODELS
Assignment 2: Database Systems and Database Models
The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this
assignment. Your instructor will provide you with login credentials to a Strayer University
maintained Oracle server.
Imagine that you have been hired as a consultant to assist in streamlining the data processing
of an international based organization that sells high-end electronics. The organization has
various departments such as payroll, human resources, finance, marketing, sales, and
operations. The sales department is the only department where employees are paid a
commission in addition to their yearly salary and benefits. All other departments compensate
their employees with a yearly salary and benefits only. Commission is paid by multiplying the
employee’s commission rate by the total amount of product units sold. You have access to the
following data sets:
Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary,
DepartmentID, JobID)
Invoice (InvNumber, InvDate, EmpNumber, InvAmount)
InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity)
Product (ProductNumber, ProductDescription, ProductCost)
Department (DepartmentID, DepartmentDescription)
Job (JobID, JobDescription)