Computers and Technology, 06.12.2019 06:31, 2019reynolds

Create an updatable view named vendoraddress that returns the vendorid, both address columns, and the city, state, and zip code columns for each vendor. then, write a select query to examine the result set where vendorid=4. next, write an update statement that changes the address so that the suite number (ste 260) is stored in vendoraddress2 rather than in vendoraddress1. to verify the change, rerun your select query.

Answers: 1

Show answers

Similar questions

Computers and Technology, 27.11.2019 06:31, sherry59Sherry59

1. write a create view statement that defines a view named invoicebasic that returns three columns: vendorname, invoicenumber, and invoicetotal. then, write a select statement that returns all of the columns in the view, sorted by vendorname, where the first letter of the vendor name is n, o, or p.2. create a view named top10paidinvoices that returns three columns for each vendor: vendorname, lastinvoice (the most recent invoice date), and sumofinvoices (the sum of the invoicetotal column). return only the 10 vendors with the largest sumofinvoices and include only paid invoices.3. create an updatable view named vendoraddress that returns the vendorid, both address columns, and the city, state, and zip code columns for each vendor. then, write a select query to examine the result set where vendorid=4. next, write an update statement that changes the address so that the suite number (ste 260) is stored in vendoraddress2 rather than in vendoraddress1. (make sure to rerun your select query in order to verify the change)4. create a view named accountbyvendor that returns the sum of invoicelineitemamounts in the invoicelineitems table, grouped by vendorname and accountdescription.5. modify the invoicebasic view created in exercise 1 to sort the result set by vendorname.

Answers: 2

continue

Computers and Technology, 27.11.2019 20:31, angelicar1160

Write a script that implements the following design in a database named mywebdb: users table colums are : userid(the is the primary key), emailaddress, firstname, lastname downloards table colums are: downloardid(the is the primary key), userid, downloarddate, filename, productid product table colums are: productid(the is the primary key), productname create a new database called mywebdb using the default settings.(if the database already exists, delete it and then recreate it.) write code to create the users, download and products table. write code to define the userid column in the users table, the productsid column in the products table, and the downloadid column in the downloads table as primary keys and identity columns. in the downloads table, write code to define the userid and productid columns are the foreign keys. write code to setup table relationships based on above diagram write code to define the columns so none of them allow null values write code to create a unique index on the emailaddress and productname columns and a regular index on the downloaddate column. include any indexes that you think are necessary.

Answers: 1

continue

Computers and Technology, 27.11.2019 23:31, Jade1214

Use mysql workbench to create an eer model from the script file named create_my_guitar_shop.sql that’s in the mgs_ex_starts folder. from the model, create an eer diagram that shows the relationships between the seven tables in the database. (the administrators table is not related to the other six tables.) 2. use mysql workbench to create an eer diagram for a database that stores information about the downloads that users make. each user must have an email address, first name, and last name. each user can have one or more downloads. each download must have a filename and download date/time. each product can be related to one or more downloads. each product must have a name. 3. use mysql workbench to open the eer diagram that you created in exercise 2. then, export a script that creates the database and save this script in a file named ex10-3.sql. next, use mysql workbench to open this file and review it. 4. write a script that adds an index to the my_guitar_shop database for the zip code field in the customers table. 5. write a script that implements the following design in a database named my_web_db: in the downloads table, the user_id and product_id columns are the foreign keys. include a statement to drop the database if it already exists. include statements to create and select the database. include any indexes that you think are necessary. specify the utf8 character set for all tables. specify the innodb storage engine for all tables. write a select statement that joins the three tables and retrieves the data from these tables like this: sort the results by the email address in descending sequence and the product name in ascending sequence. 6. create a view named order_item_products that returns columns from the orders, order_items, and products tables. this view should return these columns from the orders table: order_id, order_date, tax_amount, and ship_date. this view should return these columns from the order_items table: item_price, discount_amount, final_price (the discount amount subtracted from the item price), quantity, and item_total (the calculated total for the item). this view should return the product_name column from the products table. 7. create a view named product_summary that uses the view you created in exercise 6. this view should return summary information about each product. each row should include product_name, order_count (the number of times the product has been ordered) and order_total (the total sales for the product). 8. write a select statement that uses the view that you created in exercise 7 to get total sales for the five best selling products.

Answers: 1

continue

Computers and Technology, 30.11.2019 03:31, BraedynM7866

Write a create view statement that defines a view named invoicebasic that returns three columns: vendorname, invoicenumber, and invoicetotal. then, write a select statement that returns all of the columns in the view, sorted by vendorname, where the first letter of the vendor name is n, o, or p.

Answers: 3

continue

Do you know the correct answer?

Create an updatable view named vendoraddress that returns the vendorid, both address columns, and th...

Questions in other subjects:

Mathematics, 10.02.2021 14:00

A close friend of mine named Kiki planned something behind my back, why did this make me offended but also attracted to her?...

Spanish, 10.02.2021 14:00

1. ¿Qué significa la frase "Todo el fútbol español se volcó con el jugador de Barakaldo" en el párrafo 2? A La afición española de fútbol no podía creer lo que le estaba suc...

Health, 10.02.2021 14:00

What kind of tissue connects muscle to muscle?...

Mathematics, 10.02.2021 14:00

Find the value of x that makes lines u and v parallel, answer needed

English, 10.02.2021 14:00

Question You have been asked to write a speech about people’s attitudes to animals to broadcast in response. Write the words of your speech. In your speech you should: • identify a...

Mathematics, 10.02.2021 14:00

Complete the missing parts of the table for the following function. y=5x

English, 10.02.2021 14:00

Question You have been asked to write a speech about people’s attitudes to animals to broadcast in response. Write the words of your speech. In your speech you should: • identify a...

Mathematics, 10.02.2021 14:00

Determine the number of decimals places in each decimal 1. 0.3782. 8.18673. 9419.44. 77.645. 9.05072...

Mathematics, 10.02.2021 14:00

Please solve and receive brain list ...

History, 10.02.2021 14:00

URGENT this is due at 11:59 ty :) ...

Other tasks in the category: Computers and Technology More task