Evisu - A Transactional Website

Evisu is an online clothes shop, selling a wide variety of garments under the Evisu brand name. Being transactional lots of data is required (captured) from consumers in order to successfully complete the process and order/receive the goods.

I compressed this collected data into specific lists :
Consumer - Information relating to the consumers personal details

• First and last name name (and title)
• Email address (primary key)
• Phone and mobile number
• Address 1 and 2
• City
• Postal code
• Country
• Billing address

Transaction - The payment and shipping details

• Shipping method
• Payment method
• Card number
• Security code
• Expiry date
• Card holders name

Transaction-Item - Shopping basket information relating specifically to the item(s) desired.

• Size
• Price
• Quantity required

While this is for Evisu, it holds much similarity to other transactional websites and the relational databases they will hold. In some cases the site may require the buyer to register/sign in before or during the process using a user name (often e-mail) and password. This enables this information to be saved and re-used in the future for further buys. 'Casual consumers' may only buy once and therefore would not need an account. For more information on the processes involved see 'Processes of an online purchase'.