Database Systems and Database Models
The Strayer Oracle Server could also be used to check and compile the SQL Queries developed for this task. Your teacher will give you login credentials to a Strayer College maintained Oracle server. Think about that you've been employed as a advisor to help in streamlining the information processing of a global primarily based group that sells high-end electronics. The group has numerous departments corresponding to payroll, human sources, finance, advertising and marketing, gross sales, and operations. The gross sales division is the one division the place staff are paid a fee along with their yearly wage and advantages. All different departments compensate their staff with a yearly wage and advantages solely. Fee is paid by multiplying the worker’s fee fee by the whole quantity of product items bought. You've gotten entry to the next knowledge units: Worker (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) Bill (InvNumber, InvDate, EmpNumber,  InvAmount) InvoiceLine (InvLineNumber, InvNumber,  ProductNumber, Amount) Product (ProductNumber, ProductDescription, ProductCost) Division (DepartmentID, DepartmentDescription) Job (JobID, JobDescription) Write a two to 3 (2-Three) web page paper during which you: Design a question that may permit the finance division to find out the commissions paid to particular staff of the gross sales division for the month of December. Word: You'll need to generate the tables described above (Worker, Bill, InvoiceLine, Product, Division, and Job) to be able to evaluate and validate your code. Validated question code should be a part of your paper. Evaluate the code of the question you designed in Query one (1) to 1 that may present how a lot complete compensation is paid to every worker for a similar month. Decide and clarify the components needed to make sure referential integrity. Create an object-oriented mannequin to indicate how the tables are interrelated via the usage of graphical instruments. Make it possible for you'll be able to present the connection sorts corresponding to 1:M, 1:1, or M:1. Moreover, bear in mind to incorporate the decided components from the earlier task requirement. Word: The graphically depicted resolution just isn't included within the required web page size. Determine which knowledge parts are the entities and attributes, and the connection between every utilizing an object illustration diagram via the usage of graphical instruments. Word: The graphically depicted resolution just isn't included within the required web page size. Describe how Large Information may very well be used to help within the productiveness and forecasting of the group’s merchandise and sources.