...manipulation statements. 3 Is the SQL standard supported in whole or in part? Briefly explain. Ans: The SQL standard is supported in part. Because of the size of the previous standard SQL-92 (contains more than 600 pages) and the current SQL: 1999 standard (contains more than 2,100 pages), there are multiple levels that can be supported. No vendor supports the entire SQL-92 standard now. Most vendors support a super/subset of the standard. With the new SQL: 1999 standard, vendor implementation will likely be more fragmented because of the size and scope of the standard. 4 How many levels of conformance does the SQL-92 standard have? Ans: The SQL-92 specification contained three levels: Entry SQL, Intermediate SQL, and Full SQL. Unfortunately, no vendor claimed conformance beyond Entry SQL although most vendors implemented some features in the higher SQL levels as well as providing proprietary SQL extensions. 5 How many levels of conformance do the SQL: 1999 standard have? Ans: The SQL: 1999 standard contains a single level of conformance called Core SQL. At the time of writing of this chapter, no vendor claims conformance to Core SQL although some vendors seem close to conformance. SQL: 1999 contains many features outside of Core SQL grouped into packages. 6 What is standalone SQL? Ans: In standalone SQL, the user submits SQL statements with the use of a specialized editor. The editor alerts the user to syntax errors...
Words: 6440 - Pages: 26
...com/product/mkt-506-wk-8-assignment-2-comparing-advertisements/ Contact us at: SUPPORT@ACTIVITYMODE.COM MKT 506 WK 8 ASSIGNMENT 2 COMPARING ADVERTISEMENTS MKT 506 WK 8 Assignment 2 - Comparing Advertisements Understanding consumer behaviour is an integral part to product sales. Communicating the desired message to the right targeted customer is a must. Select any two (2) advertisements provided in Chapter 4 and 5 of the textbook (attached) Create a matrix, table or a figure to present your responses to the tasks below. Be as creative as you can be. Then, write three to four (3-4) pages paper in which you: 1. Briefly describe the two (2) advertisements you selected. Ensure you include the chapter(s) in which the advertisements are found in the textbook. 2. Determine what customer group(s) is likely to purchase the product with justification for your response. 3. Select no more than three (3) channels by which you would communicate the message of the ad (the ad itself) to the targeted group and detail how each channel selected would serve the ad well. 4. Following Step 2, identify any negative impact or backlash that could occur for one of the channels selected with rationale. 5. Activity Mode aims to provide quality study notes and tutorials to the students of MKT 506 WK 8 Assignment 2 Comparing Advertisements in order to ace their studies. MKT 506 WK 8 ASSIGNMENT 2 COMPARING ADVERTISEMENTS To purchase this visit here: http://www.activitymode.com/product/mkt-506-wk-8-assignment-2-comparing-advertisements/ ...
Words: 1231 - Pages: 5
...1. (10 pts). What is the best-selling product, based on the number of orders that contain one or more orders of that product? (a) Gorgonzola Telino. (b) Select p.productname, od.productID, sum(quantity) as OrderCount from OrderDetails as od left join products as p on od.productID = p.productID group by od.productID order by sum(quantity) desc; 2. (10 pts). List the number of customers by country, from least to most. (a) Country NumCustomers Ireland 1 Norway 1 Poland 1 Austria 2 Belgium 2 Denmark 2 Finland 2 Portugal 2 Sweden 2 Switzerland 2 Argentina 3 Canada 3 Italy 3 Venezuela 4 Mexico 5 Spain 5 UK 7 Brazil 9 France 11 Germany 11 USA 13 (b) SELECT Country, COUNT(*) AS NumCustomers FROM Customers GROUP BY Country ORDER BY NumCustomers ASC; 3. (10 pts). How many shippers are there, and how many orders has each shipper shipped? 1) How many Shippers are there? (a) There are 3 shippers. (b) SELECT COUNT(*) AS Shippers FROM Shippers 2) How many orders has each shipper shipped? (a) ShipperID 1 (Speedy Express) shipped 54 orders, ShipperID 2 (United Package) shipped 74 orders, and ShipperID 3 (Federal Shipping) shipped 68 orders. (b) SELECT ShipperID, COUNT(*) AS NumOrders FROM Orders GROUP BY ShipperID 4. (20 pts). How many customers have spent, in their lifetime, more than $500 but less than $1,000 and have at least 3 distinct orders? (a) 9 customers spent more than $500 but less than $1,000 and...
Words: 1102 - Pages: 5
...of Form Question 1 Answer saved Marked out of 1.00 Flag question Question text Which of the following is the best beginning to an email request for completion of an online survey about a recently purchased product? Select one: a. Your complete satisfaction is our utmost goal. b. We are conducting a market survey on our products and customer service satisfaction. c. Please complete the attached survey about your recent purchase at our store and click ”Submit” when done. d. Online surveys are a fast, convenient way for us to hear back from our customers. Question 2 Not yet answered Marked out of 1.00 Flag question Question text Informative headings that reveal the conclusions reached in a discussion are generally preferable to than general topic headings or what are sometimes called “label” headings because they provide more information to a reader. Select one: True False Question 3 Not yet answered Marked out of 1.00 Flag question Question text A response that is sent to someone who has invited a persuasive message requires an attention-getting sentence to start the message. Select one: True False Question 4 Answer saved Marked out of 1.00 Flag question Question text Which of the following provides the best definition of a report? Select one: a. An orderly, objective message used to convey information within an organization or between organizations to assist in problem solving and decision making. b. A formal, organized message that conveys the...
Words: 3604 - Pages: 15
...WK 7 ASSIGNMENT 3 SELECT A BANK To purchase this visit here: http://www.activitymode.com/product/fin-410-wk-7-assignment-3-select-a-bank/ Contact us at: SUPPORT@ACTIVITYMODE.COM FIN 410 WK 7 ASSIGNMENT 3 SELECT A BANK FIN 410 WK 7 Assignment 3 - Select a Bank Use the Internet to research either TD Bank or Wells Fargo. Write a four to five (4-5) page paper in which you: 1. Determine what your selected organization would need to take into account when managing interest rate risk and the related impact it may have to business performance. 2. Examine how the bank’s risk management plan uses derivatives. If they don’t currently use derivatives, then assess whether or not this can be a valuable tool for them. Provide support for your rationale. 3. Examine how the bank’s risk management plan uses other hedging tools. If the bank does not currently use any of them, then assess whether or not these can be valuable tools for it. Provide support for your rationale. 4. Propose a major investment for the organization you selected. Support your recommendation with net present value, pertinent financial ratios, and break-even analysis. More Details hidden... Activity mode aims to provide quality study notes and tutorials to the students of FIN 410 WK 7 Assignment 3 Select a Bank in order to ace their studies. FIN 410 WK 7 ASSIGNMENT 3 SELECT A BANK To purchase this visit here: http://www.activitymode.com/product/fin-410-wk-7-assignment-3-select-a-bank/ Contact...
Words: 694 - Pages: 3
...SELECT column_list FROM table-name [WHERE Clause] [GROUP BY clause] [HAVING clause] [ORDER BY clause]; SELECT name, salary, salary*1.2 AS new_salary FROM employee WHERE new_salary /salary*1.2 > 30000; SELECT first_name, last_name, subject FROM student_details WHERE subject IN/NOT IN ('Maths', 'Science'); Select * from product p where EXISTS (select * from order_items o where o.product_id = p.product_id) ------------------------------------------------- SELECT user.name, course.name ------------------------------------------------- FROM `user` ------------------------------------------------- RIGHT JOIN `course` on user.course = course.id SELECT name, salary FROM employee ORDER BY 1, 2; ELECT name, salary FROM employee ORDER BY name DESC, salary DESC; SELECT COUNT (DISTINCT name) FROM employee; HAVING Group functions (MAX,MIN) cannot be used in WHERE Clause but can be used in HAVING clause. SELECT dept, SUM (salary) FROM employee GROUP BY dept HAVING SUM (salary) > 25000 INSERT INTO TABLE_NAME [ (col1, col2, col3,...colN)] VALUES (value1, value2, value3,...valueN); INSERT INTO employee (id, name, dept, age, salary location) SELECT emp_id, emp_name, dept, age, salary, location FROM temp_employee; Copy data from A to B. Select first then insert If you are inserting data to all the columns, the above insert statement can also be written as, INSERT INTO employee SELECT...
Words: 652 - Pages: 3
...2033 Management Information Systems Assignment 3 – Business Intelligence IMB Cognos Insight is a personal analytics solution that empowers users to independently explore, analyze, visualize and share data without relying on IT for assistance. IBM Cognos Insight delivers data interactivity, analysis and visualization capabilities to individual desktop users. You may use IBM Cognos Insight in the ATAC lab or install a fully functional version on your computer from their website https://www.analyticszone.com/homepage/web/displayHomePage.action . For this, you need to register with Analytics Zone. Note that it may take several days or more for the company to verify your identity and give you access to the software. A number of online tutorials are available at http://ibmtvdemo.edgesuite.net/software/analytics/cognos/videos/HTVs/ci102/index.html Part 1. Getting started. Download the file “Sample - Superstore Subset (Excel).xlsx” from D2L on your computer. Unzip it if necessary (i.e., extract the files from the zip archive). Put it into the folder where you will store all the files for this assignment. I recommend using a special folder on a memory key or a folder on your laptop. If you start moving your files later, you may have a problem connecting to this data source. In BI, dimensions are categorical fields that are used to slice the data. Those are non-numerical data types. You cannot do calculations (e.g., add, subtract, etc.) on these data types. In contrast...
Words: 1054 - Pages: 5
...only the customer named Juan Ortega shows up in both customer tables.) SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER UNION SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER_2; 4. Write the query that will generate a combined list of customers to include the duplicate customer records. SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER UNION ALL SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER_2; 5. Write the query that will show only the duplicate customer records. We have shown both Oracle and MS Access query formats: Oracle SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER INTERSECT SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER_2; MS Access SELECT C.CUST_LNAME, C.CUST_FNAME FROM CUSTOMER AS C, CUSTOMER_2 AS C2 WHERE C.CUST_LNAME=C2.CUST_LNAME AND C.CUST_FNAME=C2.CUST_FNAME; Because Access doesn’t support the INTERSECT SQL operator, you need to list only the rows in which all the attributes match. 6. Write the query that will generate only the records that are unique to the CUSTOMER_2 table. We have shown both Oracle and MS Access query formats: Oracle SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER_2 MINUS SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER; MS Access SELECT C2.CUST_LNAME, C2.CUST_FNAME FROM CUSTOMER_2 AS C2 WHERE C2.CUST_LNAME + C2.CUST_FNAME NOT IN (SELECT C1.CUST_LNAME + C1.CUST_FNAME FROM CUSTOMER C1); Because Access doesn’t...
Words: 1736 - Pages: 7
...Practical Exercise on TRADE MAP PART I: GETTING TO KNOW TRADE MAP IDENTIFYING THE HS OF THE PRODUCT Identify the harmonized system code of the product you want to focus on. Name of the product: Potatoes Provide the harmonised system (HS) code for both the product group and product in question Note: To avoid ambiguities throughout your analysis, it is important to ensure that the description and corresponding trade classification, or tariff code is correct. 4-digit HS: 0702 6-digit HS: 070200 Note: In the selection menu of Trade Map, click on Advanced Search. You can search by keyword the corresponding HS code of the product using one or several keywords through the HS label at 2,4,6 digits level of the Harmonized system and at the national tariff line level. Provide the national tariff line code of the product (NTL) for Vietnam (indicate if several): NTL code: 07101000 NTL code: 20041000 NTL code: 07019000 Provide the national tariff line code of the product (NTL) for USA (indicate if several): NTL code: 0701100000 NTL code: 0701100020 ...
Words: 2732 - Pages: 11
...Kaplan University IT234 Unit 4 Jennifer Polisano 1. In the General Hardware Corp. relational database as shown in Figure 4.1 (pp. 71–72) above: a. How many foreign keys are there in each of the six relations? Answer 1a: There are between three and six foreign keys in each of the six relations. b. List the foreign keys in each of the six relations. Answer 1b: Starting from top left and continuing down, they are Salesperson Number, Salesperson Name, Commission Percentage, Year of Hire, Office Number; Customer Number, Customer Note, Salesperson Number, HQ City; Customer Number, Employee Number, Employee Name, Title; Product Number, Product Name, Unit Price; Salesperson Number, Product Number, Quantity; Office...
Words: 1629 - Pages: 7
...’23-APR-2008’ 619.44); 3. SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER UNION SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER_2; 4. SELECT CUST_LANME, CUST_FNAME FROM CUSTOMER UNION ALL SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER_2; 5. SELECT C CUST_LNAME, C CUST_FNAME FROM CUSTOMER AS C, CUSTOMER_2 AS C2 WHERE C.CUST_LANME = C2.CUST_LNAME AND C CUST_FNAME=C2 CUST_FNAME; 6. SELECT C.CUST_LANME, C.CUST_FNAME FROM CUSTOMER_2 AS C2 WHERE C2.CUST_LNAME + C2.CUST_FNAME NO IN 7. SELECT INV_NUM, CUSTOMER.CUST_NUM, CUST_LNAME, CUST_FNAME, INV_DATE, INV_AMOUNT FROM INVOICE INNER JOIN CUSTOMER ON INVOICE.CUST_NUM=CUSTOMER.CUST_NUM WHERE CUST_BALANCE>=1000; 8. SELECT INV_NUM, AVG_INV, (INV_AMOUNT – AVG_INV) AS DIFF FROM INVOICE, (SELECT AVG(INV_AMOUNT) AS AVG_INV FROM INVOICE GROUP BY INV_NUM, AVG_INV, INV_AMOUNT-AVG_INV 9. CREATE SEQUENCE CUST_NUM_SQ START WITH 1000 NOCACHE; CREATE SEQUENCE INV_NUM_SQ START WITH 5000 NOCACHE; 10. UPDATE CUSTOMER SET CUST_DOB = ’15-MAR-1979’ WHERE CUST_NUM= 1000; UPDATE CUSTOMER SET CUST_DOB = ‘2-DEC=1988’ WHERE CUST_NUM = 1001 11. SELECT CUST_LNAME, CUST_FNAME, ROUND (SYSDATE-CUST_DOB)/365,0) AS AGE FROM CUSTOMER 12. UPDATE CUSTOMER SET CUST_AGE = ROUND((DATE()-CUST_DOB/365,0); 13. SELECT AVG(CUST_AGE) FROM CUSTOMER; 14. CREATE OR REPLACE TRIGGER TRG_UPDATECUST_BALANCE AFTER INSERT ON INVOICE FOR EACH ROW BEGIN UPDATE CUSTOMER SET CUST_BALANCE = CUST_BALANCE + :NEW.INV_AMOUNT WHERE CUST_NUM = :NEW.CUST_NUM; END; TESTING****** SELECT * FROM CUSTOMER; INSERT...
Words: 1092 - Pages: 5
...SQL Server 2012 Tutorials: Analysis Services Multidimensional Modeling SQL Server 2012 Books Online Summary: This tutorial describes how to use SQL Server Data Tools to develop and deploy an Analysis Services project, using the fictitious company Adventure Works Cycles for all examples. Category: Step-by-Step Applies to: SQL Server 2012 Source: SQL Server Books Online (link to source content) E-book publication date: June 2012 Copyright © 2012 by Microsoft Corporation All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher. Microsoft and the trademarks listed at http://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks of the Microsoft group of companies. All other marks are property of their respective owners. The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred. This book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly...
Words: 41061 - Pages: 165
...using computers in their transactions. Pharmacies in particular, are now making their systems computerized since that helps them minimize the time and efforts consumed by using manual system. Point-of-Sale Inventory System is one of the essential components of a successful business. It is a modern replacement for cash register in retail applications. It can help to record securely all the sales and customer’s orders and track products. A sale refers to the exchange of product or services for an amount of money or its equivalent while inventory, on the other hand, is the total amount of items and the act of counting them. A pharmacy owner must know the precise number of items in their storage areas in order to place orders and control losses up to date. Hence, computerizing both Sales and Inventory System will make an easier and faster transaction among the customers as well as monitoring the stocks of the products. Furthermore, the system also gives the person up-to-the-minute and detailed information on each item in your inventory. He/she will know exactly how much inventory comes in; is on-hand now, and where it goes. In fact, most entrepreneurs these days find that computerizing a system gives them a far wider range of information with less effort....
Words: 16309 - Pages: 66
............................10 Main components...................................................................................................................12 Features..................................................................................................................................13 Product registration.................................................................................................................14 Application management........................................................................................................15 Basic terminology...................................................................................................................16 Chapter 2: Installing the product......................................................17 Installation steps.....................................................................................................................18 Download and run the installation package.................................................................18 Select components to install........................................................................................18 Complete installation of the product............................................................................19 Run Policy Manager...
Words: 31829 - Pages: 128
...Part 1 1. What are the Sales Amount by Channel? SELECT DimChannel.ChannelName, Sum(FactSales.SalesAmount) AS SumOfSalesAmount FROM DimChannel INNER JOIN FactSales ON DimChannel.ChannelKey = FactSales.channelKey GROUP BY DimChannel.ChannelName; a. By Channel by Year SELECT DimChannel.ChannelName, DimDate.FiscalYear, Sum(FactSales.SalesAmount) AS SumOfSalesAmount FROM DimDate INNER JOIN (DimChannel INNER JOIN FactSales ON DimChannel.ChannelKey = FactSales.channelKey) ON DimDate.Datekey = FactSales.DateKey GROUP BY DimChannel.ChannelName, DimDate.FiscalYear; b. Show the results with the best year at the top SELECT DimChannel.ChannelName, DimDate.FiscalYear, Sum(FactSales.SalesAmount) AS SumOfSalesAmount FROM DimDate INNER JOIN (DimChannel INNER JOIN FactSales ON DimChannel.ChannelKey = FactSales.channelKey) ON DimDate.Datekey = FactSales.DateKey GROUP BY DimChannel.ChannelName, DimDate.FiscalYear ORDER BY Sum(FactSales.SalesAmount) DESC; 2. What are the different types of Promotions? SELECT DimPromotion.PromotionName FROM DimPromotion; c. What are the start and end dates for each promotion. Put the oldest start dates first SELECT DimPromotion.PromotionName, DimPromotion.StartDate, DimPromotion.EndDate FROM DimPromotion ORDER BY DimPromotion.StartDate; 3. What are the quantity and the amounts of items returned grouped by Channel then by Manufacturer? SELECT DimChannel.ChannelName, DimProduct.Manufacturer, Sum(FactSales.ReturnQuantity)...
Words: 318 - Pages: 2
