Blog

Database Systems and Database Models

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)
Write a two to three (2-3) page paper in which you:

Design a query that will allow the finance department to determine 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, InvoiceLine, Product, Department, and Job) in order to compare and validate your code. Validated query code must be part of your paper.
Compare the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.
Determine and explain the factors necessary to ensure referential integrity.
Create an object-oriented model to show how the TABLES are interrelated through the use of graphical tools. Make sure that you are able to show the relationship types such as 1:M, 1:1, or M:1. Additionally, remember to include the determined factors from the previous assignment requirement. Note: The graphically depicted solution is not included in the required page length.
Identify which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical TOOLS. Note: The graphically depicted solution is not included in the required page length.
Describe how Big Data could be used to assist in the productivity and forecasting of the organization?s products and resources.
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. Check with your professor for any additional instructions.
Include a cover page containing 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 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.
The specific course learning outcomes associated with this assignment are:

Describe the role of databases and database management systems in managing organizational data and information.
Design and implement a database solution to solve a proposed business problem.
Use technology and information resources to research issues in the strategic implications and management of database systems.
Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.

Points: 90
Assignment 2: Database Systems and Database Models
Criteria
Unacceptable

Below 70% F
Fair

70-79% C
Proficient

80-89% B
Exemplary

90-100% A
1. Design a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December.

Weight: 15%
Did not submit or incompletely designed a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December.
Partially designed a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December.
Satisfactorily designed a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December.
Thoroughly designed a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December.
2. Compare the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.

Weight: 10%
Did not submit or incompletely compared the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.
Partially compared the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.
Satisfactorily compared the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.
Thoroughly compared the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.
3. Determine and explain the factors necessary to ensure referential integrity.

Weight: 10%
Did not submit or incompletely determined and explained the factors necessary to ensure referential integrity.
Partially determined and explained the factors necessary to ensure referential integrity.
Satisfactorily determined and explained the factors necessary to ensure referential integrity.
Thoroughly determined and explained the factors necessary to ensure referential integrity.
4. Create an object-oriented model to show how the tables are interrelated through the use of graphical tools.

Weight: 20%
Did not submit or incompletely created an object-oriented model to show how the tables are interrelated through the use of graphical TOOLS.
Partially created an object-oriented model to show how the tables are interrelated through the use of graphical tools.
Satisfactorily created an object-oriented model to show how the tables are interrelated through the use of graphical tools.
Thoroughly created an object-oriented model to show how the TABLES are interrelated through the use of graphical tools.
5. Identify which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools.

Weight: 20%
Did not submit or incompletely identified which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools.
Partially identified which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools.
Satisfactorily identified which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools.
Thoroughly identified which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools.
6. Describe how Big Data could be used to assist in the productivity and forecasting of the organization?s products and resources.

Weight: 15%
Did not submit or incompletely described how Big Data could be used to assist in the productivity and forecasting of the organization?s products and resources.
Partially described how Big Data could be used to assist in the productivity and forecasting of the organization?s products and resources.
Satisfactorily described how Big Data could be used to assist in the productivity and forecasting of the organization?s products and resources.
Thoroughly described how Big Data could be used to assist in the productivity and forecasting of the organization?s products and resources.
7. Clarity, writing mechanics, and formatting requirements

Weight: 10%
More than 6 errors present
5-6 errors present
3-4 errors present
0-2 errors present

think about the background of many creole revolutionaries. what do you think might have been their tendencies as government leaders…

think about the background of many creole revolutionaries. what do you think might have been their tendencies as government leaders toward democracy or authoritarism? explain your answer.

What factors and why helped to advance the integration of the national economy after the Civil War?

What factors and why helped to advance the integration of the national economy after the Civil War?

ELECTRONICSengineering lab report

Transistor Biasing Materials and Equipment: Materials: Hardware Parts (In the Toolbox): An NPN transistor: 2N3904 Four resistors: 1 k?, 470?, 3 k? and 6 k? Jumper wires Equipment: Hardware Equipment: Breadboard NI myDAQ Instrument device Screw Driver Screw Terminal connector USB CABLE Multimeter with probes Multimeter from NI ELVISmx Instrument Launcher Procedure: *** This lab has to be implemented only in hardware (using NI myDAQ) *** Analyze the circuit in the Figure 1 below to calculate the following values: VBB, VE, IE, VC and VCE. Make sure to include 20% tolerance for each resistor in the calculations. Construct the circuit shown in Figure 1 below on the breadboard using the transistor and two resistors (RCand RE). figure 1 Figure 1 Using the jumper wires, screw driver and screw terminal connector, connect the board to NI MyDAQ Instrument Device. Use channel +15V pin out on the NI myDAQ Instrument Device to provide the supply voltage (VCC). Use channel AI0 to measure the required voltages: VBB, VE and VC and currents: IC and IE using the Multimeter. Tabulate the data from step 1 and step 5. Calculated Measured VBB VE VC IE IC Short the resistor R2 and calculate the values in steps 1. Modify the circuit in Figure 1 to short the resistor R2 and measure the values in step 4. Measured values with R2 shorted VBB VE VC IE IC Review questions: Compare a calculated and measured values in the table. Discuss whether the values are the same of different. If they are different, provide the reasoning. And how to reduce this difference between calculated and measured values. What happens when R2 is shorted? Why does the measured values change? If the NPN transistor is replaced with a PNP transistor, how does the change in the transistor effect the current and voltage in the circuit? Deliverables: Analysis of the circuit and calculations of voltages: VBB, VE and VC and currents: IC and IE. Place your student ID card on the breadboard and take a picture of the circuit board and pin out on the NI myDAQ Instrument Device. Take screenshots of the measurements obtained from function generator and Multimeter on the NI ELVISmx Instrument Launcher on your screen. Lab Report: Use the Lab report template found in the ?Tools and Template? link in the navigation center. Include all the deliverables. Include all the screenshots of the measurements from circuit design on the breadboard using NI myDAQ Instrument Device and measurements from MI ELVISmx Instrument Launcher.

Database Modeling”
–contennt–
“Database Modeling” Please respond to the following:
Following a data model is IMPORTANT in the planning of a database system. Evaluate at least two classic models that are used in providing structure for database solutions.
Compare and contrast the effectiveness of classic models and recently evolved models such as Big Data and NoSQL. Give your opinion on which type of model is more effective and why.

Maintaining Data Integrity

Maintaining Data Integrity” Please respond to the following:
Describe the IMPORTANCE of maintaining integrity rules throughout the database structure. Create at least three examples of common relationships that are used within a relational database system. Justify your response.
Many times, database designs do not include the proper use of indexes. Provide a specific example on how an index could be used in order to enhance user search experience. List specific fields that you would index. Analyze what would occur if the proper index is not included, with respect to your example

Business Research / Statistics

Append (i.e., add to last week’s team paper to continue the paper) the Week 2 Business Research Project Part 1 paper with the following:
Each team member should:
Find three articles relevant to your research problem with a minimum of one being peer-reviewed. Sources of non-peer reviewed articles may be trade journals or other sources recommended by your instructor.
Provide a BRIEF summary of each article by selecting relevant research that addresses the variables in the research question(s) of the article. Similar articles may be summarized together by mentioning and referencing each article in the same paragraph.
Use an in-text citation and reference for each article. That is, you can reference the article(s) you are summarizing within the summary and then also include the article(s) in the reference SECTION.
A literature review just means that you look up articles, and you can do that in the library, that are peer reviewed and find three (two peer reviewed) that discuss similar things to our research question.

police investigatio

1. Police investigating an apparent suicide collect the following items at the scene: A note purportedly written by the victim, a revolver bearing very faint fingerprints, and traces of skin and blood under the victim’s fingernails.
What units of the crime laboratory will examine each piece of evidence?

2. What kind of search pattern(s) would investigators be most likely to employ in each of the following situations:

a) Two people searching a small area with well-defined boundaries.

b) Several people searching a large area

c) A single person searching a large area

Research Design and t Tests: How Are They Connected?

Research Design and t Tests: How Are They Connected?
The best way to solidify your understanding of statistical testing is to actually engage in performing some data analysis. This week you will work with a real, secondary dataset to construct a research question, perform a t test, and interpret the results.
Whether in a scholarly or practitioner setting, good research and data analysis should have the benefit of peer feedback. For this Discussion, you will post your response to the hypothesis test, along with the results. Be sure and remember that the goal is to obtain constructive feedback to improve the research and its interpretation, so please view this as an opportunity to learn from one another.
To prepare for this Discussion:
Review the Learning Resources and the media programs related to t tests.
Using the SPSS software, open the High School Longitudinal Study dataset found in this week?s Learning Resources and construct a research question that involves a comparison of a means test.
Use SPSS to answer the research question you constructed and post your response to the following:
What is your research question?
What is the null hypothesis for your question?
What research design would align with this question?
What comparison of means test was used to answer the question (be sure to defend the use of the test using the article you found in your search)?
What dependent variable was used and how is it measured?
What independent variable is used and how is it measured?
If you found significance, what is the strength of the effect?
Identify your research question and explain your results for a lay audience, what is the answer to your research question?
Be sure to support your Main Post and Response Post with reference to the week?s Learning Resources and other scholarly evidence in APA Style.

are the women of the !Kung oppressed or controlled by men? Are the men ?dominated? by the women? Why.

Write 4-5 pages, are the women of the !Kung oppressed or controlled by men? Are the men ?dominated? by the women? Why.

reference three readings that i will provide.