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.

 

Explain Image Accessed Name and Array Number

Explain Image Accessed Name and Array Number in $11 Only

Explain how an image could be accessed by name and by array number 

Please complete the following short answer questions with code snippets as well as paragraphical responses. This assignment should not be an exercise in copy and paste, but an assessment of your comprehension and evaluation of the course materials.
(Note: Please replace the less than/greater than signs in your code with double braces {{ }}, as the less than greater than signs will NOT render in your response. If you are using Microsoft Word to submit your answers, all first letters of your code line MAY be auto-capitalized. This is not proper coding for JavaScript. Please keep in mind, for example, Do is not the same as do, For is not for, Alert it not alert and Var is not var. Points WILL be deducted for incorrect capitalization of code.)

1. Question Short Answer/Essay – 10 points
Give the syntax of do..while statement.

CIS209 Project Task Banking Program

CIS209 Project Task Banking Program in $27 Only

To be done individually or in groups of two.
Due: Tuesday, January 08, 2012. Hardcopy of work needs to be handed it (SQL statements with report). Running of program to be checked in class. 5% off for each additional day handed in late.
Grade: The project is worth 15% of your total grade.
The Goal: Get experience in programming using databases.
What you need to know for this project: Designing relational databases, SQL, stored procedures. The project is based on the material of Class/Labs.

The Task: Implement a Banking Program of a bank providing account/loan services to customers by several branches. Here is the minimum functionality of the application:

CIS 500 Case Study 2 Cloud Computing

CIS 500 Case Study 2 Cloud Computing in $9 Only

Cloud computing is defined by Cearly and Phifer in their case study titled “Case Studies in Cloud Computing” as “a style of computing in which scalable and elastic ITrelated capabilities are provided ‘as a service’ to customers using Internet technologies”. Cloud computing services had been provided by major vendors such as Google, Amazon, Microsoft, IBM, HewlettPackard, and others for business computing until recently when Apple Corporation announced iCloud for consumers. Therefore, cloud computing is now available for businesses as well as consumers.

Read the case study titled, “Ericsson”, located athttp//aws.amazon.com/solutions/casestudies/ericsson/, about Ericsson cloud computing.

Computer Science Question HTML Website Development

Computer Science Question HTML Website Development in $12

Question

A. Design a preliminary homepage called “cssprelimI.htm”. It should be similar in layout to the example below, but you may use your own content.

1) Have a banner across the top using header tags that give the title of your web site.
2) Use an unordered list of links that connect to some practice sub pages. You will use float to position the list on the left.  Create an empty page to test the links.
3) Next to the menu you should have a number of  paragraphs about your web site. It should be long enough to flow completely around the graphic.  The text should be placed below the menu list in your file, so that it will appear along side in the output.
4) On the right side of the page you should have a  picture that has something to do with your topic. Use float to keep the picture on the right. The img tag for the picture should be placed after the first paragraph of the text so that the text will flow around it. You may have to move the location of the img tag up or down, depending on the size of your graphic.
Use the following parameters in your img tag: style= “float:right; margin-left: 10px;”
A copy of the whirlpoolgalaxy.jpg  graphic is located in the downloads section if you wish to use it.
5) Use the following styles section in your file:

Assignment: Implementation Plan

 Assignment: Implementation Plan in $18 only (Instant Download)

Instructions

Using the recommendation memo and network diagram, develop a high-level plan for implementing the changes and mitigating vulnerabilities and convergence issues.

The plan should include all the System Development Life Cycle gates/decision points and all relevant tasks.

The plan must also describe and relate the implementation solution to Confidentiality, Integrity and Availability while incorporating people, processes and technology. Think about all of the actions, resources, and tasks that you would need in order to effect a successful implementation.

Technology = Cloud Computing / Backup & Recovery Technology / Digital Forensic Tools

  • Plan must be a minimum of 5 pages long (max of 8 pages), double-spaced and must be written in APA format with a title/cover page. Any illustrations (tables/charts/graphs) will not be included in the page count.
  • This assignment must include a resources page with at least 5 authoritative or scholarly sources, cited properly throughout the paper in APA format.
  • Be sure to expertly define goals and objectives throughout the plan, while describing the linkage and constraints associated with the solution. Major tasks should be clearly prioritized according their importance to mitigating the risks and issues found.
  • Be sure to clearly identifies and articulates the cost of the overall security solution. Also Clearly identify security solutions and assumptions that consist of people, processes and technologies related to the risks.
  • Be sure that all SDLC tasks are detailed and logically lead to the proposed solutions. Also synthesize and apply all logical SDLC processes and schedules to overall solution deployment.
  • Be sure that any accompanying illustrations are strongly linked to proposed solutions and content.
  • Be sure that each defined milestone is directly related to overall strategy/solution and clearly mitigates the risk or issue.

Computer Science Questions A+

Computer Science Questions A+

The following list contains components you would find in both a wired and a wireless network:
• Wireless router
• Computer
• Firewall
• Wireless access point
• Hub
• Modem
• Printer
• Server
• Switch
• Wireless network interface card (NIC)
• Router
• Scanner
• Multiplexer
In a 1- to 2-page paper, address the following:
• Describe the function and purpose of each component above.
• Explain how the components are related to each other. For example, does the component depend on another to operate? Is it connected to the network physically or wirelessly?
• Identify whether the component is optional or required in a wireless network. If it is an optional component, explain why it would or would not be used in a WLAN.
• Complete an Internet search for the average cost of each component and include the cost in your description. Reference the website(s) you used to locate this information.
Format your paper consistent with APA guidelines.

Price of Answer: Just US$9 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 any thing 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.

COMP 129 Final Exam 100% Correct Answers

COMP 129 Final Exam 100% Correct Answers US$21 only (Instant Download)

1. (TCO 1) The HAL and executive services are elements of the __________.
application software
shell
kernel
device drivers
2. (TCO 1) Information on installed hardware, software, system configuration, and current running programs can be accessed using ________.
command prompt (cmd.exe)
control panel
system information utility (msinfo32.exe)
Explorer
3. (TCO 2) The ____ is a measure of resistance to electricity
Ohm (Sample Answer)
amp
volt
watt
4. (TCO 2) A system might have up to ____ types of ribbon cables
two
three (Sample Answer)
four
five
5. (TCO 2) When should a soft boot be used on your computer?
Only when absolutely necessary
Never
Anytime you want
There is no such thing as a soft boot.

Disscusion Question Computer Network Security

Disscusion Question Computer Network Security in $6 only

Write up a complete tutorial, including an analogy to explain the mechanics and a graphic to support your analogy, on one of the following areas:

  1. Buffer overflows
  2. SQL injection
  3. Cross-Site scripting
  4. DoS attacks
  5. Injection attacks
  6. Poisoning attacks

Consider that your audience probably isn’t up to speed on how any of these work. In fact, you may want to test your tutorial on a ‘casual’ user (parent? teenager?) to see if they can understand what the problem is. In your responses to other students, comment on whether the tutorial fits the target audience. Is it too complicated? Too simple? Too many unexplained acronyms?

Price of Answer: Just US$6 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 any thing 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.

Network Design PaperUMUC has recently acquired a building A+

Network Design PaperUMUC has recently acquired a building A+ in $35 only

The University has recently leased a building in Adelphi, Maryland. The building will house some offices, classrooms, library, and computer labs.

Building dimensions: Length: 240 Feet, Width: 95 Feet, Height: 30 Feet

The 50-year-old two-story building has the following layout:

First floor plan

Second floor plan

There will be six computer labs that will be used for instruction. Each of these labs will have 23computers (22 student computers and 1 instructor computer). Each of these labs will also have a server in the closet located inside the lab.

In addition to the six computer labs, there will also be a Student Computer Lab that will provide computer access to students to do their homework. There will be 30 computers in this lab and a server in the closet.

The library will also have some computers to allow students access to the library resources. There will be 10 computers for student’s use in the library, and 5 computers for Library staff.

There are five lecture classrooms in the building. Each of this room will have a computer for instructor’s use.

Finally, there are various offices in the building. Each of these offices will have one computer for the staff use, with the exception of the Admission office that will have 5 computers for staff use.

WEB 434 Entire Course

WEB 434 Entire Course New updated course

WEB 434 Entire Course

WEB/434 Entire Class

WEB/434 Full Course

WEB/434 Entire Course

ANSWER AVAILABLE.

Price of Answer: Just US$ 28 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 any thing 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.

WEB 236 Week 3 Individual Assignment Website Navigation and Development Plan

WEB 236 Week 3 Individual Assignment Website Navigation and Development Plan

  1. Individual Assignment: Website Navigation and Development Plan
    Customize Keyboard dialog in OpenOffice 2.3

 Students will submit the second section of the website plan whose topics will include the following:

 Navigation: Students will research the best practices for site navigation, and locate a website that demonstrates effective site navigation. Students should include a screen shot of this example by selecting window in which the site is located, and press the keyboard shortcut. The screen shot can be pasted into Word. Students should include shape callouts or a written description to explain the effective design features of the example. Ideally, students will locate examples of how they would like their site navigation to work and function. This might require a synthesis of several examples, if necessary.

Web Development Tools: Students will list and describe any applicable Web development tools that would be necessary to develop the site.

ANSWERS AVAILABLE.

Price of Answer: Just US$ 7.00 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 any thing 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.

POS 410 Week 5 Learning Team Project

POS 410 Week 5 Learning Team ProjectPOS 410 Week 5 Learning Team Project

Begin work on Service Request SR-kf-009, “SQL Accounting Database.”

  • Develop a project plan defining all tasks and work assignments for each team member.
  • Analyze the current Chart of Accounts spreadsheet.

Submit the project plan for non-graded review by faculty.

Continue work on the Learning Team Project.

  • Define the SQL database.
  • Load the SQL database with data from the chart of accounts spreadsheet.

Prepare test data and load it into the SQL database.

Continue work on the Learning Team Project.

  • Create account number query.

Test query.

Complete work on the Learning Team Project.

  • Create SQL database Chart of Accounts report.
  • Test Chart of Accounts report.

Submit query, screen shots and Chart of Accounts report for grading.

ANSWERS AVAILABLE.

Price of Answer: Just US$ 9 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 any thing 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.

POS 410 Entire Class Assignments – Individual and Team Assignments + DQs

  • POS 410 Entire Class Assignments – Individual and Team Assignments + DQs
  • POS 410 Complete Class Assignments – Individual and Team Assignments + DQs
  • POS/410 Full Class
  • POS 410 Complete Class Week 1-5
  • POS410 Entire Class Assignments and DQs

Detailed:

POS 410 Week 2 Individual Assignment Table Queries

Create an SQL server database for the Kudler Fine Foods Virtual Organization.

Create the following tables using fields listed below.

Note. Supply SQL server data types when creating tables. In the Employee table, create an Employee ID field that generates a unique number for each employee and designate the field as the Primary Key. In the Job_Title table, use a listed field as the table’s primary key or create an additional field to use as the primary key. The primary key from the Job Title table appears as the foreign key in the Employee table.

  • Employee
  • Employee ID
  • Last name
  • First name
  • Address
  • City
  • State
  • Telephone area code
  • Telephone number
  • Employer Information Report (EEO-1) classification
  • Hire date
  • Salary
  • Gender
  • Age
  • Foreign key from Job Title table.
  • Job_Title
  • EEO-1 classification
  • Job title
  • Job description
  • Exempt/non-exempt status

Use the SQL INSERT statement to go to the human resources department in the Kudler Fine Foods Virtual Organization. Using information found in the employee files for the La Jolla and Encinitas stores, enter records into the Employee table for the following employees:

Loading...