TS6024: Information Modelling and Databases
Individual Assignment 2
Basic System Interfaces and Data Manipulation Interfaces
IMPORTANT NOTE: This assignment continues from the work you have done in “Individual Assignment 1”.
You are required to re-use the same Microsoft Access File that you created for “Individual Assignment 1”, or use an improved
version of the same database for “Individual Assignment 1”:
1. You will use the same topic that was previously assigned to you in “Individual Assignment 1”.
2. The database file that you previously created for “Individual Assignment 1” must be used, or be improved.
3. The pictures that you have previously collected created for “Individual Assignment 1” must be used.
4. Evaluation of “Individual Assignment 2” will only be made on the following Tasks:
TASK 1: Build a new Visual Basic .NET project for creating a Basic System Interface for your shop:
1. Build a “Main Menu” form for your shop, called frm_mainmenu_<your_matric>.vb (e.g. frm_mainmenu_a123456.vb)
AND ALSO additional forms for viewing the contents of each table in your database.
 Your “Main Menu” must have buttons, where each button will open a separate form that can view the contents of
one table. You must have enough buttons and forms to open and view the contents of all your tables.
 For each table (products, customers, staff, orders) build a form that will open and view the table’s data.
 Use the tutorial provided on Lab Notes 2-2 for building this main menu, and data access forms to view data.
 Your “Main Menu” will be evaluated in terms of aesthetics, design, neatness and professionalism.
2. Your VB.NET project must be saved as prj_<your_shop_name>_<your_matric> (e.g. prj_solarpanelmart_a123456)
TASK 2: Build a “Catalog” form that the user can use to browse each product in your database and view the product’s picture.
1. Use the same table of products, tbl_products_<your_matric> (e.g. tbl_products_a123456), that you created for
“Individual Assignment 1”, or use an improved version of the table of products.
2. Use the same pictures of products that you collected for “Individual Assignment 1”.
3. The user must be able to view the attributes of each products and the product picture at the same time
TASK 3: Add new buttons to your ‘MAIN MENU’ form that can open each of the forms that you built for TASK 1 & 2 above.
1. Your program will also be evaluated for aesthetics, neatness, and user-friendliness.
SUBMIT THE FOLLOWING:
1. Your entire VB project folder for this assignment’s project, which contains:
o Your Microsoft Access Database, which should be stored in your VB project’s Bin/Debug directory.
o Your “pictures” subfolder, which should be stored as a subdirectory in your VB project’s Bin/Debug directory.
o All the forms that you created for “Individual Assignment 2” above.
2. Compress all the files above into a single *.ZIP or *.RAR, and label this file as <your_matric>_<your_shop_name).zip/.rar
(e.g. a123456_solarpanelmart.zip)
3. *** IMPORTANT ***: Your *.ZIP/*.RAR must not exceed 100mb (Megabytes). If it does exceed 100mb, you need to
reduce the resolution of all your pictures, in order to reduce their file size.
4. Upload your *.ZIP/*.RAR file to UKMfolio, at the Lab Assignment 2 Submission Link for either FULL-TIME or PART-TIME
students.
5. All assignments must be submitted to UKMfolio before the due date.
Due date: For FULL TIME students: Sunday 17th December 2023, 11:59pm.
For PART TIME students: Sunday 31st December 2023, 11:59pm.
请加QQ：99515681 或邮箱：99515681@qq.com   WX：codehelp