Instructions:

The assignment must be completed as an individual effort. Submit the assignment on SLATE before the due date which is specified on SLATE. All online submissions will be done via SLATE (Email submissions will NOT be accepted). This assignment is of 20%. Create a solution file in neat, clean format and properly explained Late assignments will be penalized 10% each day for up to 3 days. After that, it is worth zero. Please refer to the Academic Dishonesty Policy.

Assignment Instructions:

In the Northwind database, CategoryID of Categories table is a foreign key in Products table. Create an app where the user can get all products filtered by a category. If the user enters CategoryID, fetch all the products based on that CategoryID. Fetch all records from the Products table and display the following columns:
ProductID   ProductName   CategoryName Use the Categories and Products tables in the Northwind database. Note that CategoryName doesn’t belong to Products table, but CategoryID does. Use SQL’s INNER JOIN to replace CategoryID with CategoryName. (Refer to Database notes or Google, to get more information on Inner Joins) Refer to the following diagram which shows Class Hierarchy:

URL -docs.yugabyte.com
Hint: Use either connected or disconnected model.

Submission:

Once done, ZIP the solution folder and upload it to Assignments on SLATE. You are to submit 2 files, separately: Upload the .ZIP file of your assignment to SLATE Upload the .TXT file to SLATE. You must copy and paste all your source code from your C# file into a plain text file. You can copy and paste the source code into Notepad. You don't have to format this code - it's used by TurnItIn (the originality checker in SLATE, which is a piece of software that checks your submission for plagiarism against other submissions in the college, in other colleges, from the web, and various other sources). Submit this document in addition to your assignment ZIP file. DO NOT add it inside your zip/rar file - it must be a separate file. This is used for TurnItIn (it won't examine the contents of zip/rar files).
To Download Click Here > PROG32356 .Net Technologies Using C# Assignment 2.pdf