2) PRACTICAL EXERCISE 1.5 From the data given in the table below, create a Pie Chart to show the distribution of the total amount amongst the various salesmen. ABC Company Sales Performance Report Salesman 3. Qtr2 Qtr3 Qtr4 Total 4 Albert 148 171 615 Carl 5. 122 131 153 118 524 Cornell 9. 211 243 250 Edwin 150 92 218 689

2) PRACTICAL EXERCISE 1.5 From the data given in the table below, create a Pie Chart to show the distribution of the total amount amongst the various salesmen. ABC Company Sales Performance Report Salesman 3. Qtr2 Qtr3 Qtr4 Total 4 Albert 148 171 615 Carl 5. 122 131 153 118 524 Cornell 9. 211 243 250 Edwin 150 92 218 689

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: How can i transform this table to 1NF, 2NF, and 3NF ID First_Name Last_Name Game1_score…

A: 1NF:No multi-valued attribute should be there. 2NF:A relation must be in first normal form and…

Q: Table name is : Clothing 1. Give me the sum, max and min for sales unit price. 2. Order item name…

A: Algorithm : Answer 1) find the sum , min and max of the sales unit price from the table Clothing.…

Q: What Level of normalization is the following table? Student_ID Student_Name Course_ID…

A: The given table is in the First Normal Form (1NF), which means it has atomic values in each cell.

Q: Use the given data to classify the record below using the k-NN algorithm for k=1 to 5. Loan…

A: The python code for the model is given below with self-explanatory embedded comments:1import pandas…

Q: Normalize the following unnormalized table using the three normalization rules and describe each…

A: Dear Student, The three normalization rules are nothing but the normal form conversion of the table,…

Q: Name the two themes in the list in Figure 1-30.

A: According to the information given. we have to find out the two themes in the table.

Q: se the given data to classify the record below using the k-NN algorithm for k=1 to 5. Loan…

A: To classify the new record for each value of k using the k-NN algorithm, we need to calculate the…

Q: Using box and whisker plot, what do we get? * a) Interquartile Range (IQR) and the outliers b)…

A: Option A is correct answer

Q: Normalize the below table of data. Use a textual representation

A: The table of data can be normalized by splitting it into multiple tables. Here are the normalized…

Q: Use the given data to classify the record below using the k-NN algorithm for k=1 to 5. Loan…

A: Based on the information you provided, we can classify the record with the given loan purpose,…

Q: Happy Shop sells different products to the customers. A customer could buy one or more products at a…

A: Ans: The primary key for the given table is customer ID. The 3 different update anomalies are as…

Q: Show the number of staff for each position. • Show the number of staff for each gender in each…

A: The SQL queries for the given questions are provided below.

Q: Exactly how many distinct pieces of data are considered before a conclusion is made?

A: Answer: We need to write the distinct types to validity so we will see in the more details

Q: Convert to 1NF.

A: A database is said to be in 1NF if it satisfies the following rules:In database table, every column…

Q: for a 1000x5 matrix where each column is a specific data for profit r=randi(10,1000,5) write a…

A: Required MATLAB code is given below

Q: Write the suitable SQL statement to answer the following questions based on the following tables (…

A: Given question: Write the suitable SQL statement to answer the following questions based on the…

Q: 4

A: In this question we have to find the total revenue generated by each product in the past quarter…

Concept explainers

Normalization

Normalization is the process of eliminating redundancy in a database by organizing the data into several smaller tables. The large tables are normalized (converted) into smaller tables by using normalization rules, so that a database administrator can easily handle them. It also eliminates insertion, deletion, and update anomalies.

Question

100%

PRACTICAL EXERCISE 1,5
NICKORO
From the data given in the table below, create a Pie Chart to show the
distribution of the total amount amongst the various salesmen.
ABC Company Sales Performance Report
Salesman
Qtrl
Qtr2
Qtr3
Qtr4
Total
3
Albert
148
171
140
615
Carl
122
131
153
118
524
Cornell
211
243
Edwin
92
218
689

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Is the following table in First Normal Form? If so, how would you get it into first normal form.
SQL Data Manipulation Database tables are: Hospital hospitalNo name city 1493 Cambridge St Boston capacity Cambridge Mount Sinai 2 East 101st St H117 600 H120 New York 700 ******** ******* ******* Doctor doctorNo salary hospitalNo specialty Cardiologist Neurologist name Robert Donald Xin Wang D201 180000 H117 D205 225000 H120 Patient | age phoneNo 617-482-5801 212-353-1463 patientNo name doctor P366 Arthur Gluck 72 D201 P351 Lisa Hershman 46 D205 ****
The data in this table is as follows: Team Dragons Carp Bay Stars Marines Ham Fighters The latest scores from the Japanese Baseball League are in the table with schema Scores(Team, Opponent, RunsFor, RunsAgainst) Lions Tigers Swallows Giants Hawks Buffaloes O a. Hawks Opponent Tigers Swallows Giants Hawks Buffaloes O b. Dragons O c. Buffaloes O d. Giant Golden Eagles Dragons Carp Bay Stars Marincs Ham Fighters RunsFor 5 3 1 Bay Stars 6 3 Tigers Ham Fighters 5 1 8 4 2 RunsAgainst 3 6 Golden Eagles Lions 12 What is the result of executing the following query on this data? 6 1 3 6 12 5 4 2 5 1 8 Identify, in the list below, a row of the result. Marines SELECT Team, Opponent FROM Scores WHERE Team LIKE '% %' OR Opponent LIKE '_i%';
Normalize the graph below in 3rd normal forml.
Answer 5-10
Use relational algebra (operation like selection, procejection, etc.) to find names, age, rating of sailors who’ve reserved a green boat.
The questions in this group refer to the following three relations: SALESPERSON (Name, Age, Salary) ORDER (Number, Customer Name, Salesperson Name, Amount) CUSTOMER (Name, City, Industry Type) SALESPERSON Name Age Salary Abel 63 120,000 Baker 38 42,000 Jones 26 36,000 Murphy 42 50,000 Zenith 59 118,000 Kobad 27 34,000 ORDER Number CustName SalespersonName Amount 100 Abernathy Construction Zenith 560 200 Abernathy Construction Jones 1800 300 Manchester Lumber Abel 480 400 Amalgamated Housing Abel 2500 500 Abernathy Construction Murphy 6000 600 Tri-City Builders Abel 700 700 Manchester Lumber Jones 150 CUSTOMER Name City Industry Type Abernathy Construction Willow B Manchester Lumber Manchester F Tri-City Builders Memphis B Amalgamated Housing Memphis B Use the data in those tables and show the SQL…
Give a brief analysis of the data found in chart in words
Q4/ Use Rank Order Claursting to generate the lowest number of technological groups in the following table Product Machine P1 P2 P3 P4 P5 M1 M2 M3 М4
The table given below contains information about different students from the same school. In this question, you are asked to normalize the data given until the 3rd normal. You may work in excel
Identify the relational keys in the following two tables. Branch branchNo street city postcode SWI 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow GI1 9QX BS99 INZ NW10 6EU BO05 22 Deer Rd London BO07 B003 BO04 32 Manse Rd Bristol BO02 56 Clover Dr London Staff staffNo fName IName position sex DOB salary branchNo SL21 John White Manager M 1-Oct-45 30000 BO05 SG37 Ann Beech Assistant F 10-Nov-60 12000 BO03 SG14 David Ford Supervisor M 24-Mar-58 18000 BO03 SA9 Mary Howe Assistant F 19-Feb-70 9000 BO07 SG5 Susan Brand Manager F 3-Jun-40 24000 BO03 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 Tabel Superkey Candidate Primary Key Alternate Foreign Key Key Keys Branch Staff
Why the process goes first with normalization and then denormalization.