Database Systems and Database Models

  Database Systems and Database Models Imagin" rel="nofollow">ine that you have been hired as a consultant to assist in" rel="nofollow">in streamlin" rel="nofollow">inin" rel="nofollow">ing the data processin" rel="nofollow">ing of an in" rel="nofollow">international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, fin" rel="nofollow">inance, marketin" rel="nofollow">ing, sales, and operations. The sales department is the only department where em ployees are paid a commission in" rel="nofollow">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 multiplyin" rel="nofollow">ing the em ployee’s commission rate by the total amount of product units sold. You have access to the followin" rel="nofollow">ing data sets: Employee (Em pNumber, Em pFirstName, Em pLastName, CommissionRate, leySalary, DepartmentlD, Jole) Invoice (lnvNumber, lnvDate, Em pNumber, InvAmount) InvoiceLin" rel="nofollow">ine (InvLin" rel="nofollow">ineNumber, lnvNumber, ProductNumber, Quantity) Product (ProductNumber, ProductDescription, ProductCost) Department (DepartmentlD, DepartmentDescription) Job (Jole, JobDescription) Write a two to three (2-3) page paper in" rel="nofollow">in which you: Design a query that will allow the fin" rel="nofollow">inance department to determin" rel="nofollow">ine the commissions paid to specific employees of the sales department for the month of December. Note: You will need to generate the tables described above (Employee, Invoice, InvoiceLin" rel="nofollow">ine, Product, Department, and Job) in" rel="nofollow">in order to com pare and validate your code. Validated query code must be part of your paper. Com pare the code of the query you designed in" rel="nofollow">in Question one (1) to one that would show how much total compensation is paid to each employee for the same month. Determin" rel="nofollow">ine and explain" rel="nofollow">in the factors necessary to ensure referential in" rel="nofollow">integrity. Create an object-oriented model to show how the tables are in" rel="nofollow">interrelated through l...,,,, ”l “l, H H. l.types such as 1:M, 1:1, or M11 . Additionally, remember to in" rel="nofollow">include the determin" rel="nofollow">ined factors from the previous assignment requirement. Note: The graphically depicted solution is not in" rel="nofollow">included in" rel="nofollow">in the required page length. Identify which data components are the entities and attributes, and the relationship between each usin" rel="nofollow">ing an object representation diagram through the use of graphical tools. Note: The graphically depicted solution is not in" rel="nofollow">included in" rel="nofollow">in the required page length. Describe how Big Data could be used to assist in" rel="nofollow">in the productivity and forecastin" rel="nofollow">ing of the organization’s products and resources. Your assignment must follow these formattin" rel="nofollow">ing requirements: Be typed, double spaced, usin" rel="nofollow">ing Times New Roman font (size 12), with one-in" rel="nofollow">inch margin" rel="nofollow">ins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional in" rel="nofollow">instructions. Include a cover page contain" rel="nofollow">inin" rel="nofollow">ing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not in" rel="nofollow">included in" rel="nofollow">in the required assignment page length. Include charts or diagrams created in" rel="nofollow">in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams charts must be imported in" rel="nofollow">into the Word document before the paper is submitted. The specific course learnin" rel="nofollow">ing outcomes associated with this assignment are: Describe the role of databases and database management systems in" rel="nofollow">in managin" rel="nofollow">ing organizational data and in" rel="nofollow">information. Design and implement a database solution to solve a proposed busin" rel="nofollow">iness problem. Use technology and in" rel="nofollow">information resources to research issues in" rel="nofollow">in the strategic implications and management of database systems. Write clearly and concisely about topics related to the strategic plannin" rel="nofollow">ing for database systems usin" rel="nofollow">ing proper writin" rel="nofollow">ing mechanics and technical style CONVENTIONS