Answered step by step
Verified Expert Solution
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
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 PrintStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started