Exam (elaborations)
INF3720 Assignment 2 (COMPLETE ANSWERS) 2024 (602765)- DUE 2 August 2024
INF3720 Assignment 2 (COMPLETE ANSWERS) 2024 (602765)- DUE 2 August 2024
[Show more]
Connected book
Book Title:
Author(s):
- Edition:
- ISBN:
- Edition:
Content preview
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller THEBLAZE1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R45,12. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
73243 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy summaries for 14 years now