EBK ESSENTIALS OF MIS
12th Edition
ISBN: 8220101459305
Author: LAUDON
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 10HMP
Explanation of Solution
Brand specifications Price per unit (USD) Price for 30 units (in USD) Dell Desktop Dell Inspiron 3647 SFF Intel Pentium Dual Core 3.1 Ghz|4GB RAM|500 GB HDD|18.5” Monitor 390 11700 Lenovo desktop Lenovo S500 Desktop [Intel Core i3-4170 3.7 Ghz/4GB RAM/ 500GB/18.5” Monitor] (10HS001SIH) 465 13950 HP Desktop HP Slimline Desktop- 455-012il [Intel Core i3-4170 3.7 Ghz/ 4GB RAM/ 1000GB/18.5” Monitor 510 15300 Price for 15units (in USD) HP Printer HP LaserJet Pro M403dn 1200×1200 dpi, 38 ppm, with Auto-duplex & Network 510 7650 Dell Printer Dell H825 CDW 600×600 dpi, 30ppm, ethernet & wifi 400 6000 Canon...
Brand | specifications | Price per unit (USD) | Price for 30 units (in USD) |
Dell Desktop | Dell Inspiron 3647 SFF Intel Pentium Dual Core 3.1 Ghz|4GB RAM|500 GB HDD|18.5” Monitor | 390 | 11700 |
Lenovo desktop | Lenovo S500 Desktop [Intel Core i3-4170 3.7 Ghz/4GB RAM/ 500GB/18.5” Monitor] (10HS001SIH) | 465 | 13950 |
HP Desktop | HP Slimline Desktop- 455-012il [Intel Core i3-4170 3.7 Ghz/ 4GB RAM/ 1000GB/18.5” Monitor | 510 | 15300 |
Price for 15units (in USD) | |||
HP Printer | HP LaserJet Pro M403dn 1200×1200 dpi, 38 ppm, with Auto-duplex & Network | 510 | 7650 |
Dell Printer | Dell H825 CDW 600×600 dpi, 30ppm, ethernet & wifi | 400 | 6000 |
Canon... |
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
QUESTION 5
Consider the following two tables:
Table1: Products
productID
productName
unitPrice
entryDate
expiryDate
P1
Dell Laptop
350
16-10-2016
30-10-2016
P2
Apple mobile
420
17-02-2018
02-03-2018
P3
Samsung Mobile
330
20-08-2020
30-08-2020
P4
HP Printer
80
21-09-2019
05-10-2019
P5
Canon Printer
150
15-05-2020
20-06-2020
Table2: Orders
orderID
Quantity
Price
productID
1
10
3300
P3
2
5
1800
P1
3
20
1600
P4
4
20
3000
P5
5
9
1100
P7
6
8
2250
P10
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 p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price
FROM Products AS p
INNER JOIN Orders AS o
ON p. productID = o. productID;
2. SELECT p. productName, p.…
Using the PC Purchase Data, calculate the confidence, support, expected confidence, and lift for the following association rule:
If an Intel Core i7 is chosen, then a 750-GB hard drive is purchased
Several credit card firms now give users one-time-use credit card
numbers as an extra layer of security for online purchases. There is
just one purpose for these numerals. Customers may get the
one-time-use number by visiting the website of the organization that
issued their credit card. What are the advantages of employing this
technology as opposed to more traditional methods of utilising credit
card numbers? What are the advantages and disadvantages of
employing this approach as opposed to using an electronic payment
gateway for your own authentication?
Knowledge Booster
Similar questions
- USE EXCEL PLEASE A buyer and seller execute buy-back contract. For the seller, the cost of manufacturing a Ski-Jacket is $35 per unit. The buy-back price is $42/unit, and the fixed cost is $100000. For the buyer, the selling price is $95/Ski-Jacket, the purchase price is $55/Ski-Jacket and the purchase quantity is 15,000. The demand for the buyer follows a discrete distribution as given below: Demand Probability 12,000 0.071 13,000 0.071 14,000 0.143 15,000 0.143 16,000 0.214 17,000 0.07 18,000 0.143 19,000 0.145 What is the expected supply chain profit?arrow_forwardMany of you register for courses online. The computer knows all the courses that are available each semester, and also knows which ones you are taking. It makes sure that you can't register for too many courses, that you can't take the same course twice, that you have taken the prerequisites, and that a course is not oversubscribed. A registration system has many users. You've probably only seen the system from the point of view of a student. You want to know what courses you signed up for, and maybe how many more hours you need to take to have a full load. But you don't need to know 3 who is signed up for a particular course. This is only needed by teachers. Teachers will want a course listing and will need to assign grades to each student in a course. But teachers don't decide which courses are going to be offered each semester. This is done by some administrator. So, there are at least three views of a student registration system; the student's view, the teacher's view, and the…arrow_forwardTo be more specific, what do you mean when you refer to "rate limiting"?arrow_forward
- Conduct an interview with a bilingual person (speaking both Spanish and english) who works or is associated with the health/sector. Ask him/her the following questions: 1) Name and nationality. 2) How many languages do you speak? What are they? 3) What motivated you to learn a foreign language? 4) How does it benefit you (personally, socially, culturally, or professionally)? 5) In your opinion, what is the best way to learn a foreign language? 6) What would you recommend to a caregiver who is now learning Spanish? 7) Add your own question of interest and answersarrow_forwardComputer Science Please Please use your own words there is a plagiarism check. (Please focus on these three points please ) Question 1: You own a logistic company in Oman, and you utilize Artificial Intelligence to secure your company's IT. Write a report that includes the following points: • Why have you chosen Artificial Intelligence to secure your IT. • What did the Logistics Company benefit from utilizing Artificial intelligence with its impact.' • The opportunities and challenges of Artificial Intelligence.arrow_forwardTesla company willing to converts its sales to online-only for cutting costs. It has decided to release a web app/system for automating the order process. The company will sell two specific models online (Model X and Model Y). Customer can use the Tesla system to: 1. Create an account: Customers will provide their information in a form. The system will validate the provided information and return the account details to customers. Creating an account should be done before any other process. 2. Place an order: To place an order, the Customer must first select his country from a menu and then select the desired model. After that, the Customer should log in to his Account and complete his delivery details. This includes the delivery location and time. Tesla will check the manufacturer line and send an estimated delivery time to the Customer. If the Customer confirmed the date, the system requires paying in full. Customer can use only credit cards or Bitcoin for paying. In both cases, the…arrow_forward
- HW2.pdf > HW 2 Q1 \ list the types of cooling systems Q2 \ How to Calculate Wattage Capacity? Q3 \ List the types of intel and AMD chipsets Q4 \ List types of Expansion Slots Q5 \ list processor components Q6\ list the four major categories of memory modules Q7 \ list the HARD drive types and mention the best type Q8 \ list RAID types and mention the benefit for each type Q9 \ list the types of file system Q10\ List the types of discs and mention Storage capacities for each type Yasir AL-abediarrow_forwardOn your home and school computer, find the CPU speed (in GHz), main memory size (in GB), and the size of the hard drive (in GB). Also find the operating system and its version.arrow_forwardWhen you bought your computer, had you heard of Linux? If so, where had you heard about it?arrow_forward
- QUESTION 1 The OMCA club operations When members join OMCA health club, they pay a fee for a certain length of time. Most memberships are for 1 year, but memberships for short periods are available. Due to various promotions throughout the year, it is common for members to pay different amounts for the same length of membership. The club wants to e-mail reminders to members to ask them to renew their memberships one month before their memberships expire. Some members have been angry with staff when asked to renew at a much higher rate than their original membership contract. So, the club needs staff to keep track of the price paid so that the managers can override the regular prices with special prices when members are asked to renew. The system must keep track of these new prices so that renewals can be processed accurately. One of the problems in the health club industry is the high turnover rate of members. Although some members remain active for many years, about half of the…arrow_forwardWhich airline assets matter most? How much computer power does the company need to operate for a short time? (1–2 days). What methods or processes might it use during the tragedy?arrow_forwardPLZ help with the following: Build a mid range $3000 CAD/CAM workstation only need the main parts of the computer. So CPU, Fan, power, graphics card, storage etc.arrow_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
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning