rice to 7 AND ProductName to chocolates (post a screen shot of product table’s content after executing the command) [1 mark] 8. Create a view of the supplier named supplier_information; the view must include the SupplierID and SupplierName for the Supplier which supplying the ProductNum =1

rice to 7 AND ProductName to chocolates (post a screen shot of product table’s content after executing the command) [1 mark] 8. Create a view of the supplier named supplier_information; the view must include the SupplierID and SupplierName for the Supplier which supplying the ProductNum =1

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter4: Analyzing And Charting Financial Data

Section: Chapter Questions

Problem 2.9CP

See similar textbooks

Similar questions

Question 1: Modify the select statement in this section to display the hire_date column in the format: January 10, 2012. (7-3) Question 2: Add a new row to a copy of the employees table, sec0703_employees. Set the hire date to show that the person was hired at 10:00 AM. (7-6) Question 3: assist me with a new sequence named seq0706_my_stuff. Set the beginning value to 100. (7-7) Question 4: Determine the current value of the sequence seq_sec0707. Then use its next three values to add new rows to the sec0707_sequence table. This table has only one column. It holds the value of the sequence number. (7-9) Question 5: Build an index on a copy of the departments table, sec0709_departments. Index the department_name field. (7-12) Question 6: Find information about the datatypes of all the columns of the l_foods table. (7-14) Question 7: Find out what indexes there are on the l_departments table. (7-16) Question 8: Find…
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
CREATE TABLE consumer ( ConsumerID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Age INT, Gender VARCHAR(10), OnlineInStore VARCHAR(20)); INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (1, 'John', 'Doe', 25, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (2, 'Jane', 'Smith', 30, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (3, 'Mike', 'Johnson', 20, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (4, 'Sarah', 'Williams', 35, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (5, 'Chris', 'Davis', 28, 'Male', 'Online'); CREATE TABLE InStoreRetailer ( RetailerID INT PRIMARY KEY, RetailerName VARCHAR(50), StoreLayout VARCHAR(50), CustomerService…
Demonstrate how to create the tot credits (year, num credits) view, which displays the total amount of credits earned in each year.
Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To decrease the postal costs, they will send gifts to owners in batches to their corresponding offices. Similarly, the marketing team will send the gifts in groups to the residents living in the same property. Therefore, you will need to provide them the number of gifts for each StayWell office and number of gifts for each property. The column headers for the first table should be OFFICE_NUM and GIFTS, the column headers for the second table should be PROPERTY_ID and GIFTS.
Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To decrease the postal costs, they will send gifts to owners in batches to their corresponding offices. Similarly, the marketing team will send the gifts in groups to the residents living in the same property. Therefore, you will need to provide them the number of gifts for each StayWell office and number of gifts for each property. The column headers for the first table should be OFFICE_NUM and GIFTS, the column headers for the second table should be PROPERTY_ID and GIFTS. Provide the StayWell team the number of gifts for each office. Provide the StayWell team the number of gifts for each residence.
Q1: Create the following related tables using appropriate data field specification: (Hint: Define all constraints in column level) Products Product Id Product Name Customers Customer Id Customer_Name Pro_id Q2: Modify the Products table to add a new field with name "Product date" which Contains a unique constraint. (Hint: solve this question by one command only). Q3: Modify the Products table to remove the unique constraint which added in Q2. Notes: Write the question number for each answer. Save your answers on notepad as .txt file and upload it on Elearning. Good Luck
9. Write a SELECT statement that uses aggregate window functions to calculate the total due for all vendors and the total due for each vendor. Return 3 Columns: The vendor id from the Invoices table. The balance due (invoice_total-payment_total-credit_total) for each invoice in the invoices table with a balance greater than 0. The total balance due for all vendors in the Invoices table. Modify the column that contains the balance due for each vendor so it contains a cumulative total by balance due.
Create a view called HOMEWORK13 that includes the columns named Col1 and Col2 from the FIRSTATTEMPT table. Make sure the view is created even if the FIRSTATTEMPT table doesn’t exist.
Create a list of all customer numbers along with text indicating whether the customer has been referred by another customer. Display the text “NOT REFERRED” if the customer wasn’t referred to JustLee Books by another customer or “REFERRED” if the customer was referred.
A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
Create a view named CONDO_FEES. It consists of two columns: the first is the square footage, and the second is the average fee for all condos in the CONDO_UNIT table thathave that square footage. Use AVERAGE_FEE as the column name for the average fee.Group and order the rows by square footage. a. Write and execute the CREATE VIEW command to create the CONDO_FEES view. b. Write and execute the command to retrieve the square footage and average fee foreach square footage for which the average fee is greater than 500. c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what arethey? If not, why not?