NSC Information Technology SQL statements: Open the incomplete project file

Question

Open the incomplete project file called Question2_P.dpr in the Question 2 folder.
Enter your examination number in the first line of the Question2U.pas unit file.
Compile and execute the program. The program has no functionality currently. The contents of the tables are displayed as shown below on the selection of tab sheet 2.2 - Delphi code.

**2.1.1 Button [2.1.1 - iOS devices]**
Display the DeviceID and DeviceName of all devices in the tblDevices table, that use the iOS operating system.

Example of output of the first five records:

DeviceID    DeviceName
D005        Core Sound
D028        Ultra Light
D020        Boom XL
D014        Lock Smart
D021        Sound Wave

**2.1.2 Button [2.1.2 - Category selected]**
The user must select a device type from the combo box cmbQ2_1_2. Code has been provided to extract and store the device type selected in a variable $DeviceType$.
Display the DeviceName, Category and NumInStock of all devices where the Category field has matched the device type selected from the combo box.

Example of output if TV was selected as a device type:

DeviceName      Category      NumInStock
Crystal TV      Smart TV      39
View Tube       Smart TV      46

**2.1.3 Button [2.1.3 - Online support]**

**2.1.4 Button [2.1.4 - Profit per manufacturer]**
All the products in stock are available to be purchased at a clearance sale. The price shown in the tblDevices table, is the retail price for the selling price of the product. The profit after selling the stock is 60% of the selling price. The total profit made by each manufacturer must be calculated assuming that all products will be sold at the sale.
Write code to display the ManufacturerID and the total profit in a new field called Profit, formatted to currency.

Example of output:

ManufacturerID  Profit
M100            R672 900.00
M101            R438 000.00
M102            R1 090 502.40
M103            R284 042.40
M104            R265 000.00
M105            R859 089.00
Total          R475 419.60

**2.2.1 Button [2.2.1 - Display products]**
Retailers want to see which products are made by each manufacturer. Code has been provided to clear the content in the redQ2_2_1 component.

Do the following:
Display the manufacturer name and contact number in the redQ2_2_1 component.
Display the following headings for each manufacturer:

'Device name' 'In stock' 'Price'

Display all the devices made by each manufacturer using the appropriate headings.

Example output of the first two manufacturers (Berry Tech and Gem Smart):

Berry Tech: 0122035878

Device name    In stock    Price
Key Away       240         R 1000.00
Look TV       2           R 450.00

Gem Smart: 0169725478

Device name    In stock    Price
Dub 2         60          R 2,500.00
Freeze 3      20          R 1,000.00
Ice Maker     76          R 500.00
Time Keeper   80          R 450.00

**2.2.2 Button [2.2.2 - Update stock]**
When devices are sold, the number in stock must be decreased in the tblDevices table.
The user must select the record of the device to be sold from the tblDevices table in the DBGDevices grid.
Write code to do the following:

Provide an input dialog box for the user to enter the number of devices sold for the record selected.
Test if it is sufficient, decrease the number in stock for the selected item with the number that was entered.
If stock is insufficient, display a suitable message.

Open the incomplete project file called Question2_P.dpr in the Question 2 folder - NSC Information Technology - Question 2 - 2023 - Paper 1

Worked Solution & Example Answer:Open the incomplete project file called Question2_P.dpr in the Question 2 folder - NSC Information Technology - Question 2 - 2023 - Paper 1

Button [2.1.1 - iOS devices]

Button [2.1.2 - Category selected]

Join the NSC students using SimpleStudy...