Question

Could I get an answer on the following:

Consider any online retailer with whom you either have direct experience or you have researched.

• Identify 2 tables that would be important to the organization to store their business transactions.
• Describe 5 attributes (fields) for each of the tables, identifying at least one that would require aggregation.
• State which aggregate function would be used and explain why.

Answer 1

1) Users table - for storing all user related information

Attributes in users table - username, email, password_hash, name, profile, etc.

2) Orders table - for storing all the orders of reatiler

Attribute in table - item_list, user_who_ordered, total, payment_type, status, etc.