Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Dumping data for table orders

08/10/2021 Client: muhammad11 Deadline: 2 Day

DB Report

Write the Report

Write the program that will allow you to print and/or display the data in each of the tables in your database.

DBM405A

Week 1

Order Management Database

This project is to manage customers and the orders they place online for a local company. The company’s employees are responsible to manage the order. The purpose of the project is to take orders online by the customers and maintain their information in the system. The system will also maintain the details of the current employees. Order information is maintained in the system that can be shipped to the customers. This allows the company to expand beyond just a store front and to keep a better track of customers’ information and what they order.

The system will maintain the information about the customers, orders, order details, items, and employee information. Employees will enter the information of Customers in the system or the customers themselves can do it online. The employee can then enter the information of the orders placed by these customers. The system will also keep a track of orders that are shipped and their details. The project will consist of 5 tables.

Week 2

Week 3

Week 4

See compressed file.

Week 5

For this week I had to establish a connection to the database from my programming language (HTML). For me to do so I pretty much had to start from scratch by renaming the database to login and adding an additional table call users. This table is what I use to store the data that was and will be enter by any user. I also use XAMPP, PHP with MySQL to help connect to the database as well. Below is a screenshot of the users table with a few data already stored in using the login system I created. Attach is also the HTML code to get to the login system.

Week 6

For this week I had to write programs that will allow me to add a record, change a record, and delete a record for each of the tables in my database. I did that by creating an insert, update and delete stored procedure for each of the tables in my database.

Below is a screenshot of all the procedures created with the naming convention specifying what each procedure is doing on which table.

Below I’ll post the statement for one of each type of procedures (being that it’s 15). I will only post one for insert, update and delete.

This is the INSERT SP

CREATE PROCEDURE `EmployeeSP_Insert`(IN `employee_id` INT, IN `first_name` VARCHAR(60), IN `last_name` VARCHAR(60), IN `manager_id` INT) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER INSERT into employees (employee_i,first_name, last_name,manager_id) VALUES (employee_i,first_name, last_name,manager_id);

This is the UPDATE SP

CREATE PROCEDURE `ItemsSP_Update`(INOUT `item_id` INT, INOUT `unit_price` VARCHAR(60)) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER UPDATE items SET unit_price=unit_price WHERE items.item_id=item_id;

This the DELETE SP

CREATE PROCEDURE `UsersSP_Delete`(INOUT `user_id` INT) NOT DETERMINISTIC NO SQL SQL SECURITY DEFINER DELETE from users WHERE users.user_id=user_id;

References

Generatedata.com. (2019, March). Retrieved March 24, 2019, from http://www.generatedata.com/

Mmtuts. (2017, June 20). Retrieved April 08, 2019, from https://www.youtube.com/watch?v=xb8aad4MRx8

Technology, H. C. (2017, October 07). Retrieved April 15, 2019, from https://www.youtube.com/watch?v=SPZJt3D5f4k

University, D. (2019, March). Re: Class Discussion [Web log comment]. Retrieved March, 2019.

Orders

Items

Employees

Order_details

Customers

order_id

PK

shipped_date

employee_id

FK

item_id

PK

title

attribute name

employee_id

PK

first_name

manger_id

order_id

PK

item_id

FK

order_qty

FK

customer_id

PK

customer_first_name

customer_last_name

customer_address

customer_city

customer_phone

customer_zip

customer_state

unit_price

last_name

customer_id

FK

order_date

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Ideas & Innovations
Quality Assignments
Top Academic Tutor
Assignment Guru
Solution Provider
Finance Master
Writer Writer Name Offer Chat
Ideas & Innovations

ONLINE

Ideas & Innovations

I will cover all the points which you have mentioned in your project details.

$48 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

I have read and understood all your initial requirements, and I am very professional in this task.

$31 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$42 Chat With Writer
Assignment Guru

ONLINE

Assignment Guru

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$45 Chat With Writer
Solution Provider

ONLINE

Solution Provider

Give me a chance, i will do this with my best efforts

$38 Chat With Writer
Finance Master

ONLINE

Finance Master

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$30 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Refraction of light experiment conclusion - Digital notice board using raspberry pi pdf - Vera bradley case study - Hacking into harvard case 2.1 - Chapter 9 auditing the revenue cycle solutions - Night conflict chart answers - Toyota starlet dash clock - 700 word discussion: According to Shneiderman and Bederson (2003),With this revelation in mind, identify, and discuss the benefits? - Montagu the lover a ballad - Duty to warn definition - Discussion Board Forum 3 - Gino's restaurant is a popular restaurant in boston massachusetts - An introduction to statistical learning exercise answers - December 2016 and january 2017 calendar - In 400 – 500 words, and using the Jamsa (2013) textbook as your ONLY source - Difference between bjt and jfet - Hierarchy chart in programming - Is tara bethan married - Alfred hitchcock camera angles - Stages of creativity in psychology - Ucas tv personal statement - Electrical separation shaver socket diagram - Case study - Stealing carol ann duffy - Mendelian genetics lab answer key - Cucm h 323 gateway configuration example - Disodium inosinate chemical formula - Lord of the flies chapter 4 study guide answers - Cultural criticism essay regarding “Young Goodman Brown” - 120000 aud after tax - What is the difference between hindustani and carnatic music - Walmart capstone simulation level 3 - Virtualization Response - Peter symonds college intranet - 06.04 the korean war - Little boxes on the hillside - Cornwall voluntary sector forum - Risk assessment for bbq - Mathews creed totally lost limited edition - Market competitive pay system - Your homes newcastle walker housing office - Diabetes care journal submission - Measuring sugar content of a liquid with a laser pointer - N491 Discussion Mod 6: - Hobo dyer map pros and cons - Figurative language poster project - Assess a Leader's Role in Process and How Individuals and Organizations Learn and Improve - American art before and after world war ii presentation - 12 years a slave costumes - Good samaritan law nsw - Georges manor georges hall - Entwistle integrative approaches to psychology and christianity - What is monthly duty cycle in printer - Battleship java code - Hsc in the holidays uts - 750-1000 words - Project - Where did job live in the bible - Block Chain Development final paper - Seagull sta 4.0 answers pdf - Old school publishing inc began printing - Write the number that makes each number sentence true - Earth electrode resistance test - Autologous serum eye drops expiration date - Sample soap note nurse practitioner - Compare and contrast freud and erikson theory of development - Health Care (Due 24 hours) - Project B - Healthcare plans - Ethical Standards - Critically appraise a qualitative and quantitative research design. - Nhppd - Bernard fanning net worth - League of friends john radcliffe - Disadvantages of ozone disinfection - How to find displacement from velocity time graph - Acap grad dip counselling - Genetics - Aditya kumar ips begusarai - Arizona science teachers association - 540 dis - Total language plus samples - Talking electronics pic projects - What is priority setting in nursing - How tall is a smurf - Your Own Thoughts about Reading: 75-100 words - Cases in healthcare management pdf - Which of the following best describes a metal solid - Nursing care plan for urticaria - Sherwood state school uniform - Causality and stability in laplace transform - 2x 3y 53 3x y 19 - Experiment 1 neutralization of acids and bases data tables - Hiragana flash cards game - Crystal east morong rizal pathland - Walmart recruiting store sales forecasting - Qnt 561 applied business research and statistics final exam - Finding a rental 2.6 7 a2 answers - Discussion Board Chapter 11 - C++