Computer science assignment

Order Details
Order ID	Product	Unit Price	Quantity	Discount
10248	Queso Cabrales	14	12	2%
10248	Singaporean Hokkien Fried Mee	9.8	10	2%
10248	Mozzarella di Giovanni	34.8	5	4.2%
10249	Tofu	18.6	9	3.1%
10249	Manjimup Dried Apples	42.4	40	2.3%
10250	Jack's New England Clam Chowder	7.7	10	1.2%
10250	Manjimup Dried Apples	42.4	35	0.15%
10250	Louisiana Fiery Hot Pepper Sauce	16.8	15	0.15%
10251	Gustaf's Knäckebröd	16.8	6	0.05%
10251	Ravioli Angelo	15.6	15	0.05%
10251	Louisiana Fiery Hot Pepper Sauce	16.8	20	6%
10252	Sir Rodney's Marmalade	64.8	40	0.05%
10252	Geitost	2	25	0.05
10252	Camembert Pierrot	27.2	40	7%
10253	Gorgonzola Telino	10	20	02.5%
10253	Chartreuse verte	14.4	42	3%
10253	Maxilaku	16	40	1.5%
10254	Guaraná Fantástica	3.6	15	0.15%
10254	Pâté chinois	19.2	21	0.13%
10254	Longlife Tofu	8	21	7%
10255	Chang	15.2	20	3%
10255	Pavlova	13.9	35	6%
10255	Inlagd Sill	15.2	25	3%
10255	Raclette Courdavault	44	30	3%
10256	Perth Pasties	26.2	15	2%
10256	Original Frankfurter grüne Soße	10.4	12	2.5%
10257	Schoggi Schokolade	35.1	25	5%
10257	Chartreuse verte	14.4	6	6%
10257	Original Frankfurter grüne Soße	10.4	15	9%
10258	Chang	15.2	50	0.2%
10258	Chef Anton's Gumbo Mix	17	65	0.2%
10258	Mascarpone Fabioli	25.6	6	0.2%
10259	Sir Rodney's Scones	8	10	1%
10259	Gravad lax	20.8	1	7%
10260	Jack's New England Clam Chowder	7.7	16	0.25%
10260	Ravioli Angelo	15.6	50	3.1%
10260	Tarte au sucre	39.4	15	0.25%
10260	Outback Lager	12	21	0.25%
10261	Sir Rodney's Scones	8	20	5%
10261	Steeleye Stout	14.4	20	1.1%
10262	Chef Anton's Gumbo Mix	17	12	4.5%

        

    With the Order Details table above, please

1.     Highlight product(s) with cheapest price

2.     Highlight product(s) with highest price

3.     Calculate the total quantity of the product with Order ID=10260

4.     Count the products with Order ID=10255

5.     Count the products with Order ID=10255 and their quantities are greater than 30 and less than 70

6.     Count the products with their names beginning with “ch”

7.     Count the products with their unit prices > 40 and their quantities >30

8.     Calculate the average of unit prices of products with Order ID =10255

The SysKey Password

https://oldpaperlabs.blogspot.in/

In Window XP, Security Accounts Management (SAM) database stores hashed copies of user passwords. To keep the SAM database secure, Window requires that the password hashes are encrypted. SAM database is encrypted with a locally stored system key. SysKey utility can additionally secure the SAM database by moving the SAM database encryption key off the Windows-based computer. The SysKey utility can configure a start-up password that must be entered to decrypt the system key so that Windows can access the SAM database.

Syskey password is the powerful security mechanism we have in windows platform. Because its has the 128 bit encryption.

To break Syskey password we are going to use

HIREN BOOT Tool.

1.Boot your system with Hiren Boot.

2.After booting you have a Hiren Boot main console where we find many options, firstly we have to choose option 9, then option 5, then select option 2, then click on OK and again click on OK.

3.So it createa R drive (for RAM space)

4.E:\> D: (tupe D with : it will change your location from E to D) 

D:\> cd windows (change your directory to Windows directory)

D:\> cd repair

repair:\> (type following commands on repair directory location)

repair:\> copy samd:\windows\system32\config (it will prompt to change the existing file)

repair:\> copy samd:\windows\system32\security (it will prompt to change the existing file)

repair:\> copy samd:\windows\system32\system (itwill prompt to change the existing file)

 

Disable Send error Reporting

Oldpaperlabs.blogspot.in

The Send Error Report option automatically captures essential information to help us resolve the problems you may be facing with the application.

To enable or disable error reporting

1.	Open System in Control Panel.
2.	On the Advanced tab, click Error Reporting.
3.	Click Disable error reporting or Enable error reporting.

Note

	1.To open System, click Start, click Control Panel, click Performance and Maintenance, and then click System.
2.	If you disable error reporting, you can still have Windows notify you when an error occurs. To do so, select the But notify me when critical errors occur check box.
3.	To report operating system errors, select the Windows operating system check box.
4.	To report program errors for programs, such as Microsoft Word, select the Programs check box.