Question: Write an ALTER TABLE statement that adds two new columns to the SOFTWARE table created in step 1 . Add a column named LIST _

Write an ALTER TABLE statement that adds two new columns to the SOFTWARE table created in step 1.
Add a column named LIST_PIICE for product price that allows for three digits to the left of the decimal point and two to the right (max value of 999.99). This column should have a default value of 9.99
Add a column named DATE_ADDED for the DATE that the software was added to the database.
Write an ALTER TABLE statement that adds two new columns to

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 Databases Questions!

Q:

Write an ALTER TABLE statement that adds two new columns to the Products table created above. Add one column for product price that provides for three digits to the left of the decimal point and two...

Q:

HW6 Covers Chapters 9 &10 Chapter 9: How to design a database Exercises 1. Draw a database diagram for the script file named create_mgs_tables.sql thats in the mgs_ex_starts folder. 2. Draw a...

Q:

HELP Need Assitance: 1. Write a script that adds an index to the MyGuitarShop database for the zip code field in the Addresses table. 2. Write a script that implements the following design in a...

Q:

In these activities, youll use SQL Server Management Studio to enter SQL statements and run them against the MyGuitarShop database. 1.Write a script that adds an index to the MyGuitarShop database...

Q:

The scenario is that you are working for a company and they are creating a website that allows users to download manuals and software updates for products they have purchased. They want to track all...

Q:

2. Write a script that implements the following design: In the Downloads table, the user_id and product_id columns are the foreign keys. Create these tables in the ex schema. Create the sequences for...

Q:

I'm having some trouble please help: 2. Write a script that adds an index to the MyGuitarShop database for the zip code field in the Addresses table. In the Downloads table, the UserID and ProductID...

Q:

SQL Homework: exercise 2: CREATE TABLE users ( user_id int Primary key NOT NULL, email_address VARCHAR(20), first_name VARCHAR(20), last_name VARCHAR(20) ); CREATE TABLE downloads ( download_id int...

Q:

SQL Homework exercises: exercise 2: CREATE TABLE users ( user_id int Primary key NOT NULL, email_address VARCHAR(20), first_name VARCHAR(20), last_name VARCHAR(20) ); CREATE TABLE downloads (...

Q:

3. Write a script that adds rows to the database that you created in exercise 2. Add two rows to the Users and Products tables. Add three rows to the Downloads table: one row for user 1 and product...

Q:

A manufacturing company has identified several costs. Indicate whether each of the following costs is an Inventoriable cost(1) or a Period cost(P): 1. Rent Expense on factory equipment Choose. 2....

Q:

Coyote company produces a single product with the following information about the 3 years from 2018 to 2020: (similar to Problem 7-18) Variable costs per unit: Direct materials $4 Direct labor $6...

Q:

EXERCISE 11-1. Group Assignment 1 Five Star Tools is a small family-owned firm that manufactures diamond-coated cutting tools (chisels and saws) used by jewelers. Production involves three major...

Q:

Suppose you continued Activity 1 using a third plastic cup of the same type. Would you expect the average deviation from the average mass to be the same or different? Explain your answer. In Activity...

Q:

What combination of Key Fields in a Salary Structure Table allows for storage of historical Pay Grade Data for multiple Occupation Group Pay Grade Structures?

Q:

Explain the function and purpose of the Job Level Table.

Q:

What are Compa-Ratios? Explain the difference between Internal and External (Market Based) Compa-Ratios.