I
,NF3720 Assignment 2 (COMPLETE ANSWERS) 2
024 (602765)- DUE 2 August 2024 ; 1
00% TRUSTED
Question 1: 13 marks Question 1.1 Many software products
suffer from interaction design errors that are annoying to users
because they do not follow fundamental design principles. As
an interaction designer, how can you ensure that software
products are designed to provide a good user experience? (2
marks) Question 1.2 There is a fine line between an interaction
that works and one that is usable. Designing interactions that
work and are usable is achievable if design principles are
appropriately applied. Discuss the design principles that guide
interaction design. (5 marks) Question 1.3 Identify and discuss
five usability goals. Also, provide one positive or one negative
comment regarding the usability of myUnisa that you have
experienced for each of the goals. (6 marks)
List of All Customers in Florida Who Have Ordered Books
About Computers
To get a list of customers who live in Florida and have ordered
books about computers, you would join the relevant tables:
CUSTOMERS, ORDERS, ORDER_ITEMS, and BOOKS. The query
should filter by the customer’s state and the category of books
ordered.
Here's a SQL query assuming standard table and column names:
sql
,Copy code
SELECT DISTINCT c.CustomerID, c.last_name, c.first_name
FROM CUSTOMERS c
JOIN ORDERS o ON c.CustomerID = o.CustomerID
JOIN ORDER_ITEMS oi ON o.OrderID = oi.OrderID
JOIN BOOKS b ON oi.BookID = b.BookID
WHERE c.state = 'Florida'
AND b.category = 'COMPUTER';
4.2 Determine Which Books Customer Jake Lucas Purchased
To find out which books Jake Lucas purchased, you'll use a
query that joins the CUSTOMERS, ORDERS, ORDER_ITEMS, and
BOOKS tables. This query will focus on Jake Lucas and show all
books he purchased, including duplicate results if he bought
multiple copies of the same book.
Here's the SQL query:
sql
Copy code
SELECT b.title, oi.quantity
FROM CUSTOMERS c
JOIN ORDERS o ON c.CustomerID = o.CustomerID
JOIN ORDER_ITEMS oi ON o.OrderID = oi.OrderID
, JOIN BOOKS b ON oi.BookID = b.BookID
WHERE c.last_name = 'Lucas'
AND c.first_name = 'Jake';
Explanation
For 4.1:
o Joins CUSTOMERS with ORDERS to get orders by
customers.
o Joins ORDERS with ORDER_ITEMS to get details of the
ordered items.
o Joins ORDER_ITEMS with BOOKS to get book details
and filter by book category.
o Filters by the state of Florida and the book category
'COMPUTER'.
For 4.2:
o Joins CUSTOMERS with ORDERS to get orders by Jake
Lucas.
o Joins ORDERS with ORDER_ITEMS to get the specific
items ordered.
o Joins ORDER_ITEMS with BOOKS to get book titles.
o Filters by the name 'Jake Lucas' to get the purchased
books and their quantities.
Summary of SQL Queries
,NF3720 Assignment 2 (COMPLETE ANSWERS) 2
024 (602765)- DUE 2 August 2024 ; 1
00% TRUSTED
Question 1: 13 marks Question 1.1 Many software products
suffer from interaction design errors that are annoying to users
because they do not follow fundamental design principles. As
an interaction designer, how can you ensure that software
products are designed to provide a good user experience? (2
marks) Question 1.2 There is a fine line between an interaction
that works and one that is usable. Designing interactions that
work and are usable is achievable if design principles are
appropriately applied. Discuss the design principles that guide
interaction design. (5 marks) Question 1.3 Identify and discuss
five usability goals. Also, provide one positive or one negative
comment regarding the usability of myUnisa that you have
experienced for each of the goals. (6 marks)
List of All Customers in Florida Who Have Ordered Books
About Computers
To get a list of customers who live in Florida and have ordered
books about computers, you would join the relevant tables:
CUSTOMERS, ORDERS, ORDER_ITEMS, and BOOKS. The query
should filter by the customer’s state and the category of books
ordered.
Here's a SQL query assuming standard table and column names:
sql
,Copy code
SELECT DISTINCT c.CustomerID, c.last_name, c.first_name
FROM CUSTOMERS c
JOIN ORDERS o ON c.CustomerID = o.CustomerID
JOIN ORDER_ITEMS oi ON o.OrderID = oi.OrderID
JOIN BOOKS b ON oi.BookID = b.BookID
WHERE c.state = 'Florida'
AND b.category = 'COMPUTER';
4.2 Determine Which Books Customer Jake Lucas Purchased
To find out which books Jake Lucas purchased, you'll use a
query that joins the CUSTOMERS, ORDERS, ORDER_ITEMS, and
BOOKS tables. This query will focus on Jake Lucas and show all
books he purchased, including duplicate results if he bought
multiple copies of the same book.
Here's the SQL query:
sql
Copy code
SELECT b.title, oi.quantity
FROM CUSTOMERS c
JOIN ORDERS o ON c.CustomerID = o.CustomerID
JOIN ORDER_ITEMS oi ON o.OrderID = oi.OrderID
, JOIN BOOKS b ON oi.BookID = b.BookID
WHERE c.last_name = 'Lucas'
AND c.first_name = 'Jake';
Explanation
For 4.1:
o Joins CUSTOMERS with ORDERS to get orders by
customers.
o Joins ORDERS with ORDER_ITEMS to get details of the
ordered items.
o Joins ORDER_ITEMS with BOOKS to get book details
and filter by book category.
o Filters by the state of Florida and the book category
'COMPUTER'.
For 4.2:
o Joins CUSTOMERS with ORDERS to get orders by Jake
Lucas.
o Joins ORDERS with ORDER_ITEMS to get the specific
items ordered.
o Joins ORDER_ITEMS with BOOKS to get book titles.
o Filters by the name 'Jake Lucas' to get the purchased
books and their quantities.
Summary of SQL Queries
