Scribd
Upload
6 views7 pages

Employee and Product Data Overview

The document contains data from multiple tables including customer, product, price, sales, employee and department details. It includes fields like customer name, ID, product name, price, sales target and achievement, employee ID, name, salary, department etc. The data seems to be from different databases or sources and is being cleaned, standardized or transformed in the document.

Uploaded by

omkardeshmukhraje
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
6 views7 pages

Employee and Product Data Overview

The document contains data from multiple tables including customer, product, price, sales, employee and department details. It includes fields like customer name, ID, product name, price, sales target and achievement, employee ID, name, salary, department etc. The data seems to be from different databases or sources and is being cleaned, standardized or transformed in the document.

Uploaded by

omkardeshmukhraje
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Cust Cust_Prod

ID Nm No Name Prod
101 Faith 108 Faith Planet M
Null Felicity Null Felicity Planet M
110 Fiona 101 Jan DigiWorld
103 Emma 103 Fisher DigiWorld
104 Emma 104 Emma Planet M
Null Faith Null Faith Planet M
102 Felicity 101 Faith DigiWorld
105 Fiona 105 Cornish DigiWorld
104 Emma 104 Null DigiWorld
Null Emma Null Emma DigiWorld
Null Null 101 Faith JanBus
Null Null U-Truck
TAB1 TAB1
ID NM ID NM
1V 1A
1B 1B
3V 2V
3V 3V
0V 0V
null B null B
2V 2V
null A null B
1A 1A
null Null null null
Curr_Prod_Price
Product_Ty
Prod_Price
pe
505 713266
60 80000
666 628910
303 150705
202 536129
202 90000
303 9111
505 14705
404 11445
808 14877
707 9923
909 13513
9080 Null
190 Null
180 Null
280 null
Salesman_Target Salesman_Sale
Name Target Name Sale
Claire 10000 Claire 2000
Tom 6000 Claire 4000
Amt 5000 Claire 2100
John 9000 John 3000
John 3400
Expected Result John 2010
Salesman_Remaining_Tar
Tom 2300
get
Remaing
Name Tom 150
target
Claire 1900 Tom 300
Tom 3250 Amt 200
Amt xxxxxxx
John xxxxxxx
Employee Details Department_Details
Emp_Id First_Name Last_Name Salary Dept_id Accounting and Finance Department_Id
121 Diana Campbell 5900 10 Production 10
122 Diane Carr 7800 20 Research and Development 20
123 Donna Chapman 9600 30 Purchasing 30
124 Dorothy Churchill 7800 20 Marketing 40
125 Elizabeth Clark 4500 20 Human Resource Management 50
126 Ella Clarkson 9600 60 Accounting and Finance 60
127 Emily Coleman 12300 40 Information Technology 70
128 Emma Cornish 56200 20
129 Faith Davidson 89000 10
130 Felicity Davies 9600 60
131 Fiona Dickens 4500 20
132 Gabrielle Dowd 12300 30
Employee Details
Emp_Id First_Name Last_Name Job_ID Salary Dept_id
121 Diana Campbell executive 5900 10
122 Di,ane Carr executive 7800 20
123 Donna Chapman manager 9600 30
124 Dorothy Churchill supervisor 7800 20
125 Elizabeth Clark housekeeper 4500 20
126 Ella Clarkson supervisor 9600 60
127 Emily Coleman programmer 12300 40
128 Emma Cornish manager 56200 20
129 Faith Davidson director 89000 10
130 Felicity Davies supervisor 9600 60
131 Fiona Dickens housekeeper 4500 20
132 Gabrielle Dowd supervisor 12300 30
Source
Department_Details
Department_Name Department_Id
Production 10_Prod
Research and Development 20_RD
Purchasing 30_Purchase
Marketing 40_Marketing
Human Resource Management 50_HR
Accounting and Finance 60_Acc_Fin
Information Technology 70_IT
Sales 80_Sales

Expected Output
Department_Details
Department_Name Department_Id
Production Ten_Prod
Research and Development Twenty_RD
Purchasing Thirty_Purchase
Marketing Fourty_Marketing
Human Resource Management Fifty_HR
Accounting and Finance Sixty_Acc_Fin
Information Technology Seventy_IT
Sales Eighty_Sales

You might also like