程序代写代做代考 data mining information theory algorithm Excel database decision tree deep learning AI SQL IT enabled Business Intelligence, CRM, Database Applications

IT enabled Business Intelligence, CRM, Database Applications

Sep-18
Introduction
Data Mining and Business Intelligence
Prof. Vibhanshu (Vibs) Abhishek
The Paul Merage School of Business
University of California, Irvine
BANA 273 Session 1

1

Agenda
Introduction
Instructor and TA
Course Logistics
Data Mining Examples
SQL

2

About the Instructor
Undergraduate degree in Computer Sc & Engr
Indian Institute of Technology, Kanpur
Masters in Statistics
University of Pennsylvania, The Wharton School
Ph.D in Operations and Information Management
University of Pennsylvania, The Wharton School
Assistant Professor at Carnegie Mellon University
Just joined UCI 

Teaching
273 Business Intelligence for Analytical Decision Making – BANA/FEMBA
173 Business Intelligence for Analytical Decision Making – UG
Digital Marketing Analytics
Managing Disruptive Technologies

Research

Effect of emerging technologies on consumers, firms and markets

Digital Marketing, Retail, Mobility

5

Some Consulting Projects
Sequoia Capital
Adobe
McKinsey
LEGO
Kaplan
One Championship
Rivigo

6

BSA Survey on Analytics

Other than work …
Startups
Photography
Travel
Anvi

Big Data Analytics: The Revolution Has Just Begun
6:20 to 9:20
Analytics 2012 keynote speaker, Will Hakes

6:20 to 9:20

9

Course Topics
Getting data from Database: Structured Query Language
RFM Analysis, Excel Pivot Tables
Basic Probability & Information Theory
Preparing Data, Testing and Validation
Data Mining Methods
Classification Using Naïve Bayes
Classification using Decision Trees
Association Rule Mining
Clustering

10

Who should take this class
Required core class for MSBA students
No prior technical knowledge is assumed
Aptitude for learning technical concepts
Algorithms
Software (MS Excel, Weka)
Understand business concepts
Course is recommended for students interested in understanding the techniques and applications of data mining and acquiring hands-on skills for making intelligent business decisions in data-rich organizations. 

11

Guidelines for this course
No cell phone or laptop usage in-class unless required for class
UCI Office of Academic Integrity: Do not
Post class materials on non-UCI websites
Do not share individual assignments
Learn about US businesses, language and culture
Groups for class project

Motivation: Business Value of Customer Data
What can a retail store do with shopping basket data?

13

How to increase customer viewership
through tune in ads?

© Prof. V Abhishek, September 18

How can big data be used to reduce fuel
consumption?

How data is utilized is key
Accurate, timely intelligence
Rapid deployment
Effective tactics
Relentless follow-up and assessment

© Prof. V Choudhary, September 18

Business Intelligence & Data Mining

Sep-18

17

Business Intelligence: Components
Reporting
Tooth-paste sales in September?
Cosmetics purchased last quarter?

18

Business Intelligence
Reporting
Tooth-paste sales in September?
Cosmetics purchased last quarter?
Dashboards
Easy access to performance metrics
Ability to drill down into the data

19

Example of Dashboard from MicroStrategy

Example of Dashboard from MicroStrategy

Business Intelligence
Reporting
Tooth-paste sales in September?
Cosmetics purchased last quarter?
Dashboards
Easy access to performance metrics
Ability to drill down into the data
Data Mining

23

Statistics/
AI
Data Mining
Database systems
What Is Data Mining?
Data mining is a process of discovering and interpreting (unknown) patterns in data to solve a business problem.
Machine Learning/
Pattern
Recognition

24
NY Times on 538.com:
Between his live TV appearances on election night, Mr. Silver updated his model and determined around 8
p.m., after New Hampshire went to Senator Obama, that Senator McCain had no way of winning. By the end
of the night, Mr. Silver had predicted the popular vote within one percentage point, predicted 49 of 50
states’ results correctly, and predicted all of the resolved Senate races correctly.

Data Sources for Data Mining
Public and private data
Demographic data
Customer data
Transactions data
Product data
Accounting and marketing data
Web logs (click-stream data)
Application server-logs
Third party server-logs
Data integration is an important challenge

25

Who Uses Data Mining?

26

Amazon’s Personalized Web Pages

Who Uses Data Mining?
Firms with corporate offices in OC

28

Data Mining Methods…
Classification
Clustering
Association Rule Discovery
Decision Trees

Visualization
Collaborative filtering
Text Mining
Neural networks and Deep learning

29

Examples of Visualizing Data:
Word Cloud

Examples of Visualizing Data:
Weekly interface activity
4-dimensional plot uses color, location and size of bubbles

http://www.wolframalpha.com/input/?i=facebook#_=_

Examples of Visualizing Data:
VC’s Facebook Friend Network

© Prof. V Choudhary, September 18

Classification: Definition
Given a collection of records (training set )
Each record contains a set of attributes, one of the attributes is the class.
Find a model for class attribute as a function of the values of other attributes.
Goal: previously unseen records should be assigned a class as accurately as possible.

33

Classification Example

categorical
categorical
continuous
class

Test
Set

Training
Set

Model

Learn
Classifier

34

Example of Decision Tree

categorical
categorical
continuous
class

MarSt
Refund
TaxInc

YES

NO

NO

NO
Yes
No
Married
Single, Divorced
< 80K > 80K
(11, Yes, Divorced, 115K)
(12, No, Single, 150K)

35

© Prof. V Choudhary, September 18

Other Applications for Classification
Direct Marketing – LL Bean
Goal: Reduce cost of mailing by targeting a set of consumers likely to buy a new cell-phone product.

37

Other Applications for Classification
Customer Attrition/Churn at AT&T
16% in 2013
Goal: To predict whether a customer is likely to be lost to a competitor.

38

Who is Watson?
IBM Watson: Final Jeopardy!

0 to 0:25; 1:10 to 2:03; 3:10 to 4:27; 6:30 to 7:40

Nice energetic intro video 6:20 to 9:20

0:40 – 2:20
Data visualization

Hans Rosling Data Visualization

Obama analytics campaign
https://www.youtube.com/watch?v=6ZOfnFCMHTM
Varian Google CIST Informs 7:05 to 8:10

Watson Jeopardy

Watson 0 to 0:25; 1:10 to 2:03; 3:10 to 4:27; 6:30 to 7:40

39

https://www.riverscasino.com/pittsburgh/BrainsVsAI

Sep-18
Structured Query Language

41

Database Management Systems (DBMS)
Software through which users and application programs interact with a database

DBMS
DBMS
DBMS manages data resources like an operating system manages hardware resources

42
42

Data Warehouse

BI / Data Mining Tools

43
43

SQL Example
Product
Maker
Model
Type
Printer
PrinterModel
Color
Type
Price
PC
PCModel
Speed
RAM
HD
CD
Price
Laptop
LaptopModel
Speed
RAM
HD
Screen
Price

Primary Key
and
Foreign Key

44

45

46

47

48

The SELECT Statement
Used for queries on single or multiple tables
Clauses of the SELECT statement:
SELECT – List the columns (and expressions) that should be returned from the query
FROM – Indicate the table(s) or view(s) from which data will be obtained
WHERE – Indicate the conditions under which a row will be included in the result
Optional clauses:
GROUP BY – Indicate categorization of results
HAVING – Indicate the conditions under which a category (group) will be included
ORDER BY – Sorts the result according to specified criteria

49

SQL Query
SELECT FROM

;
SELECT printermodel, color FROM printer;
SELECT FROM

WHERE ;
SELECT printermodel, color FROM printer WHERE price<300; Printer Table 50 Aggregation Operators SUM SELECT SUM(price) FROM PC; AVG SELECT AVG(price) FROM PC WHERE speed>800;
MIN
SELECT MIN(price) FROM PC where ram=256;
MAX
SELECT MAX(price) FROM PC WHERE cd=‘32x’;
COUNT
SELECT COUNT(model) FROM PC;
Keyword DISTINCT (not an aggregation operator)
SELECT DISTINCT type FROM printer;

51

List the model and speed of PCs with price<2000. How many laptops are there with screen size>11.
What is average price of laptops with ram=20.
List all attributes of all color printers
Practice

52

Practice
Book(ISBN, Title, Publisher ID, Author, Cost, price)
 Publisher(Publisher ID, Name, Location)
 
List the publishers and their location.
List all book titles from publisher with ID = 11
How many books exist in the store. (Assuming each book has one entry in the book table)
What is the total cost of the books?
List all distinct book titles
What is the expected profit per book for books published by Publisher ID 222?

Print the speed and price of PCs that cost less than $2000
A: Select speed, price from printer where price < 2000 B: Select speed, price from laptop where price < 2000 C: Select speed from PC where price < 2000 D: Select speed, price from product where price < 2000 E: None of the above 54 Print the price of the cheapest laptop A: Select price from printer B: Select min(price) from pc C: Select min(price) from laptop D: Select cheapest(price) from laptop E: None of the above 55 Online help for learning SQL Tutorials: http://sqlzoo.net/wiki/SQL_Tutorial Practice with tables that are already populated with data: http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all Joins - Queries From Multiple Tables Some queries require combining information from two or more tables. Example: I want the Model #, Manufacturer and Speed of all PCs. ‘maker’ is in the ‘product’ table, but ‘speed’ is in the ‘pc’ table. Example: SELECT product.model, product.maker, pc.speed FROM product, pc WHERE product.model=pc.pcmodel; 57 Cartesian Product This helps to understand what a query from two tables does. Set theory concept - the Cartesian product of 2 sets: R and S is a set of pairs formed by choosing the an element from R and another from S. Example: R={a,b,c}, S={b,e} R X S ={ a.b, a.e, b.b, b.e, c.b, c.e } 58 Cartesian Product Example SELECT * FROM UCI_Students, Football_Players; SELECT UCI_Students.SSN, Football_players.SSN FROM UCI_Students, Football_Players; How can we get names of UCI students who also play football? UCI_Students Football_Players 59 © Prof. V Choudhary, September 18 List the model #, price of laptops made by maker ‘C’. List the model, type and price of color printers from maker ‘G’ List model, speed and price for PCs and Laptops that have the same price. (Do not JOIN on model) Click to edit Master text styles Second level Third level Fourth level Fifth level 60 Practice Book(ISBN, Title, Publisher ID, Author, Cost, price)  Publisher(Publisher ID, Name, Location)   List all books by the publisher with name 'Wiley and Sons' List all book titles and publisher names List the ISBN and the name of publisher where the title of the book is the same as the location of the publisher. © Prof. V Choudhary, September 18 © Prof. V Choudhary, September 18 Practice 2 Student(Student_ID, LastName, FirstName, Phone, Street, City, Zip) Registration(Student_ID, Course_Number, Term, Reg_date, Score) Course(Number, Term, Name, Description, Room_Number, Bldg_Name, Faculty_ID) Faculty(Faculty_ID, Last_Name, First_Name, phone, Office_Room, Office_Bldg) Foreign Keys in Bold 62 © Prof. V Choudhary, September 18 Next Session SQL Continued 63 Tid Refund Marital Status Taxable Income Cheat 1 Yes Single 125K No 2 No Married 100K No 3 No Single 70K No 4 Yes Married 120K No 5 No Divorced 95K Yes 6 No Married 60K No 7 Yes Divorced 220K No 8 No Single 85K Yes 9 No Married 75K No 10 No Single 90K Yes 10 Refund Marital Status Taxable Income Cheat No Single 75K ? Yes Married 50K ? No Married 150K ? Yes Divorced 90K ? No Single 40K ? No Married 80K ? 10 Tid Refund Marital Status Taxable Income Cheat 1 Yes Single 125K No 2 No Married 100K No 3 No Single 70K No 4 Yes Married 120K No 5 No Divorced 95K Yes 6 No Married 60K No 7 Yes Divorced 220K No 8 No Single 85K Yes 9 No Married 75K No 10 No Single 90K Yes 10 Refund Marital Status Taxable Income Cheat No Single 75K ? Yes Married 50K ? No Married 150K ? Yes Divorced 90K ? No Single 40K ? No Married 80K ? 10 Tid Refund Marital Status Taxable Income Cheat 1 Yes Single 125K No 2 No Married 100K No 3 No Single 70K No 4 Yes Married 120K No 5 No Divorced 95K Yes 6 No Married 60K No 7 Yes Divorced 220K No 8 No Single 85K Yes 9 No Married 75K No 10 No Single 90K Yes 10 Tid Refund Marital Status Taxable Income Cheat 1 Yes Single 125K No 2 No Married 100K No 3 No Single 70K No 4 Yes Married 120K No 5 No Divorced 95K Yes 6 No Married 60K No 7 Yes Divorced 220K No 8 No Single 85K Yes 9 No Married 75K No 10 No Single 90K Yes 10 Workers at Caterpillar Aurora Factory Sample data for table PC PCmodelspeedramhdcdprice 1001133161.66x1595 1002120161.66x1399 1003166242.56x1899 1004166322.58x1999 10051661628x1999 1006200323.18x2099 1007200323.28x2349 10081803228x3699 1009200322.58x2599 1010160161.28x1495 db1 70-451, Database Example PRODUCT(maker, model, type) PC(model, speed,ram, hd, cd, price) LAPTOP(model,speed,ram,hd,screen,price) PRINTER(model,color,type,price) Sample data for table PC Sample data for PRODUCT PCmodel speed ram hd cd price maker model type 1001 133 16 1.6 6x 1595 A 1001 pc 1002 120 16 1.6 6x 1399 A 1002 pc 1003 166 24 2.5 6x 1899 A 1003 pc 1004 166 32 2.5 8x 1999 B 1004 pc 1005 166 16 2 8x 1999 B 1006 pc 1006 200 32 3.1 8x 2099 B 3002 printer 1007 200 32 3.2 8x 2349 B 3004 printer 1008 180 32 2 8x 3699 C 1005 pc 1009 200 32 2.5 8x 2599 C 1007 pc 1010 160 16 1.2 8x 1495 D 1008 pc D 1009 pc Sample data for table LAPTOP D 1010 pc model speed ram hd screen price D 2001 laptop 2001 100 20 1.1 9.5 1999 D 2002 laptop 2002 117 12 0.75 11.3 2499 D 2003 laptop 2003 117 32 1 10.4 3599 D 3001 printer 2004 133 16 1.1 11.2 3499 D 3003 printer 2005 133 16 1 11.3 2599 E 2004 laptop 2006 120 8 0.81 12.1 1999 E 2008 laptop 2007 150 16 1.35 12.1 4799 F 2005 laptop 2008 120 16 1.1 12.1 2099 G 2006 laptop G 2007 laptop Sample data for relation PRINTER H 3005 printer model color type price I 3006 printer 3001 ink­jet 275 3002 ink­jet 269 3003 laser 829 3004 laser 879 3005 ink­jet 180 3006 dry 470 1. Create each of the tables using SQL 2. Insert values into each of the tables using SQL 3. Modify the price of PC model 1002 to 1450 4. The cost of RAM used in LAPTOPs has increased, update the price of each laptops that use more than 12 MB RAM by $50 5. Give the model and speed of laptops faster than 120 6. Give the model, price for PCs faster than 20, ram > that 20, and hd > 2.
7. What is the price of the cheapest PC

Sample data for PRODUCT
makermodeltype
A1001pc
A1002pc
A1003pc
B1004pc
B1006pc
B3002printer
B3004printer
C1005pc
C1007pc

D1008pc
D1009pc
D1010pc
D2001laptop
D2002laptop
D2003laptop
D3001printer
D3003printer
E2004laptop
E2008laptop
F2005laptop
G2006laptop
G2007laptop
H3005printer
I3006printer

db1
70-451, Database Example
PRODUCT(maker, model, type)
PC(model, speed,ram, hd, cd, price)
LAPTOP(model,speed,ram,hd,screen,price)
PRINTER(model,color,type,price)
Sample data for table PC Sample data for PRODUCT
model speed ram hd cd price maker model type
1001 133 16 1.6 6x 1595 A 1001 pc
1002 120 16 1.6 6x 1399 A 1002 pc
1003 166 24 2.5 6x 1899 A 1003 pc
1004 166 32 2.5 8x 1999 B 1004 pc
1005 166 16 2 8x 1999 B 1006 pc
1006 200 32 3.1 8x 2099 B 3002 printer
1007 200 32 3.2 8x 2349 B 3004 printer
1008 180 32 2 8x 3699 C 1005 pc
1009 200 32 2.5 8x 2599 C 1007 pc
3001 ink­jet 275
3002 ink­jet 269
3003 laser 829
3004 laser 879
3005 ink­jet 180
3006 dry 470
1. Create each of the tables using SQL
2. Insert values into each of the tables using SQL
3. Modify the price of PC model 1002 to 1450
4. The cost of RAM used in LAPTOPs has increased, update the price of each laptops that use more
than 12 MB RAM by $50
5. Give the model and speed of laptops faster than 120
6. Give the model, price for PCs faster than 20, ram > that 20, and hd > 2.
7. What is the price of the cheapest PC

db1
70-451, Database Example
Sample data for table PC Sample data for PRODUCT
model speed ram hd cd price maker model type
1001 133 16 1.6 6x 1595 A 1001 pc
1002 120 16 1.6 6x 1399 A 1002 pc
1003 166 24 2.5 6x 1899 A 1003 pc
1004 166 32 2.5 8x 1999 B 1004 pc
1005 166 16 2 8x 1999 B 1006 pc
1006 200 32 3.1 8x 2099 B 3002 printer
1007 200 32 3.2 8x 2349 B 3004 printer
1008 180 32 2 8x 3699 C 1005 pc
1009 200 32 2.5 8x 2599 C 1007 pc
1010 160 16 1.2 8x 1495 D 1008 pc
D 1009 pc
Sample data for table LAPTOP D 1010 pc
model speed ram hd screen price D 2001 laptop
2001 100 20 1.1 9.5 1999 D 2002 laptop
2002 117 12 0.75 11.3 2499 D 2003 laptop
2003 117 32 1 10.4 3599 D 3001 printer
2004 133 16 1.1 11.2 3499 D 3003 printer
2005 133 16 1 11.3 2599 E 2004 laptop
2006 120 8 0.81 12.1 1999 E 2008 laptop
2007 150 16 1.35 12.1 4799 F 2005 laptop
2008 120 16 1.1 12.1 2099 G 2006 laptop
G 2007 laptop
Sample data for relation PRINTER H 3005 printer
model color type price I 3006 printer
3001 ink­jet 275
3002 ink­jet 269
3003 laser 829
3004 laser 879
3005 ink­jet 180
3006 dry 470
1. Create each of the tables using SQL
2. Insert values into each of the tables using SQL
3. Modify the price of PC model 1002 to 1450
4. The cost of RAM used in LAPTOPs has increased, update the price of each laptops that use more
than 12 MB RAM by $50
5. Give the model and speed of laptops faster than 120
6. Give the model, price for PCs faster than 20, ram > that 20, and hd > 2.
7. What is the price of the cheapest PC

Sample data for table LAPTOP
LaptopModelspeedramhdscreenprice
2001100201.19.51999
2002117120.7511.32499
200311732110.43599
2004133161.111.23499
200513316111.32599
200612080.8112.11999
2007150161.3512.14799
2008120161.112.12099

db1
70-451, Database Example
PRODUCT(maker, model, type)
PC(model, speed,ram, hd, cd, price)
LAPTOP(model,speed,ram,hd,screen,price)
PRINTER(model,color,type,price)
Sample data for table PC Sample data for PRODUCT
model speed ram hd cd price maker model type
1001 133 16 1.6 6x 1595 A 1001 pc
1002 120 16 1.6 6x 1399 A 1002 pc
1003 166 24 2.5 6x 1899 A 1003 pc
1004 166 32 2.5 8x 1999 B 1004 pc
1005 166 16 2 8x 1999 B 1006 pc
1006 200 32 3.1 8x 2099 B 3002 printer
1007 200 32 3.2 8x 2349 B 3004 printer
1008 180 32 2 8x 3699 C 1005 pc
1009 200 32 2.5 8x 2599 C 1007 pc
1010 160 16 1.2 8x 1495 D 1008 pc
D 1009 pc
Sample data for table LAPTOP D 1010 pc
LaptopModel speed ram hd screen price D 2001 laptop
2001 100 20 1.1 9.5 1999 D 2002 laptop
2002 117 12 0.75 11.3 2499 D 2003 laptop
2003 117 32 1 10.4 3599 D 3001 printer
2004 133 16 1.1 11.2 3499 D 3003 printer
2005 133 16 1 11.3 2599 E 2004 laptop
2006 120 8 0.81 12.1 1999 E 2008 laptop
2007 150 16 1.35 12.1 4799 F 2005 laptop
2008 120 16 1.1 12.1 2099 G 2006 laptop
G 2007 laptop
Sample data for relation PRINTER H 3005 printer
model color type price I 3006 printer
3001 ink­jet 275
3002 ink­jet 269
3003 laser 829
3004 laser 879
3005 ink­jet 180
3006 dry 470
1. Create each of the tables using SQL
2. Insert values into each of the tables using SQL
3. Modify the price of PC model 1002 to 1450
4. The cost of RAM used in LAPTOPs has increased, update the price of each laptops that use more
than 12 MB RAM by $50
5. Give the model and speed of laptops faster than 120
6. Give the model, price for PCs faster than 20, ram > that 20, and hd > 2.
7. What is the price of the cheapest PC

Sample data for table PRINTER
PrinterModelcolortypeprice
3001TRUEink­jet275
3002TRUEink­jet269
3003FALSElaser829
3004FALSElaser879
3005FALSEink­jet180
3006TRUEdry470

db1
70-451, Database Example
PRODUCT(maker, model, type)
PC(model, speed,ram, hd, cd, price)
LAPTOP(model,speed,ram,hd,screen,price)
PRINTER(model,color,type,price)
Sample data for table PC Sample data for PRODUCT
model speed ram hd cd price maker model type
1001 133 16 1.6 6x 1595 A 1001 pc
1002 120 16 1.6 6x 1399 A 1002 pc
1003 166 24 2.5 6x 1899 A 1003 pc
1004 166 32 2.5 8x 1999 B 1004 pc
1005 166 16 2 8x 1999 B 1006 pc
1006 200 32 3.1 8x 2099 B 3002 printer
1007 200 32 3.2 8x 2349 B 3004 printer
1008 180 32 2 8x 3699 C 1005 pc
1009 200 32 2.5 8x 2599 C 1007 pc
1010 160 16 1.2 8x 1495 D 1008 pc
D 1009 pc
Sample data for table LAPTOP D 1010 pc
model speed ram hd screen price D 2001 laptop
2001 100 20 1.1 9.5 1999 D 2002 laptop
2002 117 12 0.75 11.3 2499 D 2003 laptop
2003 117 32 1 10.4 3599 D 3001 printer
2004 133 16 1.1 11.2 3499 D 3003 printer
2005 133 16 1 11.3 2599 E 2004 laptop
2006 120 8 0.81 12.1 1999 E 2008 laptop
2007 150 16 1.35 12.1 4799 F 2005 laptop
2008 120 16 1.1 12.1 2099 G 2006 laptop
G 2007 laptop
Sample data for table PRINTER H 3005 printer
PrinterModel color type price I 3006 printer
3001 ink­jet 275
3002 ink­jet 269
3003 laser 829
3004 laser 879
3005 ink­jet 180
3006 dry 470
1. Create each of the tables using SQL
2. Insert values into each of the tables using SQL
3. Modify the price of PC model 1002 to 1450
4. The cost of RAM used in LAPTOPs has increased, update the price of each laptops that use more
than 12 MB RAM by $50
5. Give the model and speed of laptops faster than 120
6. Give the model, price for PCs faster than 20, ram > that 20, and hd > 2.
7. What is the price of the cheapest PC

printermodelcolortypeprice
3004FALSElaser879
3005FALSEink­jet180
3006TRUEdry470

Sheet1
printermodel color type price
3004 laser 879
3005 ink­jet 180
3006 dry 470

PRODUCT(maker, model, type)
PC(PCmodel, speed,ram, hd, cd, price)
LAPTOP(Laptopmodel,speed,ram,hd,screen,price)
PRINTER(Printermodel,color,type,price)

PRODUCT(maker, model, type)

PC(PCmodel, speed,ram, hd, cd, price)

LAPTOP(Laptopmodel,speed,ram,hd,screen,price)

PRINTER(Printermodel,color,type,price)

SSNL NameF Name
000-00-0001DoeJohn
000-00-0002DoeJason
000-00-0003SmithJack

SSNTeam
000-00-0001Chargers
111-11-1112AntEaters
000-00-000349ers

Sheet1
SSN L Name F Name
000-00-0001 Doe John
000-00-0002 Doe Jason
000-00-0003 Smith Jack

Sheet1
SSN Team
000-00-0001 Chargers
111-11-1112 AntEaters
000-00-0003 49ers

PRODUCT(maker, model, type)

PC(PCmodel, speed,ram, hd, cd, price)

LAPTOP(Laptopmodel,speed,ram,hd,screen,price)

PRINTER(Printermodel,color,type,price)

/docProps/thumbnail.jpeg