Further on for the below question asked for Task 3 should the below be added for quantity even though it is not seen in the table for task 2 Consider the following table, which stores information about IT equipment used in the library at CSU's Albury-Wodonga campus:

Asset_ID	Asset_Name	Purchase_Date	Units_In_Stock	Unit_Price	Transaction_ID	Transaction_Date	Vendor_ID	Vendor_Name
IT-001-X	Desktop PC	15/06/2022	40	$1200	500101	20/06/2022	VEND-01	JB Hi-Fi
IT-002-Y	Wireless Mouse	10/08/2022	150	$25	500102	15/08/2022	VEND-02	The Good Guys
IT-003-Z	Monitor	12/09/2022	30	$300	500103	18/09/2022	VEND-01	JB Hi-Fi
IT-004-W	Docking Station	20/10/2022	25	$150	500104	25/10/2022	VEND-03	Harvey Norman
IT-005-V	Webcam	25/11/2022	60	$80	500105	30/11/2022	VEND-02	The Good Guys

https://www.coursehero.com/qa/wait/79533362/?question_id=79533362 Suggestion below from chat gpt recommendaiton this may not need to be included just a suggestion? (if your lecturer is strict):

In Asset, Units_In_Stock may not belong there if stock levels are supposed to be updated per transaction ? sometimes this is kept in a Stock table or derived from transactions.

In Transaction, you might also need a field like Quantity (e.g., how many units purchased in that transaction). Otherwise, the system can't track purchases properly.

Yes ? your diagram is correct for Task 3 and satisfies 3NF. Just note: if your teacher expects tracking of quantity purchased per transaction, add Quantity in the Transaction table.

Asset PK Asset ID Asset 1 Asset Name Purchase Date Units In Stocks Transaction unit Price 0.* Transaction PK Transaction_ID Transaction date FK Asset ID FK Vendor ID Vendor PK Vendor ID Vendor 1 Vendor Name