Venture 2: Database Applications and Database ModelsOracle Server may be used to test and compile the SQL Queries developed for this process. Take into consideration that you have been employed as a advisor to assist in streamlining the knowledge processing of a world based group that sells high-end electronics. The group has different departments equivalent to payroll, human property, finance, promoting, product sales, and operations. The product sales division is the one division the place employees are paid a charge together with their yearly wage and benefits. All completely different departments compensate their employees with a yearly wage and benefits solely. Payment is paid by multiplying the employee’s charge worth by the general amount of product gadgets purchased. You’ve got gotten entry to the following info models:Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID)Invoice (InvNumber, InvDate, EmpNumber, InvAmount)InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity)Product (ProductNumber, ProductDescription, ProductCost)Division (DepartmentID, DepartmentDescription)Job (JobID, JobDescription)Write a two to some (2-Three) internet web page paper whereby you:Design a query which will allow the finance division to search out out the commissions paid to explicit employees of the product sales division for the month of December. Observe:You need to to generate the tables described above (Employee, Invoice, InvoiceLine, Product, Division, and Job) as a strategy to consider and validate your code. Validated query code needs to be part of your paper.Study the code of the query you designed in Question one (1) to at the least one which may current how lots full compensation is paid to each employee for the same month.Resolve and make clear the elements wanted to verify referential integrity.Create an object-oriented model to level out how the tables are interrelated through utilizing graphical devices equivalent to Microsoft Visio, or an open provide completely different equivalent to Dia. Make certain that you can current the connection types equivalent to 1:M, 1:1, or M:1. Furthermore, consider to include the determined elements from the sooner process requirement. Observe: The graphically depicted reply is simply not included inside the required internet web page dimension.Set up which info components are the entities and attributes, and the connection between each using an object illustration diagram through utilizing graphical devices equivalent to Microsoft Visio, or an open provide completely different equivalent to Dia. Observe: The graphically depicted reply is simply not included inside the required internet web page dimension.Describe how Giant Data may be used to assist inside the productiveness and forecasting of the group’s merchandise and property. Your process ought to observe these formatting requirements:Be typed, double spaced, using Situations New Roman font (measurement 12), with one-inch margins on all sides; citations and references ought to observe APA or school-specific format. Study alongside along with your professor for any additional instructions.Embody a cover internet web page containing the title of the duty, the scholar’s title, the professor’s title, the course title, and the date. The quilt internet web page and the reference internet web page are often not included inside the required process internet web page dimension.Embody charts or diagrams created in Excel, Visio, MS Mission, or one among their equivalents equivalent to Open Mission, Dia, and OpenOffice. The completed diagrams / charts needs to be imported into the Phrase doc sooner than the paper is submitted.The exact course learning outcomes associated to this process are:Describe the operate of databases and database administration strategies in managing organizational info and information.Design and implement a database reply to resolve a proposed enterprise draw back.Use know-how and information property to evaluation factors inside the strategic implications and administration of database strategies.Write clearly and concisely about issues related to the strategic planning for database strategies using appropriate writing mechanics and technical kind conventions.