Programming Skills Test Software Developer .NET assignment help

Solution.pdf

1 Introduction With the programming skills test, we will assess your knowledge and experience in the environments that you will work in: C#, .NET and Microsoft SQL Server. You can do these tests at home and use any references you like to complete them. Rather than testing your memory and book knowledge, we will confront you with programming challenges that are representative of the kind of work you will encounter when working for Outperform. The tests are divided into two sections. 

• C# programming 

• SQL modeling and programming 

1.1 How to deliver the test results Most questions ask you to write some code. You should provide in flat text files with the appropriate extensions (.cs, .sql, etc) and file names referring to the question number. If you want to include diagrams or other visual clues, provide them in the form of PNG, JPEG or GIF images. Textual responses or explanations can be delivered in Word, RTF or PDF format. Package the files in a zip, tar or rar archive and send that to the email address from which you received this test. 

1.2 How we will assess the tests 

• The code should be free of syntax errors, and in the case of C#, compile without errors and warnings. 

• The target for C# is .NET 4.0 or higher, for SQL it is SQL Server 2008 and 2012. 

• The code should cover the full extent of the requirements and deliver correct results. 

• The code should perform well and be easy on memory 

• The code should be elegant, easy to read and maintain and moderately but not overly documented. 

• Don’t be afraid if you can’t answer all questions. If you deliver well on most questions, we’ll assume you will be able to learn what’s needed on the job. 

• You can take your time to complete the test. However, like in real working life, a speedy response is considered a bonus. 

1.3 Other programming environments We don’t believe in good and better programming environments, only in good and better programmers. If you are an excellent Java programmer, you will be an excellent C# programmer as well. If you are a crack in PL/SQL or MySQL, you will master T-SQL as well If you are more comfortable in Java, you can deliver your answers to section 2 in Java code. You can also deliver answers to section 3 in PL/SQL or MySQL. 

Good luck and we hope to hear from you soon. 

The Outperform development team 

Programming Skills Test - 1 - 23-Dec-2014 

Programming Skills Test Software Developer .NET 

2 C# Questions This section contains three C# related questions. 

2.1 Mail Merge Objective: Write a mail merge method that takes a template text file, substitutes specially marked up text blocks with data entries from an XML file and writes files with substituted text to an output directory. You are free to include other private implementation methods as needed. 

/// /// Merge template text from with XML data /// ///Full path to template flat text file ///Full path to XML data file ///Directory to write substituted text topublic void MergeMail(string templateFile, string xmlFile, string outputDir) { 

// Your implementation here... } Details: Placeholders in the template text are marked up by keywords within percentage characters like %foo%. Such keywords can be found in the XML as elements like bar. The marked keywords in the text, including % characters, should be replaced by the substitution. In this example, each occurrence of %foo% must be replaced by bar. The XML contains various mail entries, each with their substitution values. There is no a priori schema to which keywords can be substituted. Each mail entry is an element in the file identified by a unique ID but without a predetermined element name. The substitution values in the XML File may themselves contain keyword patterns that should be recursively substituted. For each entry, an output file with name equal to the entry ID must be written to the output directory. 

Sample XML file: 

<?xml version="1.0" encoding="utf-8" ?> <Orders> 

<Order id="12345"> 

<firstname>Johnfirstname> <lastname>Smithlastname> <title>Mrtitle> <salutation>Dear %title% %lastname%salutation> <product>Chicken Nuggetsproduct> <price>$10.00price> <discount>12discount> <address>128 Oak Drive, Corktownaddress> Order> <Order id="12346"> 

<firstname>Janefirstname> <lastname>Doelastname> <salutation>Dear %firstname%salutation> <product>Hamburgersproduct> <price>$5.00price> <discount>5discount> <address>1512 Crescent Ave, Hamptonaddress> Order> Orders> 

Sample template file: 

%salutation% Thank you for ordering %product% from our website. We will deliver it to %address%. The price is %price% with a %discount%% discount. 

Sample output files: 

Dear Mr Smith Thank you for ordering Chicken Nuggets from our website. We will deliver it to 128 Oak Drive, Corktown. The price is $10.00 with a 12% discount. 

Dear Jane Thank you for ordering Hamburgers from our website. We will deliver it to 1512 Crescent Ave, Hampton. The price is $5.00 with a 5% discount. 

Programming Skills Test - 2 - 23-Dec-2014 

Programming Skills Test Software Developer .NET 

2.2 Sparse Arrays A sparse array is an array with a lot of elements, most of which have the same value (usually zero). Such an array might have millions of logical elements but only a few hundred that are non-zero. Objective: Implement a class for sparse arrays of double precision numbers that is optimal in memory requirements as well as in the performance of its methods. Constructors: 

• Constructors take the length of the array as an argument and uses 0 as the default value. 

• Constructor that takes length and a default value. Properties: 

• Length: Get the logical length of the array 

• Indexed properties to get and set the element values. Methods: 

• Sum(): returns the logical sum of values; 

• Average(): returns the logical average of values; 

• Sort(): sorts the elements of the array in ascending order. 

• Reverse(): Turns the array upside down. Applying Sort() and then Reverse() is the same as sorting in descending order. Operators: 

• Vector addition, such that (a+b)[i] == a[i] + b[i]. Include checks and exceptions for arrays that don’t fit each other. 

• Scalar multiplication by double number, such that (a*x)[i] == a[i] * x. Include its symmetric counterpart. 

3 SQL Questions This section contains four SQL questions, related to a single use case: A company sells computers on line to end customers. These computers consist of a base model that can be customized with specific parts, such as a faster hard disk, CPU or video controller. Parts may fit into several but not all base models. An order placed by a customer consists of one or more items; each item has one base model with zero or more custom parts. 

3.1 Data Model Describe a data model for this domain with customers, base models, parts, sales orders and items. Provide each entity with a minimal set of attributes that you would expect in such a model. (See follow-up questions for hints.) You can describe this model in text form or in a diagram. In the latter case, submit your diagram as PNG, JPEG or GIF image. 

3.2 Tables and constraints Provide an implementation of the data model in the form of SQL DDL statements. Include primary and foreign key constraints as well as constraints like “an order item may only contain parts that fit in its base model”, using the most appropriate DDL constructions. 

3.3 Total Recall The company detects that a particular part has a defect and decides to replace that part for free for all customers that recently ordered a model with that custom part. 

Programming Skills Test - 3 - 23-Dec-2014 

Programming Skills Test Software Developer .NET 

Write a SQL query that returns a list of all customers that placed such an order in the past three months, with their name and address and for each customer; the number of items ordered with that part; and the total sales price for those items (including the price of the base model, the defective part and any other custom parts). 

3.4 Loyalty Bonus The company decides to reimburse a purchased item to their most loyal customers every month. Write a SQL query that lists, for each month of the past twelve months, the customer who ordered the most that month (in amount of money spent); together with the order and item number of the cheapest item they bought that month.

Tired of the boring assignments to be submitted to colleges and universities? MyAssignmentMart.com gives you multiple reasons to trust it with your orders. We employ PhD experts handpicked from prestigious universities over the globe. We cater to quality assignment help, dissertation writing services and online essay help, covering more than 100 academic subjects. We pledge to complete your assignments on time and never compromise when it comes to deadline. Our prices for assignments are the most competitive in the market and make sure the cost suits your budget.