Database Systems 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.
Envision that you have been enlisted as an advisor to help with streamlining the information preparing of a global based association that offers top of the line hardware. The association has different offices, for example, finance, HR, money, advertising, deals, and operations. The business office is the main division where workers are paid a commission notwithstanding their yearly pay and advantages. Every single other office remunerate their workers with a yearly compensation and advantages as it were. Commission is paid by increasing the worker's bonus rate by the aggregate sum of item units sold. You have entry to the accompanying information 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)
Write a nine to twelve (9-12) page paper in which you:
1. Plan an inquiry that will permit the money division to decide the commissions paid to particular workers of the business office for the month of December. Note: You should create the tables portrayed above (Employee, Invoice, InvoiceLine, Product, Department, and Job) so as to analyze and approve your code. Approved question code must be a piece of your paper
2. Analyze the code of the inquiry you planned in Question one (1) to one that would demonstrate the amount of aggregate pay is paid to every representative for that month.
3. Decide and disclose the variables important to guarantee referential honesty.
4. Make an item arranged model to show how the tables are interrelated using graphical apparatuses, for example, Microsoft Visio, or an open source option, for example, Dia. Ensure that you can demonstrate the relationship sorts, for example, 1:M, 1:1, or M:1. Moreover, recall to incorporate the decided variables from the past task necessity. Note: The graphically portrayed arrangement is excluded in the required page length.
5. Distinguish which information parts are the elements and qualities, and the relationship between every utilizing an item representation outline using graphical apparatuses, for example, Microsoft Visio, or an open source option, for example, Dia. Note: The graphically portrayed arrangement is excluded in the required page length.
6. Depict how Big Data could be utilized to help with the efficiency and anticipating of the association's items and assets.
Your assignment must follow these formatting requirements:
- Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format.
- Include a cover page containing the title of the assignment.
The cover page and the reference page are not included in the required assignment page length.
- Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted