Question: Write the following SQL statements for the following: 1) Write an ALTER TABLE statement that adds two new columns to the Products table. Add one

Write the following SQL statements for the following:

Write the following SQL statements for the following: 1) Write an ALTER

1) Write an ALTER TABLE statement that adds two new columns to the Products table.

Add one column for product price 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 9.99.

Add one column for the date and time that the product was added to the database.

2) Write an ALTER TABLE statement that modifies the Users table so the FirstName column cannot store null values and can store a maximum of 20 characters.

Code an UPDATE statement that attempts to insert a null value into this column. It should fail due to the not null constraint.

Code another UPDATE statement that attempts to insert a first name thats longer than 20 characters. It should fail due to the length of the column.

Users Downloads UserlD EmailAddress FirstName LastName DownloadID UseriD DownloadDate FileName ProductID Products ProductiD ProductName

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!

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...

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...

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 (...

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...

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...

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...

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 (...

Add three rows to the Downloads table. Add data for all the fields. One row for user 1 and product 1 One row for user 2 and product 1 One row for user 2 and product 2 Use the NOW function to insert...

Use the diagram above to answer the following question 1. Write an ALTER TABLE statement that adds two new columns to the Products table. Add one column for product price that provides for three...

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...

A retail company must file a monthly sales tax report listing the total sales for the month, and the amount of state and county sales tax collected. The state sales tax rate is 4% and the county...

1. Under what conditions did the Supreme Court say it had the power to reverse the EPAs decision not to regulate the carbon dioxide emissions of new vehicles? 2. What did the petitioners, including...

The net income of Nolan Corporation is $ 9 9 , 0 0 0 . The company has 3 0 , 0 0 0 outstanding shares, and a 1 0 0 percent payout policy. The expected value of the firm one year from now is $ 1 , 8 2...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

6. Explain how to train managers to coach employees.

5. Tell how job experiences can be used for skill development.

4. Explain the characteristics of successful mentoring programs.