Question: Write an SQL script that does the following and save this script as CIS 2 7 6 DA _ FinalExercise 1 0 _ MEID.sql .

Write an SQL script that does the following and save this script asCIS276DA_FinalExercise10_MEID.sql . Save the output of this script asCIS276DA_FinalExercise10_MEID.csv
add three new columns to the Products table
Add one column for the name of the product supplierAdd one column for the product markup percentage that provides for three digits to the left of the decimal point and two to the right. This column should have a default value of 50.00Add one column for the date and time that the product was added to the database
Display the new structure of the table and save that to the csv file.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

6. Write an SQL script that does the following and save this script as CIS276DA_FinalExercise6_MEID.sql . Save the output of this script as CIS276DA_FinalExercise6_MEID.csv Your results should...

Q:

My apologies. This is Exercise 1 0 for the CIS 2 7 6 DA My SQL Database Final Project. This project uses the my _ guitar _ shop database as exercises 1 - 9 , and 1 1 - 1 2 do . I just couldn't find...

Q:

Write an SQL script that does the following and save this script as CIS 2 7 6 DA _ FinalExercise 7 _ MEID.sql . Save the output of this script as CIS 2 7 6 DA _ FinalExercise 7 _ MEID.csv Use an...

Q:

Please I need help with the Part 3 and 4 Questions of this exercise. Thank you. Exercise: Hotel Schema Overview Hotel Software Guild is a resort hotel on the West Arm of Lake Minnetonka. It is a...

Q:

* * * * Please write an sql script with the table provide * * * Objectives: Write SQL statements to define a database, to define tables, to view the table structures, to upload data into the tables...

Q:

There are three parts to this assignment, (PARTS A, B, and C). Be sure to complete all of the parts. BELOW ARE THE FILES THAT YOU WILL SUBMITFOR THISASSIGNMENT: mod2Sql.sql createTruck.sql...

Q:

Instructions: Use the link: https://bellard.org/jslinux/ to write shell scripts Take screenshots of the script and paste picture of scripts and output to word document. Save word document with your ....

Q:

Assignment Goals: To learn to use UNIX/Linux file processing utilities to process data in text files. Tasks: 1. In your home directory, make a directory called hw3 and change to the hw3 directory 2....

Q:

Part II. Table creation and data insertion 2- Write a SQL script to create a new database called "UCL". Create the tables based on your designs in Part I in this database. Save the script as...

Q:

Download and run a fresh copy of the create_CAP.sql script linked here . Write SQL queries to answer the following questions. Save as an SQL file and attach. Number your problems as a comment. 1)...

Q:

On January 1, 2009, Neeley Company completed the following transactions (use an 8 percent annual interest rate for all transactions): a. Borrowed $2,000,000 to be repaid in five years. Agreed to pay...

Q:

If A = 011011012 and B = 110000112 (a) Calculate A plus B in binary. (b) Calculate B minus A in binary. (c) Check the previous result by adding B to the two's complement of A. (d) Convert A to...

Q:

*1364. The 1.40-Mg helicopter is traveling at a constant speed of 33 m>s along the horizontal curved path having a radius of curvature of r = 300 m. Determine the force the blade exerts on the frame...

Q:

Find a Doctor is a small startup that helps people find a physician that best meets their needs (location, insurance accepted, etc). During a "slow" time for them, they have 7 staff members taking cal