Final answer:
When creating a consumer account, records are created in the UserAccounts/Users and UserProfiles/ConsumerProfiles tables, which store login details and personal consumer information, respectively.
Step-by-step explanation:
When a consumer account is created, typically, records are created in at least two database tables. One is the UserAccounts or Consumers table, which stores login details, passwords, and sometimes basic profile information. The second is the UserProfiles or ConsumerProfiles table, which contains detailed information about the consumer, such as name, contact information, and preferences. However, database architecture can vary widely depending on the application's complexity and design requirements, and additional tables may also be involved for security, transaction logs, or audit purposes.