2. (LO 2.3) Northwind Traders is a fictitious specialty foods company created by Microsoft, which has also created a fictitious database for the company. The Northwind database includes several tables, including Products, Suppliers, and Categories. Pictured below is a subset of the Products table, which details all the products that Northwind Traders sells. ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued 10 boxes x 20 Chai Chang Aniseed Syrup Chef Anton's Cajun Seasoning 1 1 1 2 1 bags 24-12 oz 1 bottles 12-550 ml 2 bottles 2 48-6 oz jars 18 19 10 22 39 17 13 53 0 40 70 0 10 25 25 0 b. If you averaged everything in the SupplierID field, would you obtain a useful number? Explain. c. If you averaged UnitPrice, would you obtain a useful number? Explain. 0 0 0 0 a. Review each variable in the Products table. Which would be classified as numerical data-that is, data that would be interesting to add or average?

2. (LO 2.3) Northwind Traders is a fictitious specialty foods company created by Microsoft, which has also created a fictitious database for the company. The Northwind database includes several tables, including Products, Suppliers, and Categories. Pictured below is a subset of the Products table, which details all the products that Northwind Traders sells. ProductName SupplierID CategoryID QuantityPerUnit UnitPrice UnitsInStock UnitsOnOrder ReorderLevel Discontinued 10 boxes x 20 Chai Chang Aniseed Syrup Chef Anton's Cajun Seasoning 1 1 1 2 1 bags 24-12 oz 1 bottles 12-550 ml 2 bottles 2 48-6 oz jars 18 19 10 22 39 17 13 53 0 40 70 0 10 25 25 0 b. If you averaged everything in the SupplierID field, would you obtain a useful number? Explain. c. If you averaged UnitPrice, would you obtain a useful number? Explain. 0 0 0 0 a. Review each variable in the Products table. Which would be classified as numerical data-that is, data that would be interesting to add or average?

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: C. Assume the following sample of data : Тeam TeamID 1001 | 1002 1003 | 1004 City Win TeamName…

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: Given the default schema of a database: Orders 123 Orderld OrderDate ADC OrderNumber 123 Customerld…

A: Please refer to the following step for the complete solution to problem above.

Q: Complete the entries: 1. Set methods are commonly called v methods. 2. Set methods change v fields.…

A: As we know data of an object must be kept private. However, if any data member is declared private,…

Q: Inventory Database: Customers(custid, custName, address, phone, creditLimit) Orders (orderNo,…

A: After understanding information above To display the customer ID and the number of orders for each…

Q: List the player ID and player name of all the players older than 25 years old (included) and playing…

A: We are going to display player_id an player_name who are above than 25 years and their position is…

Q: CREATE TABLE DONORS ( donor_id INT NOT NULL, donor_name varchar(255) NOT NULL, donor_age int,…

A: INSERT INTO DONORS VALUES(1,'SAI',20); INSERT INTO DONORS VALUES(2,'PAVAN',21); INSERT INTO DONORS…

Q: Course • Courseld CourseCode CourseName Capacity Instructorld 3815 ENGL862 American Literature 75 2…

A: The question requires us to write a SQL query that will return the details of instructors who teach…

Q: # Question 1 #Using the World database, in the city table, insert a new city for the Tasmania…

A: What is SQL: SQL is a language for interacting with databases. SQL is the standard language for…

Q: The following three tables make up a simple reservation system for a small campground. The database…

A: ER Diagram: ER diagram is defined as the interconnection of entities and attributes how they are…

Q: Why is it so important to understand the function of the GROUPING SETS clause?

A: 1. A Database Management system (or DBMS). 2. It is essentially nothing more than a computer-based…

Q: Problem 82 Write a query to display the lowest book cost in the system (Figure P7.82).

A: Aggregate Functions: SQL has some built-in functions and they are called as aggregate functions.…

Q: Task 4: As a part of marketing strategy, the Marketing team continuously conducting an advertising…

A: Actually, database is a used to stores the data.

Q: ask 3: The Car Maintenance team wants to insert and store the following maintenance types to the…

A: The CREATE TABLE statement is used to create a new table in a database. Syntax: CREATE TABLE…

Q: Q4. Problem Statement You are managing a database for a movie production company. The database…

A: To update the ratings of all movies directed by 'Lankesh' to a new rating of 3, you will need to use…

Q: The Save Transaction button depicted in the screen attached is used to save relevant data to the…

A: In this question we have to understand and code for the Java function saveTransaction function with…

Q: . The basic operations that can be performed on relations are a. deletion b. insertion c.…

A: There are three basic operations that can change the states of relations in the data-base: Insert,…

Q: Corporation: id 15 17 20 Company: cid id 1 15 17 15 20 15 2 3 4 5 Assumptions: •id in Company…

A: Delete restrict means if there any specified row exists in the dependent table, then that relation…

Question

100%

2. (LO 2.3) Northwind Traders is a fictitious specialty foods company created by Microsoft, which has also created a fictitious
database for the company. The Northwind database includes several tables, including Products, Suppliers, and Categories.
Pictured below is a subset of the Products table, which details all the products that Northwind Traders sells.
ProductName SupplierID CategoryID QuantityPerUnit UnitPrice Units InStock UnitsOnOrder ReorderLevel Discontinued
10 boxes x 20
Chai
Chang
Aniseed
Syrup
Chef Anton's
Cajun
Seasoning
1
1
1
2
1 bags
24-12 oz
1 bottles
12- 550 ml
2 bottles
2 48-6 oz jars
18
19
10
22
39
17
13
53
0
40
70
10
25
25
0
b. If you averaged everything in the SupplierlD field, would you obtain a useful number? Explain.
c. If you averaged UnitPrice, would you obtain a useful number? Explain.
0
0
0
0
a. Review each variable in the Products table. Which would be classified as numerical data-that is, data that would be
interesting to add or average?

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: Concept of Database:

VIEW

Step 2: Analyze the Nothwind Products Table:

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

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

table not copied
If we implement a queue using an array where we treat the array as if its two ends are "taped together", we call that a linear array. O True False
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…
Child row is a related row where there is a ? Primary key Foreign key Candidate key Composite key
Assume the EMPLOYEE table contains four attributes, ID, DEPT, SALARY and NAME, and has the following rows ID DEPT SALARY NAME 100 SALES 40000 Smith 101 RD 38000 Terry 102 HR 60000 David 103 SALES 58000 Ellie 104 RD 70000 Judy The DEPARTMENT table contains two attributes, DEPTNAME and PHONE, and has the following rows: DEPTNAME PHONE RD 8596001234 SALES 8596005555 HR 8596009876 A.) The EMPLOYEE table needs to enforce the following integrity constraints: • The ID is the primary key. • The DEPT column is a foreign key that references the DEPTNAME in the DEPARTMENT table, so that any value that appears in the DEPT column should also exist in the DEPARTMENT table. • The value for the NAME column can never be null. What should be the statement used to create the EMPLOYEE table, if 1) the table was created as a partitioned table such…
ABC department store keeps information on departments, products, and employees. For each department, the department ID, name and office phone extension are stored. For each employee, the employee ID, and name are stored. A department can have many employees and each employee can be assigned to multiple departments. Each department is managed by one employee. Each department sells many products and each product is sold by only one department. Products can be shoes, clothes, or other miscellaneous. The product ID and price are stored for each product. No additional data is stored for the miscellaneous products. For all shoes, shoe type, shoe color and shoe size are also stored. For all clothes, the season (one of: winter, spring, summer, year-round) is stored. Clothes can be shirts, pants or dresses. For shirts, collar size, sleeve size and type are stored. For pants, waist size, length and type are stored. For dresses, size, and type are stored. Draw the Crow’s foot ERD (including all…