Individual Descriptive

docx

School

University Canada West *

*We aren’t endorsed by this school

Course

650

Subject

Information Systems

Date

Oct 30, 2023

Type

docx

Pages

Uploaded by JudgeIceAntelope23

Answer all Questions on the spaces provided. For all the questions below, provide the code and output. The screenshots MUST include the date/time on your computer/laptop for it to be graded. This assignment should be individual work. Once completed, save the file as a PDF, and submit. ** I agree that the work in this assignment is my own work. I acknowledge that I am expected to exercise the utmost academic integrity in all work submitted for this course. I also acknowledge that I have read the FAQ posted on Moodle and understand the consequences of Plagiarism. ** As a new intern working in a small music company, you have been asked to look into the database and generate monthly reports of items sold in the store. Copy and run the code provided to create the tables for the database. Write simple SQL queries that will display output according to the requirements below. Note: For the script provided: run each table script individually, NOT the entire script at once. 1. Display an output of customer details. The output fields should be displayed in order and exactly as shown here (i.e. with the spaces): Last Name, First Name, City, and Phone #. (1.5 Marks) CREATE TABLE Customers ( Cust_LastName nvarchar(50) NOT NULL, Cust_FirstName nvarchar(50) NULL, Cust_City nvarchar(50) NOT NULL, Cust_Phone nvarchar(30) NOT NULL

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

2. Display an output of the order details. The output fields should be displayed in order and exactly as: Order ID, Quantity Ordered, Order Date, and Date Shipped. (1.5 Marks) SELECT Orders.orderid, OrderDetails.Quantity, Orders.OrderDate, Orders.ShippedDate FROM Orders join OrderDetails on Orders.OrderID=OrderDetails.OrderID

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

3. Display an output of the customers and order details. The output fields should be displayed in order and exactly as: Last Name, First Name, Item ID, Title of Song, Artist, Quantity, and Unit Price. The list should be ordered in descending order based on last name. (4 Marks) To display an output of the customers and order details with the specified fields and order, you would use the following SQL query: SELECT customers.last_name, customers.first_name, orders.item_id, orders.title_of_song, orders.artist, orders.quantity, orders.unit_price FROM customers INNER

JOIN orders ON customers.customer_id = orders.customer_id ORDER BY customers.last_name DESC; The code used for getting the output is: SELECT Customers.custid , Customers.custfirstname , Customers.CustLastName , Items.itemid , Items.title , Items.artist , OrderDetails.quantity , Items.unitprice FROM Customers JOIN Orders ON Customers.CustID = Orders.custid JOIN OrderDetails ON Orders.orderid = OrderDetails.orderid JOIN Items on OrderDetails.ItemID = Items.ItemIDThe code used for getting the output is: 4. Given the output from above, use your statistical skills to calculate the average, median, and mode of the unit price. Show your work. (3 Marks) The average unit price and median from the data are 16.79 and 17.00 respectively and the mode of unit price is 17.95.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version