MIS582 Week 7 iLab: Database Construction Using MySQL and PHP

MIS582 Week 7 iLab: Database Construction Using MySQL and PHP in $35 OnlyMIS582 Week 7 iLab

Lab 4 of 4: Database Construction Using MySQL and PHP (50 points)

Note!
Submit your assignment to the Dropbox, located at the top of this page.
(See the Syllabus section “Due Dates for Assignments & Exams” for due dates.)

iLAB OVERVIEW
Scenario/Summary
In this assignment, you will learn to create and manipulate a MySQL database using the PHP. To complete this assignment, you will need to be able to run MySQL via Omnymbus. You should review Chapter 11’s coverage on PHP, the tutorial titled “PHP and MySQL” listed in the Webliography and MySQL’s own dialect of the SQL language via the file M10C_KROE8352_13_SE_WC10C.pdf in the Doc-Sharing folder titled My SQL Documents.
Please ensure that you can connect to MySQL/Omnymbus via the account your Professor has emailed to you. Please consult with the document titled MySQLOmnymbusSupport.docx located in the Doc-Sharing folder titled Omnymbus Tutorial Files for instructions on how to get help for any issues that you are having with the MySQL/Omnymbus Environment.

Deliverables
Name your MySQL database Lab4_xxxx where xxxx is your userid. Create and save your MySQL database file. You will be required to submit a web-link to your index.php file, along with 6 php script files and a sql file that will be executed from the Omnymbus public Web page from your Omnymbus account. Please note that your php and sql files will be based upon the templates provided the zip file titled MIS582_Wk7_templates.zip located in the folder titled iLab Documents in Doc Sharing.

You will need to modify the following php scripts and sql file from the MIS582_Wk7_templates.zip file.
• index.php
• insert.php
• insert_data.php
• update.php
• update_data.php
• delete.php
• MyAddressBook_CreateTable.sql

When you are done, submit your index.php link and zip file to the Week 7 Course Dropbox.
Required Software
Omnymbus – MySQL
Access the software at https://devry.edupe.net:8300.

Steps 1-7
iLAB STEPS
STEP 1: Review the Data Dictionary
Review the provided data dictionary below to understand the entity, attributes, and primary key that you will create in your MySQL database.
Table Name ATTRIBUTE NAME CONTENTS TYPE FORMAT RANGE REQUIRED PK or FK
MyAddressbook Id Contact ID Number Auto-Increment
Int(3) 999 000-999 Y PK
f_name Contact First Name VCHAR(25) Xxxxxx Y
L_name Contact Last Name VCHAR(25) Xxxxxx Y
ADDRESS Contact Address VCHAR(25) Xxxxxx Y
City Contact City VCHAR(25) Xxxxxx 0-9 Y
State Contact State CHAR(2) Xxxxxx Y
Zip Contact Zip Code NUMBER(5) 99999 Y

Phone Contact Phone NUMBER(10) 9999999999 Y

STEP 2: Create Table, Insert Statement

• Run MySQL via Omnymbus.
• Modify the table creation script that will be used to create the database with the outlined attributes from the Data Dictionary.
• Provide one Insert Statement that will add your contact information to the newly created table.
• Save the file with a name containing Lab7_, your first initial, and your last name (e.g., Lab7_JSmith.sql).
• Execute your script and ensure that the database is created.

STEP 3: Build Index PHP Page

Building Your index.php Web Page
In this step, you will complete your php script page to connect to the Lab7 database and display the MyAddressbook table on the Web page.
• Complete the MySQL connection for the index.php page. Be sure to fill in appropriate host (127.0.0.1), username, password, and database information in the mysqli field.
• Modify the provided php code to display each attribute of your MyAddressbook table. Note that initially, only 1 entry should be present in your table.
• Save your index.php file in your public_html folder in Omnymbus file manager.
• Please note that you will find your public_html folder down the path zdisk/USERID/public html
• Direct your Web browser to your site url (ex.http://devry.edupe.net/~XXXX/index.php).
• Note that you’ll replace XXXX with your Omnymbus login ID.
• Ensure that your file executes and the database table displays on the screen.
• If you have a correct connect command but you get the error message “MySQL ERROR 1045 (28000): Access denied for user” you will have to create a new password with the box “Change password in other modules?” checked.
• The following image provides an example of how your index.php page should look with no entries provided in the database. Note: Feel free to add any additional formatting or images to your index.php page.
STEP 5: Build Update PHP Pages

Building Your update.php and update_data.php Pages
In this step, you will complete two php HTML pages. Your update.php page will provide a form for users to submit data to the database that will be updated. The update_data.php page will provide the actual queries in php to update the data in your database. When this process is complete, your page will redirect the user back to the index.php page.
• Review the update_data.php page template.
• You will need to modify the php code to add additional input forms for the user to enter all appropriate attributes that will need to be updated.
• In the update_data.php file, ensure that your
tag is set equal to update.php
• Character data should have a character data type.
• When the action is complete, your page should redirect back to index.php.

STEP 6: Build Delete PHP Page

Building Your delete.php Page
In this step, you will complete the delete.php page. Your delete.php page will process the query that will remove the necessary data for the database. When this process is complete, your page will redirect the user back to the index.php page.
• Review the delete.php page template.
• You will need to modify the php code to delete the provided entry based on the address id.
• When the action is complete, your page should redirect back to index.php.

STEP 7: Test Links to Update, Delete, and Insert Pages. Submit Deliverables.

Finishing Your Web-Enabled Database
Before submitting, ensure that you have added at least 5 entries to your Addressbook database.
Ensure that all links for update, delete, and insert work properly.
When you are done, submit your web-link to your index.php (e.g. http://devry.edupe.net/~####/index.php), along with the zip file titled Lab4_FirstInitialLastName.zip which should contain your six php code pages and your database script.

Rubric

Points will be awarded according to the following rubrics.
• 10 points: Script and Table created for the MyAddressbook entity as described in the Data Dictionary.
• 10 points: index.php created that correctly displays the contents of the database.
• 10 points: insert.php and insert_data.php pages created that correctly add data to the database.
• 10 points: update.php and update_data.php pages created that correctly update the data in the database.
• 10 Points: delete.php page created that correctly removes an entry from the database.
For a more advanced optional lab experience you can add error checking and comments and better appearance to the code. Use Chapter 11 as a guide.

Price of Answer: Just US$35 only

Buy Now

Need Assistance…??  email us at care@solvemyquestion.com.

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at question@solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

 

Week 7 Assignment: Analyze Samples, Power Analysis, and Design Sensitivity

Week 7 Assignment: Analyze Samples, Power Analysis, and Design Sensitivity in $25 OnlyWeek 7 Assignment: Analyze Samples, Power Analysis, and Design Sensitivity

Activity Description
Submit the Following
1. Calculate the sample size needed given these factors:
one-tailed t-test with two independent groups of equal size small effect size (see Piasta, S.B., & Justice, L.M., 2010)
alpha =.05
beta = .2
Assume that the result is a sample size beyond what you can obtain. Use the compromise function to compute alpha and beta for a sample half the size. Indicate the resulting alpha and beta. Present an argument that your study is worth doing with the smaller sample.

EDU 695 Week 2 DQ 1 What is Action Research

EDU 695 Week 2 DQ 1 What is Action Research in $7 OnlyEDU 695 Week 2 DQ 1 What is Action Research

Read the following articles about action research:
“Action Research Fosters Empowerment and Learning Committees”
Themes in education: Action research.
“Supporting Technology Integration Through Action Research”
“Practical Strategies for Facilitating Classroom Teachers’ Involvement in Action Research”
In this discussion forum, answer the following questions:

  • What is your definition and/or understanding of action research?
  • What are the benefits of and barriers to action research?
  • Do you see the value of conducting classroom-based inquiries?
  • What are three questions you have about action research?

Price of Answer: Just US$7 only

Buy Now

Need Assistance…??  email us at care@solvemyquestion.com.

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at question@solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

ACC 290 Week 2 Learning Team Reflection

ACC 290 Week 2 Learning Team Reflection in $15 OnlyACC 290 Week 2 Learning Team Reflection

Discuss the objectives for Week One. How do they relate to the practice of accounting and its uses in business?

Identify the four basic financial statements.

Classify transactions using the rules of debit and credit.

Journalize basic transactions.

Discuss how financial statements would be useful to external users such as investors and creditors.

Write a 350- to 500-word summary of your Learning Team’s discussion.

Price of Answer: Just US$25 only

Buy Now

Need Assistance…??  email us at care@solvemyquestion.com.

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at question@solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

ACC 290 Week 5 WileyPLUS Assignment Week Five

ACC 290 Week 5 WileyPLUS Assignment Week Five in $25 OnlyACC 290 Week 5 WileyPLUS Assignment Week Five

Resources: WileyPLUS and Financial Accounting

Access WileyPLUS using the link on the student website.

Complete the following in WileyPLUS:

Brief Exercise BE5–1

Brief Exercise BE5–2

Brief Exercise BE6-5

Brief Exercise BE6-7

Brief Exercise BE7-4

Brief Exercise BE7-6

Price of Answer: Just US$25 only

Buy Now

Need Assistance…??  email us at care@solvemyquestion.com.

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at question@solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

ACC 205 Week Four Assignment

ACC 205 Week Four Assignment in $25 OnlyACC 205 Week Four Assignment

ACC 205 Week Four Assignment (NEW 2016)

Complete the assignment using the guidance report and changed numbers, available in your online classroom.

  • Chapter Seven, Exercises 2 and 4
  • Chapter Seven, Problem 2
  • Chapter Eight, Problem 1

Price of Answer: Just US$25 only

Buy Now

Need Assistance…??  email us at care@solvemyquestion.com.

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at question@solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

ACC 205 Week Five Assignment

ACC 205 Week Five Assignment in $26 OnlyACC 205 Week Five Assignment

ACC 205 Week Five Assignment (New 2016)

  1. Week Five Assignment [CLOs: 1, 2]. Due by Day 7. Complete the assignment using the guidance report and changed numbers, available in your online classroom.
    • Chapter Nine, Exercises 3 and 4
    • Chapter Nine, Problems 1, 2 and 3

Price of Answer: Just US$25 only

Buy Now

Need Assistance…??  email us at care@solvemyquestion.com.

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at question@solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

BUS 520 Week 9 Assignment 4

BUS 520 Week 9 Assignment 4 in $29 Only

BUS 520 Week 9 Assignment 4 – Leadership Style What Do People Do When They Are Leading

Choose one (1) of the following CEOs for this assignment: Larry Page (Google), Tony Hsieh (Zappos), Gary Kelly (Southwest Airlines), Meg Whitman (Hewlett Packard), Ursula Burns (Xerox), Terri Kelly (W.L. Gore), Ellen Kullman (DuPont), or Bob McDonald (Procter & Gamble). Use the Internet to investigate the leadership style and effectiveness of the selected CEO.
Write a five to six (5-6) page paper in which you:
1. Provide a brief (one [1] paragraph) background of the CEO.
2. Analyze the CEO’s leadership style and philosophy, and how the CEO’s leadership style aligns with the culture.
3. Examine the CEO’s personal and organizational values.
4. Evaluate how the values of the CEO are likely to influence ethical behavior within the organization.
5. Determine the CEO’s three (3) greatest strengths and three (3) greatest weaknesses.
6. Select the quality that you believe contributes most to this leader’s success. Support your reasoning.
7. Assess how communication and collaboration, and power and politics influence group (i.e., the organization’s) dynamics.
8. Use at least five (5) quality academic resources in this assignment. Note: Wikipedia and other Websites do not qualify as academic 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.

Price of Answer: Just US$29 onlyBuy Now

Need Assistance…??  email us at care@solvemyquestion.com.

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at question@solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

BUS 520 Week 7 Assignment 3

BUS 520 Week 7 Assignment 3 – Teamwork and Motivation in $35 Only

Imagine that you are the owner of a small manufacturing company. Your company manufactures a commodity, widgets. Your widget is a clone of a nationally known widget. Your company’s widget, WooWoo, is less expensive and more readily available than the nationally known brand. Presently, the sales are high; however, there are many defects, which increase your costs and delays delivery. Your company has fifty (50) employees in the following departments: sales, assembly, technology, and administration.
Write a five to six (5-6) page paper in which you:

BUS 520 Week 3 Assignment 1

BUS 520 Week 3 Assignment 1 in $16 Only

BUS 520 Week 3 Assignment 1 – Finding the Leader in You Self Assessment Johari Window

This archive of BUS 520 Week 3 Assignment 1 – Finding the Leader in You Self Assessment Johari Window comprehends:

The Johari Window emphasizes that we may not be aware of everything that there is to know about ourselves. Others may know things about us that we just cannot see or are unwilling to admit. One way to improve our personal relationships is to increase what we know about ourselves and what others know about us. The following two (2) behaviors are key to improving personal and professional relationships:

BUS 520 Week 4 Assignment 2

BUS 520 Week 4 Assignment 2 in $25 Only

BUS 520 Week 4 Assignment 2 – Integrating Culture and Diversity in Decision Making The CEO and Organizational

This paper of BUS 520 Week 4 Assignment 2 – Integrating Culture and Diversity in Decision Making The CEO and Organizational covers:

Choose one (1) of the following organizations to research: Google, Zappos, Southwest, Hewlett Packard, Xerox, W.L. Gore, DuPont, or Procter & Gamble. Use a variety of resources (company Website, newspaper, company blogs, etc.) to research the culture of the selected organization. Note: Use
Question 6 as your conclusion. An abstract is not necessary for this assignment.

ACCT 505 Week 3 Case Study II

ACCT 505 Week 3 Case Study II in $9 Only

Springfield Express is a luxury passenger carrier in Texas. All seats are first class, and the following data are available:

Number of seats per passenger train car 90

Average load factor (percentage of seats filled) 70%

Average full passenger fare $160

Average variable cost per passenger $70

Fixed operating cost per month $3,150,000

BUS 330 Week 2 DQ 1 Product Life Cycle

BUS 330 Week 2 DQ 1 Product Life Cycle in $2 Only (Instant Download)BUS 330 Week 2 DQ 1 Product Life Cycle

By having an understanding of the product life cycle, businesspeople can make savvy marketing choices. What is a popular item today that you’ve seen go through the product life cycle? Explain the characteristics for each phase of the product’s life cycle. How can each phase of the life cycle impact the product’s brand? You must use the text and at least one additional scholarly source.

Guided Response:

Review several of your peers’ posts. Respond to at least two of your peers to provide recommendations to extend their thinking. Challenge your peers by asking a question that may cause them to rethink the product life cycle.

Price of Answer: Just US$2 only (Instant Download)

Buy Now

Need Assistance…??  email us at care@solvemyquestion.com.

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at question@solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

ACCT 504 Week 6 Case Study 3 Cash Budgeting LBJ Company

ACCT 504 Week 6 Case Study 3 Cash Budgeting LBJ Company in $10 Only

ACCT 504 Case Study 3 on Cash Budgeting
The cash budget was covered during Week 4 when we covered TCO D and you read Chapter 7. There is also a practice case study to work on. Your Professor will provide the solution to the practice case study at the end of Week 5. This case study should be uploaded by 11:59PM Mountain time of the Sunday ending Week 6 to the Week 6 Assignment Dropbox. You are encouraged to use the Excel template file provided in Doc Sharing.

The LBJ Company has budgeted sales revenues as follows:

PROJ587 Week 5 Case Study

PROJ587 Week 5 Case Study in $10 Only

The purpose of this case study is to get you used to incorporating Microsoft Project charts and reports directly into your project’s progress reports. By now you should be able to work through the mechanics of loading tasks, predecessors, resources, and costs into MS Project. But the real challenge facing project managers is how to interpret the data in MS Project and how to make it “useful” for you and your stakeholders.

In this case study you will be given a scenario and asked to load the project information into Microsoft Project. However, the purpose of this case study is bigger than just properly loading the Microsoft Project file. This case study requires you to interpret the MS Project results and incorporate the issues and results in your communication with key stakeholders. Your output of this case study explores the “softer” side of project management, including how to communicate your results to your key stakeholders in a clear and concise manner and to include MS Project views directly in the document to illustrate your points for your reader.

DeVry HSM544 Week 5 Case Study Latest Guide

DeVry HSM544 Week 5 Case Study Latest Guide in $19 Only
DeVry HSM544 Week 5 Case Study
Introduction
Your brother-in-law, Representative Howard Hughes, lost his bid for reelection. However, thanks to your efforts, he established himself while in Congress as an astute analyst of the health field and as a consequence, has taken a position as partner at the prestigious Atlanta investment firm of Keller, Keller, Keller, Keller, and Disher. You have decided to take him up on his offer to join him as a manager in the healthcare division.
The other partners have little insight into healthcare other than receiving care. Your brother-in-law has been asked to give a presentation on the current status of the health sector and opportunities for investment.
Your job is to provide him with infomation on the healthcare industry. Key interest items are in the below questions. To be effective, detail needs to be spectific, complete with sufficient depth and detail.
The paper must answer the following questions:

PSC450 Week 8 Training PowerPoint Presentation Assignment

PSC450 Week 8 Training PowerPoint Presentation Assignment in $19 Only

You have been asked by your supervisor to develop a PowerPoint presentation for an upcoming training on the following topics: ethics, international factors, and cross-cultural considerations in project management.
Using 15-20 slides, create a PowerPoint presentation in which you discuss the following as it relates to successful project management:
1. A summary of each topic as it relates to project management
2. Challenges (common pitfalls) and opportunities for growth and/or improvement
3. Solutions for dealing with challenges common in project management
4. Include one scenario applicable to each concept in which your coworkers will have to determine an appropriate response to handling the issue presented in the scenario and faced by a project management team

PSC 450 All Weeks Discussions Questions Latest

PSC 450 All Weeks Discussions Questions Latest in $42 OnlyPSC 450 All Weeks Discussions Questions

PSC450 Week 1 Discussions

DQ 1

In your own words, define organizational strategy. Explain the relationship between a business’s organizational strategy and its projects. Based on your budding understanding of project management, predict which elements of project management are most influenced by the business’s organizational strategy? Provide specific examples.

dq 2

Review two of the project management software tools available via links in the course syllabus. Provide an overview of each software and decide if you will use either of the software for projects throughout the course and why. If you decide to use the software, what challenges, if any, do you foresee with using it? If you have used any of the software before, please share your experience and any tips you may have.

PSC450 Week 2 Discussions

Loading...