The continuing optimization of a company’s business activities through digital technology

Best practices for Design (Technical)

• Respect web conventions to ensure compatibility with
• All browsers
• All devices
• User expectations
• Use W3C standards
• Web site is never finished plan update schedule

Mobile ux

Mobile ux

• Pinching, double tapping, scrolling, and sliding
• Large targets suitable for thumbs
• Support both portrait and landscape orientations or be prepared for rotation
• Be prepared for text-size changes
• Tappable elements
• Apple: 44pixels x 44pixels for all controls
• Microsoft: 26-34 pixels
• Don’t put too near edges of screen
• 30-40 characters per line

Mobile ux

• Avoid changing focus and layout
• Contrast between foreground and background – remember outdoor and indoor access
• Minimal data input

Examples of Other Design Considerations

• https://www.youtube.com/watch?v=u7iUoxqKaKU
• Manually change location 15:34
• Frictionless app to web 17:30
• Comparison shopping 22:54
• Manage payment methods 24:40
• Keyboard 32:30
• Icons 34:34
• Permission 36:50

Database design

Database Design for eCommerce

• All functional eCommerce data is generally stored in an RDBMS

Database design

• Entities (tables) are Customer, Invoice, Product, etc.
• Use relational db principles of primary and foreign keys to join tables as needed

Invoice Number
Customer Number
Invoice Date
Salesperson
INVOICE
Customer Number
Customer First Name
Age
Birthday
CUSTOMER

Product Catalog

• All product information stored in an RDBMS such as Oracle, SQL Server, DB2, MySQL, etc.
• When customer clicks on product, relevant information is pulled from RDBMS and displayed

Product
Product Number	Product Name
Photos	Units on Hand
Price	Colors Available
Size	Vendor
Related Items	Product Category
Product Sub-category	Product Description
Discount Available	Vendor Product ID