Description
Due Week 7 and worth 75 points
Refer to the database design crested in Lab 2: Modifying a Database Design in Visio to complete this Lab.
Perform the following steps in MySQL:
- Create the tables and relationships from the database design discussed in Lab 2.
- Add at least five (5) records into each table (Note: You must determine the field values).
- Create a query with all fields from the student table, where the student's last name is "Smith".
- Create a query that includes students’ first names, last names, and phone numbers.
- Create a query that includes instructors' first names, last names, and courses they teach.
Include the following screen shots in a Microsoft Word document to show the completion of the steps above:
- Screen shot depicting the tables created within MySQL.
- Screen shots depicting the records added into each table.
- Screen shots depicting the SQL code and the query results from each of the queries created.
Your assignment must follow these formatting requirements:
- Submit the lab as a Microsoft Word document.
- 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 is not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:
- Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
Click here to view the grading rubric for this assignment.
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Just what I needed…Fantastic!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
University of Potomac System Analysis and Design Essay
Prepare a 1 or 2 page report explaining Web 2.0 and cloud computing. Using the text and your own Internet research, briefl ...
University of Potomac System Analysis and Design Essay
Prepare a 1 or 2 page report explaining Web 2.0 and cloud computing. Using the text and your own Internet research, briefly describe the five most important points in your report. Perform research on the Internet to learn about emerging trends in wireless networking, and typical costs involved in the installation of a wireless LAN. Prepare a 1 or 2 page report on your findings. Using the material in the text and your own Internet research, prepare a 1 or 2 page report on the pros and cons of agile development methods.Writing Requirements3–4 pages in length (excluding cover page, abstract, and reference list)Include at least three peer reviewed sourcesUse APA Style for in-text citations, and referencesTextbook: Tilley, S. and Rosenblatt, H. (2019) Systems Analysis and Design (Shelly Cashman Series), 12th Edition. Independence, KY: Cengage Learning. ISBN:9780357117897 Please use more than two references. You can use one from textbook mentioned above.
CPT 307 Ashford University CH1 Data Structures and Algorithms Home Project
Calculate Pay Program
Prior to beginning work on this assignment, review Chapter 1 in Data Structures Essentials and the 4 ...
CPT 307 Ashford University CH1 Data Structures and Algorithms Home Project
Calculate Pay Program
Prior to beginning work on this assignment, review Chapter 1 in Data Structures Essentials and the 4 Major Principles of Object-Oriented Programming (Links to an external site.) article. Then access the required websites for Java syntax, the Lesson: Object-Oriented Programming Concepts (Links to an external site.) tutorial, and Java OOPs Concepts (Links to an external site.) from the JavaTpoint website.
Students: Be sure to download and save a PDF version of your textbook for future reference. It will be used in later courses within your program, including the final, capstone course. Zybooks limits online access to your course textbooks to a 12-month period. (Zybook Download Instructions download)
For this assignment, you will take on the role of software developer as part of a team of developers for a retail company. The payroll manager of the company has tasked you with developing a Java program to quickly calculate an employee’s weekly gross and net pay. The program must prompt the user to enter the employee’s name, rate of pay, and hours worked. The output will display the information entered into the program along with the calculations for gross pay, total amount of deductions, and net pay.
In this coding assignment, you will utilize the Java syntax and techniques you learned while reviewing the required resources for Week 1. You may select appropriate variable names as long as proper Java syntax is used. You will also submit your source code.
Input:
In the input section, utilize Java syntax and techniques to input the employee’s name, rate of pay, and hours worked. The input should be completed either via keyboard or via file. As a last resort, the data can be hard-coded into the program.
The input for this calculation is in the Pay Calculation downloadtable.
Processing:
In the processing section, the following calculations will need to be performed in the processing section:
Gross Pay:
Gross pay if hours worked are 40 hours or less = hours worked * rate of pay
Gross pay if hours worked are greater than 40 hours = ((hours worked – 40) * (rate of pay * 1.5)) + (40 * rate of pay)
Example – Employee worked 55 hours. The employee’s rate of pay is $10.00.
((55 – 40) * (10 * 1.5)) + (40 * 10) = 625
The gross pay is $625.
Deductions:
Deductions are calculated based upon the following rates:
Federal Tax = 15%
State Tax = 3.07%
Medicare = 1.45%
Social Security = 6.2%
Unemployment Insurance = .07%
The following calculations are used to calculate each deduction:
Federal tax amount = federal tax rate* gross pay
State Tax amount = state tax rate * gross pay
Medicare amount = Medicare rate * gross pay
Social Security amount = social security rate * gross pay
Unemployment Insurance amount = unemployment insurance amount * gross pay
Total deductions = Federal Tax amount + State Tax amount + Medicare amount + Social Security amount + Unemployment Insurance amount
Net Pay:
The net pay amount is calculated as follows:
Net pay = gross pay amount – total deductions
Output:
The Java program should display the following information:
Employee Name
Rate of Pay
Hours Worked
Overtime Worked
Gross Pay
Total amount of deductions
Net Pay
Your code must include the following as comments:
Name of program
Author/student’s name
Course name and number
Instructor’s name
Date submitted
MU Designing a Cloud System Billing & Non Technical Considerations Discussion
WRITE IN YOUR OWN WORDS! This week, you will learn about a slightly less technical, albeit still important component of cl ...
MU Designing a Cloud System Billing & Non Technical Considerations Discussion
WRITE IN YOUR OWN WORDS! This week, you will learn about a slightly less technical, albeit still important component of cloud computing: managing your costs to ensure that a misconfiguration in your architecture does not inadvertently cause out-of-control billing.For this discussion, I want you think in a similar, but different, area: Aside from billing considerations, what is another non-technical consideration that you want to factor in when designing a cloud system? If you are consulting an organization that is migrating to the cloud, how do you pitch this concern to them in a way that actually makes them think about it in a non-technical context?
CSI 2102 GMU Transitioning to the Future of Security Essay
I have attached the requirements document along with 3 other files(an example of how should the project be done which incl ...
CSI 2102 GMU Transitioning to the Future of Security Essay
I have attached the requirements document along with 3 other files(an example of how should the project be done which includes executive summary doc, final essay doc and ppt).Everything is clearly explained in the requirements doc.Example topics are listed in the requirement documents.
KfUPM DevSecOps Maturity Models Discussion
During this module, you explored DevOps and DevSecOps.Discuss the DevSecOps Maturity Models and their impact on an organiz ...
KfUPM DevSecOps Maturity Models Discussion
During this module, you explored DevOps and DevSecOps.Discuss the DevSecOps Maturity Models and their impact on an organization’s security posture. Then select an organization that you are familiar with and discuss how the DevSecOps Maturity models could be implemented.
George Mason Mod 7 The Need for Organizational Change Case Study Question
Note: Discussion questions and Paper are independent tasks. Please provide them in separate documents.1. Discussion Questi ...
George Mason Mod 7 The Need for Organizational Change Case Study Question
Note: Discussion questions and Paper are independent tasks. Please provide them in separate documents.1. Discussion Questions:Answer the below discussion questions each in 1 full page and list out references.a. Comment on the statement: "Google is so successful it does not need to change anything in its strategic framework?"b. What message does it send when the organizational culture encourages employees to view mistakes/problems as opportunities for improvement rather than reason to blame or punish those involved?2. Case Study in full APA format:Explain the case study and address the six questions associated with the chapter 11 Opening Case Application (Nike/CEO Mark Parker) on page 420-421 in a four to five page paper (excluding title, abstract, and reference pages). Completely review the company website noted in the case. Assignment should be APA compliance. (File Attached)Please use this strategy when you analyze a case:Identify and write the main issues found discussed in the case (who, what, how, where and when (the critical facts in a case).List all indicators (including stated "problems") that something is not as expected or as desired.Briefly analyze the issue with theories found in your textbook or other academic materials. Decide which ideas, models, and theories seem useful. Apply these conceptual tools to the situation. As new information is revealed, cycle back to sub steps a and b.Identify the areas that need improvement (use theories from your textbook)Specify and prioritize the criteria used to choose action alternatives.Discover or invent feasible action alternatives.Examine the probable consequences of action alternatives.Select a course of action.Design and implementation plan/schedule.Create a plan for assessing the action to be implemented.Conclusion (every paper should end with a strong conclusion or summary)Paper Writing Requirements:4–5 pages in length (excluding cover page, abstract, and reference list)Use APA format to complete the paper.Include proper citations and references in the paperUse the page break featureNo Plagiarism
Similar Content
IT410 Database Mnagement
You are employed as a database administrator by a start-up company in Menlo Park, California. The company is developing a ...
NEC Access Points in Network Security Discussion
Discuss about Access points in Network security.
...
Network security fundamentals
Please read carefully the description before submit. What is a specific example of Social Engineering that you have eith...
IT 549 Southern New Hampshire Developing an Incident Response Protocol HW
complete the the attached paper about Sony on this subject: information assurance. This is not a business/leadership writi...
cloud computing 2
Discuss the implementation of Specialized Cloud Mechanisms in chapter 8? Write at least two paragraphs discussing two indu...
Computer Science Discussion
Select from the following list four topics and discuss. Use only 100-words max per topic to discuss and present your answe...
Designing A Namingcomp
A good naming plan for servers, workstations, printers, laptops and any other network asset will most most likely need one...
Computer Forensics
The case presented is a perfect example of cyber crime. According to Furnell and Dowling (2019), any criminal conduct invo...
Organizational Chart
1. What are some activities an architect must execute. Provide examples? An architect is responsible for creating the desi...
Related Tags
Book Guides
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
University of Potomac System Analysis and Design Essay
Prepare a 1 or 2 page report explaining Web 2.0 and cloud computing. Using the text and your own Internet research, briefl ...
University of Potomac System Analysis and Design Essay
Prepare a 1 or 2 page report explaining Web 2.0 and cloud computing. Using the text and your own Internet research, briefly describe the five most important points in your report. Perform research on the Internet to learn about emerging trends in wireless networking, and typical costs involved in the installation of a wireless LAN. Prepare a 1 or 2 page report on your findings. Using the material in the text and your own Internet research, prepare a 1 or 2 page report on the pros and cons of agile development methods.Writing Requirements3–4 pages in length (excluding cover page, abstract, and reference list)Include at least three peer reviewed sourcesUse APA Style for in-text citations, and referencesTextbook: Tilley, S. and Rosenblatt, H. (2019) Systems Analysis and Design (Shelly Cashman Series), 12th Edition. Independence, KY: Cengage Learning. ISBN:9780357117897 Please use more than two references. You can use one from textbook mentioned above.
CPT 307 Ashford University CH1 Data Structures and Algorithms Home Project
Calculate Pay Program
Prior to beginning work on this assignment, review Chapter 1 in Data Structures Essentials and the 4 ...
CPT 307 Ashford University CH1 Data Structures and Algorithms Home Project
Calculate Pay Program
Prior to beginning work on this assignment, review Chapter 1 in Data Structures Essentials and the 4 Major Principles of Object-Oriented Programming (Links to an external site.) article. Then access the required websites for Java syntax, the Lesson: Object-Oriented Programming Concepts (Links to an external site.) tutorial, and Java OOPs Concepts (Links to an external site.) from the JavaTpoint website.
Students: Be sure to download and save a PDF version of your textbook for future reference. It will be used in later courses within your program, including the final, capstone course. Zybooks limits online access to your course textbooks to a 12-month period. (Zybook Download Instructions download)
For this assignment, you will take on the role of software developer as part of a team of developers for a retail company. The payroll manager of the company has tasked you with developing a Java program to quickly calculate an employee’s weekly gross and net pay. The program must prompt the user to enter the employee’s name, rate of pay, and hours worked. The output will display the information entered into the program along with the calculations for gross pay, total amount of deductions, and net pay.
In this coding assignment, you will utilize the Java syntax and techniques you learned while reviewing the required resources for Week 1. You may select appropriate variable names as long as proper Java syntax is used. You will also submit your source code.
Input:
In the input section, utilize Java syntax and techniques to input the employee’s name, rate of pay, and hours worked. The input should be completed either via keyboard or via file. As a last resort, the data can be hard-coded into the program.
The input for this calculation is in the Pay Calculation downloadtable.
Processing:
In the processing section, the following calculations will need to be performed in the processing section:
Gross Pay:
Gross pay if hours worked are 40 hours or less = hours worked * rate of pay
Gross pay if hours worked are greater than 40 hours = ((hours worked – 40) * (rate of pay * 1.5)) + (40 * rate of pay)
Example – Employee worked 55 hours. The employee’s rate of pay is $10.00.
((55 – 40) * (10 * 1.5)) + (40 * 10) = 625
The gross pay is $625.
Deductions:
Deductions are calculated based upon the following rates:
Federal Tax = 15%
State Tax = 3.07%
Medicare = 1.45%
Social Security = 6.2%
Unemployment Insurance = .07%
The following calculations are used to calculate each deduction:
Federal tax amount = federal tax rate* gross pay
State Tax amount = state tax rate * gross pay
Medicare amount = Medicare rate * gross pay
Social Security amount = social security rate * gross pay
Unemployment Insurance amount = unemployment insurance amount * gross pay
Total deductions = Federal Tax amount + State Tax amount + Medicare amount + Social Security amount + Unemployment Insurance amount
Net Pay:
The net pay amount is calculated as follows:
Net pay = gross pay amount – total deductions
Output:
The Java program should display the following information:
Employee Name
Rate of Pay
Hours Worked
Overtime Worked
Gross Pay
Total amount of deductions
Net Pay
Your code must include the following as comments:
Name of program
Author/student’s name
Course name and number
Instructor’s name
Date submitted
MU Designing a Cloud System Billing & Non Technical Considerations Discussion
WRITE IN YOUR OWN WORDS! This week, you will learn about a slightly less technical, albeit still important component of cl ...
MU Designing a Cloud System Billing & Non Technical Considerations Discussion
WRITE IN YOUR OWN WORDS! This week, you will learn about a slightly less technical, albeit still important component of cloud computing: managing your costs to ensure that a misconfiguration in your architecture does not inadvertently cause out-of-control billing.For this discussion, I want you think in a similar, but different, area: Aside from billing considerations, what is another non-technical consideration that you want to factor in when designing a cloud system? If you are consulting an organization that is migrating to the cloud, how do you pitch this concern to them in a way that actually makes them think about it in a non-technical context?
CSI 2102 GMU Transitioning to the Future of Security Essay
I have attached the requirements document along with 3 other files(an example of how should the project be done which incl ...
CSI 2102 GMU Transitioning to the Future of Security Essay
I have attached the requirements document along with 3 other files(an example of how should the project be done which includes executive summary doc, final essay doc and ppt).Everything is clearly explained in the requirements doc.Example topics are listed in the requirement documents.
KfUPM DevSecOps Maturity Models Discussion
During this module, you explored DevOps and DevSecOps.Discuss the DevSecOps Maturity Models and their impact on an organiz ...
KfUPM DevSecOps Maturity Models Discussion
During this module, you explored DevOps and DevSecOps.Discuss the DevSecOps Maturity Models and their impact on an organization’s security posture. Then select an organization that you are familiar with and discuss how the DevSecOps Maturity models could be implemented.
George Mason Mod 7 The Need for Organizational Change Case Study Question
Note: Discussion questions and Paper are independent tasks. Please provide them in separate documents.1. Discussion Questi ...
George Mason Mod 7 The Need for Organizational Change Case Study Question
Note: Discussion questions and Paper are independent tasks. Please provide them in separate documents.1. Discussion Questions:Answer the below discussion questions each in 1 full page and list out references.a. Comment on the statement: "Google is so successful it does not need to change anything in its strategic framework?"b. What message does it send when the organizational culture encourages employees to view mistakes/problems as opportunities for improvement rather than reason to blame or punish those involved?2. Case Study in full APA format:Explain the case study and address the six questions associated with the chapter 11 Opening Case Application (Nike/CEO Mark Parker) on page 420-421 in a four to five page paper (excluding title, abstract, and reference pages). Completely review the company website noted in the case. Assignment should be APA compliance. (File Attached)Please use this strategy when you analyze a case:Identify and write the main issues found discussed in the case (who, what, how, where and when (the critical facts in a case).List all indicators (including stated "problems") that something is not as expected or as desired.Briefly analyze the issue with theories found in your textbook or other academic materials. Decide which ideas, models, and theories seem useful. Apply these conceptual tools to the situation. As new information is revealed, cycle back to sub steps a and b.Identify the areas that need improvement (use theories from your textbook)Specify and prioritize the criteria used to choose action alternatives.Discover or invent feasible action alternatives.Examine the probable consequences of action alternatives.Select a course of action.Design and implementation plan/schedule.Create a plan for assessing the action to be implemented.Conclusion (every paper should end with a strong conclusion or summary)Paper Writing Requirements:4–5 pages in length (excluding cover page, abstract, and reference list)Use APA format to complete the paper.Include proper citations and references in the paperUse the page break featureNo Plagiarism
Earn money selling
your Study Documents