Get help from the best in academic writing.

Diwan personal essay help Art assignment help

1. Give examples of needs, wants and demands that Diwan’s customers demonstrate, differentiating each of these three concepts Before launch of Diwan, bookstores in Egypt had limited selection of books that’s why book-hungry individual were had two choices to gets their need for reading by purchasing from other country or waiting for annual international book fair to purchase their yearlong book needs. Diwan worked on satisfying customer needs for gaining knowledge and reading by offering them bookstore with wide range of book varieties.

Moreover, Diwan worked to extend their job to satisfy their customer’s wants by creating culture retail experience which offers a lot of activities for children and adults in addition to serve book-hungry populations. Diwan worked on meeting their customers’ demands by offering a lot of services which include extensive selection of books for different categories, multimedia offers like audio books and DVD, in addition every branch has stationary section that offers products from local & international suppliers.

Needs: state of felts deprivation , they include basic physical needs, social needs and individual needs. Ex. Diwan’s customer needs are to improve themselves and to be fulfilled and satisfied culturally and intellectually. Wants: Form that needs take as they are shaped by culture and individual personality Ex. Diwan’s customer wants to have a wider selection of books. they were Hungary for up to date books. and the only way to obtain those kind of books were either travelling or waiting for the annual international book fair. this way was relatively more expensive though.

Demands: Wants backed by buying power Ex. They demanded a book store that can offer a wider selection of books that weren’t possible to reach in Egypt. 2. In details, describe all facets of Diwan’s product offering. Diwan product offering includes the following:- • Extensive selections in Arabic/English/French in different categories such as the arts & history • Multimedia section which offers audio books, DVD, music CDs & PC games for children and adults. • Stationary section that offers products from local & international suppliers.

• Others services such as book binding, children activities, gift wrapping, services for school, event hosting and used books exchanges. • Delivery service. • Loyalty program using loyalty cards which allow customers to accumulate points based on their purchases. • Diwan have its own website in which offers several features such discussion forums and book clubs. Services offered by Diwan include, first, an extensive selection of books in Arabic, English , French and German in many different categories. Secondly, a multimedia section offers audio books ,DVDs , educational CD-ROMs, music CDs , and PC games for both children and adults.

in addition, Diwan offers more than just new multimedia releases; it also offers classics which aren’t easily found in the Egyptian market. Also, Diwan has a stationary section in every branch that offers products from local and international suppliers, artistic calendars, bookmarks, and notebooks. Last but not least , Diwan offers variety of other services such as book binding , children’s activities , corporate gifts and services, gift wrapping, services for schools (including field trips, supplying books for school libraries),event hosting and used book exchanges.

Translating code

You have been hired as the new DB SME for Adventure works and Worldwide Imports and have inherited 2 stored procedures in SQL Server. Your supervisor has asked you to translate the 2 stored procedures in to plain English for non-technical users.
Stored Procedure 1:
USE [AdventureWorks (1)]GO
/****** Object: StoredProcedure [HumanResources].[uspUpdateEmployeeHireInfo] Script Date: 2/24/2022 1:22:48 PM ******/SET ANSI_NULLS ONGO
SET QUOTED_IDENTIFIER ONGO
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo] @BusinessEntityID [int], @JobTitle [nvarchar](50), @HireDate [datetime], @RateChangeDate [datetime], @Rate [money], @PayFrequency [tinyint], @CurrentFlag [dbo].[Flag] WITH EXECUTE AS CALLERASBEGIN SET NOCOUNT ON;
BEGIN TRY BEGIN TRANSACTION;
UPDATE [HumanResources].[Employee] SET [JobTitle] = @JobTitle ,[HireDate] = @HireDate ,[CurrentFlag] = @CurrentFlag WHERE [BusinessEntityID] = @BusinessEntityID;
INSERT INTO [HumanResources].[EmployeePayHistory] ([BusinessEntityID] ,[RateChangeDate] ,[Rate] ,[PayFrequency]) VALUES (@BusinessEntityID, @RateChangeDate, @Rate, @PayFrequency);
COMMIT TRANSACTION; END TRY BEGIN CATCH — Rollback any active or uncommittable transactions before — inserting information in the ErrorLog IF @@TRANCOUNT > 0 BEGIN ROLLBACK TRANSACTION; END
EXECUTE [dbo].[uspLogError]; END CATCH;END;GO
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.’ , @level0type=N’SCHEMA’,@level0name=N’HumanResources’, @level1type=N’PROCEDURE’,@level1name=N’uspUpdateEmployeeHireInfo’GO
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid BusinessEntityID from the Employee table.’ , @level0type=N’SCHEMA’,@level0name=N’HumanResources’, @level1type=N’PROCEDURE’,@level1name=N’uspUpdateEmployeeHireInfo’, @level2type=N’PARAMETER’,@level2name=N’@BusinessEntityID’GO
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee.’ , @level0type=N’SCHEMA’,@level0name=N’HumanResources’, @level1type=N’PROCEDURE’,@level1name=N’uspUpdateEmployeeHireInfo’, @level2type=N’PARAMETER’,@level2name=N’@JobTitle’GO
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee.’ , @level0type=N’SCHEMA’,@level0name=N’HumanResources’, @level1type=N’PROCEDURE’,@level1name=N’uspUpdateEmployeeHireInfo’, @level2type=N’PARAMETER’,@level2name=N’@HireDate’GO
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the date the rate changed for the employee.’ , @level0type=N’SCHEMA’,@level0name=N’HumanResources’, @level1type=N’PROCEDURE’,@level1name=N’uspUpdateEmployeeHireInfo’, @level2type=N’PARAMETER’,@level2name=N’@RateChangeDate’GO
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the new rate for the employee.’ , @level0type=N’SCHEMA’,@level0name=N’HumanResources’, @level1type=N’PROCEDURE’,@level1name=N’uspUpdateEmployeeHireInfo’, @level2type=N’PARAMETER’,@level2name=N’@Rate’GO
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the pay frequency for the employee.’ , @level0type=N’SCHEMA’,@level0name=N’HumanResources’, @level1type=N’PROCEDURE’,@level1name=N’uspUpdateEmployeeHireInfo’, @level2type=N’PARAMETER’,@level2name=N’@PayFrequency’GO
EXEC sys.sp_addextendedproperty @name=N’MS_Description’, @value=N’Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee.’ , @level0type=N’SCHEMA’,@level0name=N’HumanResources’, @level1type=N’PROCEDURE’,@level1name=N’uspUpdateEmployeeHireInfo’, @level2type=N’PARAMETER’,@level2name=N’@CurrentFlag’GO
——————————–
Stored procedure 2:
USE [WideWorldImporters]GO
/****** Object: StoredProcedure [Integration].[GetOrderUpdates] Script Date: 2/24/2022 1:26:08 PM ******/SET ANSI_NULLS ONGO
SET QUOTED_IDENTIFIER ONGO
CREATE PROCEDURE [Integration].[GetOrderUpdates]@LastCutoff datetime2(7),@NewCutoff datetime2(7)WITH EXECUTE AS OWNERASBEGIN SET NOCOUNT ON; SET XACT_ABORT ON;
SELECT CAST(o.OrderDate AS date) AS [Order Date Key], CAST(ol.PickingCompletedWhen AS date) AS [Picked Date Key], o.OrderID AS [WWI Order ID], o.BackorderOrderID AS [WWI Backorder ID], ol.[Description], pt.PackageTypeName AS Package, ol.Quantity AS Quantity, ol.UnitPrice AS [Unit Price], ol.TaxRate AS [Tax Rate], ROUND(ol.Quantity * ol.UnitPrice, 2) AS [Total Excluding Tax], ROUND(ol.Quantity * ol.UnitPrice * ol.TaxRate / 100.0, 2) AS [Tax Amount], ROUND(ol.Quantity * ol.UnitPrice, 2) ROUND(ol.Quantity * ol.UnitPrice * ol.TaxRate / 100.0, 2) AS [Total Including Tax], c.DeliveryCityID AS [WWI City ID], c.CustomerID AS [WWI Customer ID], ol.StockItemID AS [WWI Stock Item ID], o.SalespersonPersonID AS [WWI Salesperson ID], o.PickedByPersonID AS [WWI Picker ID], CASE WHEN ol.LastEditedWhen > o.LastEditedWhen THEN ol.LastEditedWhen ELSE o.LastEditedWhen END AS [Last Modified When] FROM Sales.Orders AS o INNER JOIN Sales.OrderLines AS ol ON o.OrderID = ol.OrderID INNER JOIN Warehouse.PackageTypes AS pt ON ol.PackageTypeID = pt.PackageTypeID INNER JOIN Sales.Customers AS c ON c.CustomerID = o.CustomerID WHERE CASE WHEN ol.LastEditedWhen > o.LastEditedWhen THEN ol.LastEditedWhen ELSE o.LastEditedWhen END > @LastCutoff AND CASE WHEN ol.LastEditedWhen > o.LastEditedWhen THEN ol.LastEditedWhen ELSE o.LastEditedWhen END <= @NewCutoff ORDER BY o.OrderID;
RETURN 0;END;GO

Essay Writing at Online Custom Essay

5.0 rating based on 10,001 ratings

Rated 4.9/5
10001 review

Review This Service




Rating: