TU2983: Advanced Databases
Individual Assignment 1
Normalized Relational Databases and Basic System Interfaces
TASK 1: Build a Normalized Relational Database in Microsoft Access for your individually assigned topic:
1. Refer to the “TU2983 Individual Assignment Topics” document on http://ukmfolio.ukm.my for your individually assigned topic. Decide on an appropriate/catchy name for a shop selling this product (e.g “Solar Panel Mart”).
2. Build a table called TBL_PRODUCTS_<YOUR_MATRIC> (e.g. TBL_PRODUCTS_A123456) that contains a minimum of 40 rows of products matching your individually assigned topic. This table must have the following attributes:
• FLD_PRODUCT_ID → assign your own ID (keep it simple, future assignments will be based on the same data)
• FLD_PRODUCT_NAME → copy from the source website (e.g. amazon.com, tesco.com, zalora.com)
• FLD_PRICE → copy from the source website, or set your own price.
• 2 other attributes that can be used as categories (e.g FLD_BRAND, FLD_TYPE, FLD_SHIRTSIZE)
• At least another 2 attributes of any type (e.g. FLD_DESCRIPTION, FLD_QUANTITY, FLD_WARRANTYLENGTH) Your TBL_PRODUCTS_<YOUR_MATRIC> table must have at least 7 attributes in total.
3. Copy a picture of the product, for each product in your TBL_PRODUCTS_<your_matric> table, and rename the picture to match your FLD_PRODUCT_ID for the product. (e.g. if the FLD_PRODUCT_ID is “25”, save the picture as “25.jpg”)
• Save all you pictures in a subfolder called “pictures” .
4. Build additional tables for the following:
• 1 table for Staff information, with the necessary attributes (start with only 3 staff)
• 1 table for Customer information, with the necessary attributes (start with only 3 customers)
• 1 table for Order information, with the necessary attributes (start with no orders)
• And any additional table you need so that:
o 1 customer can make many orders, but each order is only for 1 customer
o 1 order can contain many products, and each product can be in many orders
o 1 staff can process many orders, but each order is only processed by 1 staff
• Ensure that all your tables are normalized to at least 3NF.
5. Use the relationship view in Microsoft Access to specify the relationship between each of your tables
• Each table must be related to at least 1 other table.
• All tables must be connected to each other through relationships.
• Enforce referential integrity on all your relationships to show the cardinality of the relationship in the Microsoft Access Relationship View.
6. Your database file must be saved as DB_<YOUR_SHOP_NAME>_<YOUR_MATRIC>.accdb (e.g. DB_SOLARPANELMART_A123456.accdb)
TASK 2: Build a new Visual Basic .NET project for creating a Basic System Interface for your shop:
1. Build a “Main Menu” for your shop, called frm_mainmenu_<your_matric>.vb (e.g. frm_mainmenu_a123456.vb)
• 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’sdata.
• Each button on your “Main Menu” must open one of these forms. You must have at least 4 buttons.
• 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)
SUBMIT THE FOLLOWING:
1. Your entire VB project folder for this assignment’s project.
2. Your Microsoft Access Database, which should be stored in your VB project’s Bin/Debug directory.
3. Your “pictures” subfolder, which should be stored as a subdirectory in your VB project’s Bin/Debug directory.
• 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)
• *** 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.
• Upload your *.ZIP/*.RAR file to UKMfolio, at the Lab Assignment 1 Submission Link which has your EVALUATOR’S NAME on it.
• All *.ZIP/*.RAR files for the assignment must be submitted to UKMfolio before the following due date:
Due date: Sunday 24th November 2024, 11:59pm Malaysia Time (GMT +8).