Code

1
2
3
4
5
6
7
8
9
10

Resulting Table Schema: Customers

Attribute NameData TypeBusiness DefinitionNotes
Customer_IDintegerA unique, universal identification for a customer.Unique identifier
NametextThe first and last name of a customer.
Affiliate_CompanytextAn organization a customer may be connected to.
EmailtextA customer's email address, used for receipts, news, and promotional offerings.
AddresstextA customer's mailing address, used for deliveries and secure statements.
CitytextThe city a customer resides in.
AgeintegerA customer's age, in years.
Loyalty_PlanintegerTells if a customer is a loyalty member.
  1. FALSE is a keyword for 0
  2. TRUE is a keyword for 1
Designed + built by Jay Sella