Photo AI
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
Question 2
Smart home devices are becoming more popular among people that have access to fast reliable internet connections. A database called SmartDevicesDB.mdb has been deve... show full transcript
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
Step 1
Button [2.2.1 - Display products]
Answer
To display the products:
-
Access the tblManufacturers: Start by looping through the
tblManufacturersto access each manufacturer. -
Display Manufacturer Information: For each manufacturer, display the
ManufacturerNameandContactNumberin a specific component (e.g., a label). -
Set Up Headings: In the output section, prepare the headings: 'Device name', 'In stock', and 'Price'.
-
Access the tblDevices: For each manufacturer, loop through
tblDevicesto check for matchingManufacturerID. -
Display Device Information: For each device made by the manufacturer, display the
DeviceName,NumInStock, andPrice. Ensure that thePriceis formatted correctly as a string. -
End the Loop: Finish each loop correctly to ensure all data is displayed without omissions.
Step 2
Button [2.2.2 - Update stock]
Answer
To update the stock when devices are sold:
-
Input Dialog for Quantity: Extract the number of devices to sell using an input dialog box and convert it into an integer.
-
Check Stock Availability: Use an
ifstatement to test whethertblDevices.NumInStockis greater than or equal to the specified quantity. -
Update Stock: If there is sufficient stock, decrease the
NumInStockby the value given in the input dialog. Update the database accordingly. -
Insufficient Stock Handling: If the stock is not sufficient, display a message to the user indicating that there are not enough items in stock.