Fundamentals of Information Systems
8th Edition
ISBN: 9781305082168
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 2SAT
Program Plan Intro
If the average order size for B2C commerce is greater than for B2B commerce or not
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What are the differences between a Type 1 hypervisor and a Type 2 hypervisor?
Insert the following records into the tables CLIENT and CLIENT_DETAILS
CLIENT
Client_no Client_Name Address
Order Date
C100
DELL
AMERICA 05-05-2018
C101
SANDISK
KINGDOM 10-10-1998
C102
SAMSUNG KOREA
12-08-2010
C103
LENOVO
JAPAN
10-07-1998
CLIENT_DETAILS
Client_no
Order_No Product
Cost
Quantity
Status
C100
R001
JIOCLASS
100.40
3000
PROGRESS
C101
R002
SMARTWATCH 300.50
4000
DELIVERED
C102
RO01
SPYCAMERA
600.10
2000
PROGRESS
C103
R003
IROBOT
4000
DELIVERED
C104
R002
RADAR
500.00
400
PROGRESS
Consider the below tables
Customer
CustomerNo (PK)
Order
Order No
CustomerName
11 Ali AlMansoori
12 Sarah Sulaiman
13 Maha Al Ali
OrderDate
10/01/2018
110
114 11/01/2018
116 11/01/2018
118 12/01/2018
120 14/01/2018
122 17/01/2018
CustomerAddress
Block A, No. 6, Khalifa B
Aljazeera Tower, Aprt 180, Corniche Rd
Etihad Tower, Aprt 2022, Hamdan ST
OrderAmount
OrderDate
10/01/2018
11/01/2018
11/01/2018
12/01/2018
14/01/2018
17/01/2018
17000
8000
21000
2200
42500
50100
CustomerNo (FK)
Display the customer name, order date, and order amount in Dollar ($). Label the column Summary Report.
CustomerName
OrderAmount
Ali AlMansoori
Sarah Sulaiman
Sarah Sulaiman
Maha Al Ali
Ali AlMansoori
Maha Al Ali
11
12
12
13
11
13
$17,000
$8,000
$21,000
$2,200
$42,500
$50,100
Chapter 5 Solutions
Fundamentals of Information Systems
Ch. 5 - Prob. 1LOCh. 5 - Prob. 2LOCh. 5 - Prob. 3LOCh. 5 - Prob. 4LOCh. 5 - Prob. 5LOCh. 5 - Prob. 6LOCh. 5 - Prob. 7LOCh. 5 - Prob. 1.1DQCh. 5 - Prob. 1.2DQCh. 5 - Prob. 1.1CTQ
Ch. 5 - Prob. 1.2CTQCh. 5 - Prob. 2.1DQCh. 5 - Prob. 2.2DQCh. 5 - Prob. 2.1CTQCh. 5 - Prob. 2.2CTQCh. 5 - Prob. 1SATCh. 5 - Prob. 2SATCh. 5 - Prob. 3SATCh. 5 - Prob. 4SATCh. 5 - Prob. 5SATCh. 5 - Prob. 6SATCh. 5 - Prob. 7SATCh. 5 - Prob. 8SATCh. 5 - Prob. 9SATCh. 5 - Prob. 10SATCh. 5 - Prob. 11SATCh. 5 - Prob. 12SATCh. 5 - Prob. 13SATCh. 5 - Prob. 1RQCh. 5 - Prob. 2RQCh. 5 - Prob. 3RQCh. 5 - Prob. 4RQCh. 5 - Prob. 5RQCh. 5 - Prob. 6RQCh. 5 - Prob. 7RQCh. 5 - Prob. 8RQCh. 5 - Prob. 9RQCh. 5 - Prob. 10RQCh. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 1DQCh. 5 - Prob. 2DQCh. 5 - Prob. 3DQCh. 5 - Prob. 4DQCh. 5 - Prob. 5DQCh. 5 - Prob. 6DQCh. 5 - Prob. 7DQCh. 5 - Prob. 8DQCh. 5 - Prob. 9DQCh. 5 - Prob. 10DQCh. 5 - Prob. 11DQCh. 5 - Prob. 12DQCh. 5 - Prob. 13DQCh. 5 - Prob. 1PSECh. 5 - Prob. 2PSECh. 5 - Prob. 3PSECh. 5 - Prob. 1WECh. 5 - Prob. 2WECh. 5 - Prob. 1CECh. 5 - Prob. 2CECh. 5 - Prob. 1.1CSCh. 5 - Prob. 1.2CSCh. 5 - Prob. 1.1aCSCh. 5 - Prob. 1.2aCSCh. 5 - Prob. 2.1CSCh. 5 - Prob. 2.2CSCh. 5 - Prob. 2.1aCSCh. 5 - Prob. 2.2aCS
Knowledge Booster
Similar questions
- Consider the following two tables: Table1: Customers customerID Fname Lname email City ZipCode 100 Salma Amri salma@gmail.com Salalah 211 101 Rami Kalabani Rami@hotmail.com Sohar 205 102 Adnan Harthi Adnan@yahoo.com Sur 201 103 Amro Alshukaili Amro@gmail.com Bahla 208 104 Maatz Rawas Maataz@gmail.com Salalah 211 Table2: Orders orderID orderDate amount customerID 1 07/04/2019 234$ 100 2 03/14/2020 78$ 103 3 05/23/2019 124$ 102 5 07/21/2018 25$ 104 6 11/27/2019 14$ 102 7 12/07/2020 55$ 106 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it). 1. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount FROM Customers AS c INNER JOIN Orders AS o ON c. customerID = o. customerID;…arrow_forwardWhat is Power Pivot & Power Query?arrow_forwardWhat do you understand by query optimization?arrow_forward
- Choose the best answer from following answers:C(x): x is taking CSE 105. M(x):x is a CSE major. ∀×(M(x)^C(x)) in English is a) Every student is a CSE major and they all are taking CSE 105b) Every CSE student is taking CSE 105c) None of the abovearrow_forwardSQL Server Integration Services: What's It Good For?arrow_forwardReview the sample eCommerce ERD after 3NF. PK credit CardID FK customerID Credit Card credit CardNumber expDate CCV PK orderID FK customerID FK billingAddressID FK shippingAddressID FK creditCardID Order order Date order Total OrderLine PK orderLineID FK orderID FK productID quantity unitPrice 90°F Sunny nama PK productID FK categoryID Product PK customerID firstName lastName userName password Customer PK addressID FK customerID FK addressTypeID city address address2 state Address zip country ProductCategory PK productID FK categoryID PhoneType PK phoneTypeID name Phone PK phonelD FK phoneTypeID FK customerID phoneNumber name Address Type PK addressTypeID Qarrow_forward
- QI Based on Figure Q1(a) and Figure Q1(b), answer question Q1(a) and Q1(b). Patient name Desired appointment Availahle appts Scheduled appt Make or change appointment Available appointments Scheduled appt D11 Appointments Appointment to change " Check Patient name Existing Patients 2 |Patient Collect new information patient information New Patient Patient information D22 Patient Аppt notification card Patient Contact Info 3 Send appointment reminder Current date Scheduled appts card FIGURE QI (a) When new patients come in for the first time, they fill out a patient information form with their name, address, phone number, and a brief medical history, which is then saved in the patient information file. When a patient phones to make a new appointment or change an existing one, the Medical Berjaya Clinic receptionist searches through the appointment file for an open slot. The appointment is scheduled once a suitable time for the patient has been identified. If the patient is a new…arrow_forward1. explain in details Query optimization 2 . Examples of Query Optimization 3. Explain in details Advantages and disadvantages of Query Optimizationarrow_forwardQUESTION 4 – DISTRIBUTED QUERY PROCESSINGImplement the query below and explain how the processing of display theeBayExpress price display ?SELECT c.Name, p.Title, sc.Quantity,p.eBayExpressPrice, s.NameFROM ShoppingCart sc, Product p,Customer c, Seller sWHERE sc.CustomerID =c.CustomerID ANDsc.ItemNumber =p.ItemNumber ANDsc.OrderStatus = 'active'AND c.Country ='USA' ANDp.SellerID =s.SellerID1. Show the operator tree without optimization.2. Show the optimized operator tree.3. Please refer to the optimized operation tree (after localization and reduction)Show the distributed query plan .arrow_forward
- How do e-commerce applications, find the number of certain items, and average daily sales obtain by each company from the start date and end date, through MapReduce queryarrow_forwardHow do SQL server 2000 and XML linked? Can XML be used to access data? FOR XML (RoW, AUTO, EXPLICIT)arrow_forwardGiven the ORDER, ORDER_DETAIL, CUSTOMER, and PRODUCT tables. CUSTOMER CUSTOMER_ID CUSTOMER_NAME 1565 Emre 1789 Akif 1265 Eyup 4537 Fatih 6542 Murat CITY CITY_ID CITY_NAME 1 Gaziantep 2 Balıkesir 3 Edirne 4 Van 5 Rize 6 Kayseri ORDER ORDER_ID ORDER DATE 1 05.08.2012 2 11.04.2015 3 12.06.2013 4 02.05.2015 5 02.09.2014 ADDRESS CITY_ID CITY_NAME Gatem 2 Rasaf yolu 1 Damlacık 6 köyü Seyrantepe 1 Sarıgüllük PRODUCT PRODUCT_ID PRODUCT_NAME PRICE (TL) 1 Bilgisayar 3250 2 Telefon 1800 3 Monitör 650 4 Klavye 45 5 1200 Televizyon Masa 6 60 CUSTOMER_ID 1565 1265 4537 6542 1565 ORDER_DETAIL ORDER_ID PRODUCT_ID 1 1 1 3 1 4 2 4 3 4 3 5 4 1 4 3 4 5 4 6 5 1 5 3arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage