Ceara_Stewart_Assignment_1

docx

School

Syracuse University *

*We aren’t endorsed by this school

Course

722

Subject

History

Date

Oct 30, 2023

Type

docx

Pages

6

Uploaded by EarlTankHamster31

Report
IST772 Ceara Stewart Net ID#: 634895932 10/14/2023 Assignment 1: Data Profiling Table Type Row Count PK(s) Used One Row Is Employees Master Data 9 EmployeeID An employee EmployeeTerritorie s Business Process 49 EmployeeID, TerritoryID An employee assigned to a territory Customers Master Data 91 CustomerID The address of a customer Suppliers Master Data 29 SupplierID The company name of a supplier Products Master Data 77 ProductID, SupplierID, Category ID The units of a product in stock Shipments (of Orders) Business Process 3 ShipperID The company name of a shipper Details (of an Order) Business Process 2,155 OrderID, ProductID The unit price of a product ordered
IST772 Ceara Stewart Net ID#: 634895932 10/14/2023 1. List the customer contact names and titles sorted by company name.
IST772 Ceara Stewart Net ID#: 634895932 10/14/2023 2. Factoring in discounts, what is total amount of product sold?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
IST772 Ceara Stewart Net ID#: 634895932 10/14/2023 3. Provide a list of product category names with counts of products in each category.
IST772 Ceara Stewart Net ID#: 634895932 10/14/2023 4. Select a specific customer, and display that customer’s orders with total amount of product sold for each order.
IST772 Ceara Stewart Net ID#: 634895932 10/14/2023 5. Select a specific employee and each order, how it was shipped (shipvia), the company who shipped it, and the total number of days elapsed from order date to shipped date.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Browse Popular Homework Q&A

Q: A small asteroid that has a mass of 100 kg is moving at 200 m/s when it is 1660 km above the Moon.…
Q: A growing deer population increases by 4 animals per year. If the current population is 41 animals,…
Q: The house numbers of two adjacent homes are two consecutive even numbers. If their sum is 358, find…
Q: During which stage of organization development does a change agent implement a specific plan for…
Q: A factory worker pushes a 24.0 kg crate a distance of 8.0 m along a level floor at constant velocity…
Q: 2 What is the least possible degree of the polynomial graphed above?
Q: What events influenced her life in the time span between 1909 and 1927 and how did they affect her?
Q: The following is passive transport of a solute: O a Diffusion O b. Osmosis Oc. Endocytosis Od. A and…
Q: ) Construct a 90 percent confidence interval for the proportion of all depositors who ask for cash…
Q: What are some Examples of how American political parties promote and undermine democratic…
Q: a hydrogen atom in an excited state emits a photon of frequency v = 3.199 x 10^15 s^-1. if the…
Q: Write a function build_csv_string(data) that takes in a list data. data will be a list of lists,…
Q: How to create VPN to connect to branch office of the same office? What would be the preliminary…
Q: 5) How many grams are there in 7.50 x 1023 molecules of H₂SO4? 23 "2002g/mo! 7.50 X 102³ molecules…
Q: Which of the following terms or phrases describe the OIL DROP experiment? charged plates discovered…
Q: 3. The table below mmHg for a sa ic, x Diastolic, y 5 89 B 85 5 83
Q: hat is the slope of the given line? (Be sure to simplify) y -10 -9 -8 -6 i 10 9 13 co + ci 6 to -9…
Q: sin0 = 响 √√2 2
Q: You may need to use the appropriate appendix table or technology to answer this question. Minnesota…
Q: 12) How many grams are there in 1.00 x 1024 molecules of BC13? B1X10.81 (1 3 X 35,45 10.81 g/m²!…
Q: ♬ table to approximate each and everyone of these probabilities. a. P(F(8,12) ≥ 2.85) = 0.049921 b.…
Q: the intersection of Grand and 17th 926d0 The SAPD is chasing after several suspects in a burglary…