Question: Create a table in your database ( usernamedb ) to represent the REAL _ ESTATE table above. The ID should be a surrogate key that's

Create a table in your database (usernamedb) to represent the REAL_ESTATE table above. The ID should be a surrogate key that's with
10 and increments by 10. If you mess up, it's not essential that the values are exact.
Write Insert Statements to insert the 5 rows above into the REAL_ESTATE table. I do NOT need to see the insert statements, just execute
them against your table from #1. If you run a select on the table and the rows exist, then I will be able to see them.
A Table already exists in your database called INVENTORY. There are 3 rows. The 3rd row had the item name truncated because the data
type was varchar(5) instead of varchar(50). Change the item column to a data type of varchar(50).
Update the item column of row 3 to "Windows" in the INVENTORY table.
 Create a table in your database (usernamedb) to represent the REAL_ESTATE

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!