Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need the code for Microsoft visual studio. I simply cannot figure what I am doing wrong while constructing the code. lSprint Wi-Fi 10:07 AM

image text in transcribed

I need the code for Microsoft visual studio.

I simply cannot figure what I am doing wrong while constructing the code.

lSprint Wi-Fi 10:07 AM 60% . Project Task 6.pdf created. If you had some issues with your tables in task 5 or could not complete the task, thern wur datahase will be populated with the correct solution so that you can move forward and work 2 of 2 MGMT 329: Database Management This task is concerned with data loading. When a database is first developed, we must have our initial data load. In SQL. Server, we have te SSIS platorm (SQL. Server Integration Services) that can be used to load data. While the SSIS is most commonly used for Data Warehousing and the ETL (Extraction, Transformation, Loading) process, it can also be used for importing data into your database. In the vLab environment, we do not have access to the SSIS platform so we must use DDL commands to insert the data. To make the task simpler, a stored procedure for cach student's database has been created to insert all the data into your tables with the exception of the shippingMethods table. Your task will be to create a second stored procedure to insert the shippingMethods data yourself. Project Task 6: Requirements All of the data for your project has been inserted with the exception of the shippingMethods table. Your task is to create a new stored procedure called Insert ShippingMethod Data and write the necessary code to insert the shipping method data into your tables. Once you create the stored procedure, you must execute the stored procedure in order to populate the shippingMethods table. The data to be inserted into your table is below. Check task 5 for the data types of each attribute to make sure you use the correct format when inserting the data. Upload a Microsoft Word document that says "Task Complete" to UNM Lcarn to show you have completed the assignment. This will trigger the grading process. Your assignment will be graded based on the results displayed in vLab. Methods shipID com 101 method Standard Ground 10 Standard Air fRate vRate baseWeight 0.5 Fedex 104 Fedex UPS Next Standard Ground Standard Air Express Air Next Standard Ground Standard Air Express Air Next Day Air 201 15 UPS UPS USPS USPS USPS USPS 0.5 0.5 0.5 0.5 0.5 0.5 204 301 302 Air 45 a Open With Print

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Spatial And Temporal Databases 11th International Symposium Sstd 2009 Aalborg Denmark July 8 10 2009 Proceedings Lncs 5644

Authors: Nikos Mamoulis ,Thomas Seidl ,Kristian Torp ,Ira Assent

2009th Edition

3642029817, 978-3642029813

More Books

Students also viewed these Databases questions

Question

What are cash-based ratios of liquidity? What do they measure?

Answered: 1 week ago