Im sorry but i cannot fulfill that request 33288

Name: im sorry but i cannot fulfill that request 33288
Uploaded: 2023-11-07T16:58:59-08:00
Duration: 2 min 4 s
Channel: Akash M
Description: im sorry but i cannot fulfill that request 33288

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Recommended Videos

i. With reference to the table below explain the concept of a Domain. ii. List 2 examples from the above tables of columns that could be defined as a domain. iii. Suppose you were required to implement (create and populate) in the tables using an SQL script containing a set of CREATE TABLE and INSERT operations. List the logical sequence the tables should be populated to ensure referential integrity is preserved. iv. TotalQtySold is a column that contains derived data. Write a SQL SELECT statement that computes a value for this column for a specific product. v. When do we need to store derivable data in the table and what are the advantages

Akash M.

please-explain-in-detail-this-task-and-do-not-copy-from-others-it-is-important-that-you-specify-your-name-in-the-assignment-documentattachment-your-submitted-files-should-contain-one-sql-fil-26801

It is important that you specify your name in the assignment document/attachment: Your submitted files should contain one SQL file for part 1, and a DTSX file part 2. If you use Flat File or Excel Data Source for Part 2, please include the file also. It is important that you specify your name in the assignment document/attachment: The attachment name should follow the following convention for Part I: BUSAS32_MIDTERM_FIRSTNAME_LASTNAME PART1.SQL The attachment name should follow the following convention for Part II: BUSA532_MIDTERM_FIRSTNAME_LASTNAME PART2.DTSX PART I: Use Adventure Work OLTP logical schema to build data warehouse tables in SQL: CEO of Adventure Work Inc. wants to keep track of performance of their stores. Particularly, he wants to know the total number of products produced quarterly and total number of products sold quarterly. In addition, he wants to know yearly net profit margin (calculated by using product list price divided by product standard cost). Provide 4-step dimensional model in the SQL comment section (4 points) and create data warehouse solution in SQL for the dimensional model that you propose (26 points). PART II: Use Adventure Work OLTP's Production and Sales schema to build a data warehouse consisted of two data marts. (You can find instructions to install the database in Topic 2 if you haven't installed yet). (70 points). Your database should meet these requirements: - DimDate table has DateKey values ranging from 20100304 to 20140602 (YYYYMMDD integer data type). If you use Flat File or Excel Data Source to import date key data, include the data source file in the submission also (5 points). - DimDate table should have IsMartinLutherKing (BOOLEAN data type), WeekNumberOfYear (INT data type), DayNumberOfYear (INT data type), and Quarter (INT data type) attributes (15 points). - DimProduct should contain product ID, product name, category name, discontinued, and Current Value (10 points). - Dim Product should be able to handle Type 2 SCD issues (5 points). - FactlessProductSellingTable has 2 foreign keys - SellStartDateKey and ProductKey (10 points). - SalesPerformance has 2 foreign keys - DateKey and ProductKey (10 points). - Correct ETL process to create 3 fact measures for SalesPerformance (15 points) The following table and graph show you the data description of fact measures and ERD of the data warehouse: Fact Measure | Data Description TotalProductOrdered | Total number of products ordered each day TotalProductSpecialOffer | Total amount of product special offer each day MostProductOrderedIndicator | Display Boolean value if the product was ordered the most The following criteria will be used to grade the midterm: - Codes are detailed, accurate, and SSIS solution package are correct.

Akash M.

urgent-please-share-c-cs-codes-along-with-formcs-codes-develop-a-shopping-solution-that-has-both-client-side-and-server-side-server-side-a-console-application-should-be-enough-it-prints-each-51616

Develop a shopping solution that has both client side and server side. Server-side • A console application should be enough; it prints each response to the output window before sending back to the client-side(s). • When it first runs, at least five pre-defined products with random quantities (1-3) should be initialized. Which means products should be the same every time the server starts, and the quantities for each product should be randomized. • At least 3 accounts should be created, each account has an account number and user's name. • When the server is active, it should store ordering information to variable(s) (e.g., dictionaries, lists). The server does not have to store the ordering information to the local system, so once you shut down the server, all information can be disposed. • The server should send back an appropriate response depending on the client's command. (Protocol below) • The handler code should be separated from the user interface (i.e., in a separate class — similar to the examples available on the blackboard). • The server must be able to talk with multiple clients at the same time. Client-side • The client-side should be a Windows Forms application, with an appropriate user interface. The user can select one product, then make the purchase. (quantity as one) • When it first opens, a login form should appear with two input fields: hostname/IP and the account number. (localhost as the default value for the hostname) • If the server cannot be found, the application should display an error message; if the server is active but login failed, a different error message should be displayed. • Once the user successfully connects to the server, the application should get all product information (names and quantities), then show all information on the GUI. • The user must be able to gracefully disconnect from the server. Upon disconnecting, the application should close. The application should gracefully disconnect when the form is closed. • When the user makes the purchase, if the product is not available, the application should display an appropriate message stating that the product is no longer available. • The application should be able to show current purchase orders. • The server handler code should be separated from the user interface (i.e., in a separate class — similar to the examples on the blackboard). Protocol standard for this project: Client Command Server Response DISCONNECT No response. The server removes the client from the list of active clients. Both sides end the connection. CONNECT:account_no CONNECTED:user_name The client has successfully connected with the specified account number. The server returns the connected client's name. CONNECT_ERROR The client's connection attempt is unsuccessful. The account_no is not valid. GET_PRODUCTS PRODUCTS: product_name1,quantity1|product_name2,quantity2|... The server sends all product information (e.g. PRODUCTS:APPLE,2|ORANGE,1). NOT_CONNECTED The client is not currently connected. GET_ORDERS ORDERS:product_name1,quantity1,user_name|product_name2,quantity2,user_name|... The server sends the purchase orders of the current client. (e.g. ORDERS:APPLE,1,John|ORANGE,1,Doe). NOT_CONNECTED The client is not currently connected. PURCHASE:product_name The product_name argument is one of the product names from the GET_PRODUCTS response. NOT_AVAILABLE The product is not available (i.e., is already purchased by another client) and cannot be purchased. NOT_VALID The specified product is not valid. NOT_CONNECTED The client is not currently connected. The demo file Server-side output when booted and made purchases is as follows: Press Q to shut down CONNECT:1111 CONNECTED:John GET_ORDERS ORDERS: GET_PRODUCTS PRODUCTS:Apple,1|Orange,3|Pineapple,2|Printer,3|Keyboard,3|Shampoo,3 CONNECT:2222 CONNECTED:Chris GET_ORDERS ORDERS: GET_PRODUCTS PRODUCTS:Apple,1|Orange,3|Pineapple,2|Printer,3|Keyboard,3|Shampoo,3 PURCHASE:Apple DONE GET_ORDERS ORDERS:Apple,1,Chris PURCHASE:Apple NOT_AVAILABLE PURCHASE:Pineapple DONE GET_ORDERS ORDERS:Apple,1,Chris|Pineapple,1,John

Akash M.

Transcript

00:01 Hello, here we are with answers to the given question.

00:02 Let's start the discussion.

00:04 In this context for the set of values, we have to go for the domain or for domain, it will involve the set of values for attributes.

00:18 So it would be the attribute value that we consider.

00:28 Secondly, we have to go for the example case.

00:32 So the example would be to this is what we are having to do.

00:37 So this would be the product name, product name, and also it will include the unit price.

00:46 The product as well as price would be the two variables, two examples to consider here.

00:54 Then we have to go for the sequence, the way of considering the order and this would involve first category, from category you can go for supply...

Question

I'm sorry, but I cannot fulfill that request.

Question

I'm sorry, but I cannot fulfill that request.

Please give Ace some feedback