NSC Information Technology CRUD operations: Smart home devices are becoming

Question

Smart home devices are becoming more popular among people that have access to fast reliable internet connections.

A database called SmartDevicesDB.mdb has been developed and contains information about the different manufacturers of smart devices and the stock available of the different devices.

The SmartDevicesDB.mdb database contains two tables called tblManufacturers and tblDevices.

The data pages attached at the end of the question paper provide information on the design and contents of the database.

Do the following:

Open the incomplete project file called Question2_P.dpr in the Question 2 folder.
Enter your examination number as a comment in the first line of the Question2_U.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** 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 sDeviceType.
Display the DeviceName, Category and NumInStock of all devices where the Category field has been set to 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	89
View Tube	Smart TV	67
Telly Witz	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 of the product. The profit after selling the stock is 60% of the selling price of the product. 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 900 502.40
M103	R124 384 024.40
M104	R265 800.00
M105	R859 890.00
M176	R475 419.60

**2.2** Database Manipulation

**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_1 component.

Write code to do the following:

Display the manufacturer name and contact number in the appropriate 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	R100 000.00
Look Tv	2	R450.00

Gem Smart:
0169725478
Device name	In stock	Price
Dub 2	20	R500.00
Freeze 3	4	R1 000.00
Time Maker	2	R1 500.00

**2.2.2 Button [2.2.2 - Update stock]**
When devices are sold, the number in stock must be decreased in the table tblDevices.

The user must select the record of the device to be sold from the tblDevices table in the DBGrid component dbgDevices.

Write code to do the following:

Provide an input dialog box for the user to enter the number of devices to sell for the record selected.
Test if the tblDevices[NumInStock] >= nNumSold:
	- 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.

Smart home devices are becoming more popular among people that have access to fast reliable internet connections - NSC Information Technology - Question 2 - 2023 - Paper 1

Worked Solution & Example Answer:Smart home devices are becoming more popular among people that have access to fast reliable internet connections - 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...