.. I'm on page 214/468 right now <-- NOT STARTED
.. Challenge work required, page 684 question 1 <-- DONE submitted
.. assignment 5 is one exercise from chapter 13, 14, 15 and 16 <-- DONE submitted
.. QUESTION KEY
.. chapter 13, question 10 page 650
.. chapter 14, question 4, page 684
.. chapter 15, question 3a, 3b, page 724, 725
.. chapter 16, question 4, page 754


Unit five, section two
++++++++++++++++++++++++
Commerce and databases


Challenge work submission
===========================

1. Read chapter 14 of the textbook.
2. Complete challenge work #1, on page 684 of the text.


.. note:: 
   Corresponds to challenge work #1, on page 684 of the text. The instructions may say a short profile, but the course Brightspace says 2-3 paragraphs is sufficient.

https://www.apple.com/ca/
==========================

I chose the Apple store as an example of a well designed and lightweight website since it has a very clear and concise experience both in the design and implementation.

The use of colour and white space are almost the same, the website changes only slightly with light tone gradients. Unlike competitors, the focus is on minimalism, which helps users find the products they're looking for.

The ease of navigation is apparent in the limited options. In a comparitive example, NVIDIA and AMD carry various third party sellers and preferred partners when you select "Buy Now", which floods the page with affiliate links and redirects to external sites. Apple keeps the flow within its own website, which keeps consistency of the navigation experience. The taxonomy is clear and direct, giving the user control through the entire discovery-to-purchase experience.

The privacy policy and security assurance is displayed in the footer, but it doesn't spam the user with popups like other websites.

The purchase experience is seamless, providing details in a secure payment transaction and filling basic billing information is all that's required. 


Works cited
~~~~~~~~~~~~
Schneider, G. Michael, and Judith Gersting. Invitation to Computer Science. 6th ed., Cengage Learning, 2013.



Assignment 5 (chapter fourteen, section five)
==============================================
.. this is technically part 2/4 for assignment 5. The next parts are in the continued chapters, unitFiveSection[n].rst

*4. what is the result of the following SQL query? (Chapter 14, page 684)*


.. code:: SQL

   SELECT * FROM Employees WHERE HoursWorked < 100;

.. image:: ../images/cs200-sourceData.png


Solution
~~~~~~~~~

.. table::

   ====== ======== ========= ========== ======== ============
   ID     LastName FirstName Birthdate  PayRate  HoursWorked
   ====== ======== ========= ========== ======== ============
   116    Kay      Janet     3/29/1976  $16.60   94
   165    Honou    Morris    6/9/1993   $6.70    53
   ====== ======== ========= ========== ======== ============


Works cited
~~~~~~~~~~~~
Schneider, G. Michael, and Judith Gersting. Invitation to Computer Science. 6th ed., Cengage Learning, 2013.