1
2
Resulting Table Schema: Customers
| Attribute Name | Data Type | Business Definition | Notes |
|---|
| Customer_ID | integer | A unique, universal identification for a customer. | Unique identifier |
|---|
| Name | text | The first and last name of a customer. | |
|---|
| Affiliate_Company | text | An organization a customer may be connected to. | |
|---|
| Email | text | A customer's email address, used for receipts, news, and promotional offerings. | |
|---|
| Address | text | A customer's mailing address, used for deliveries and secure statements. | |
|---|
| City | text | The city a customer resides in. | |
|---|
| Age | integer | A customer's age, in years. | |
|---|
| Loyalty_Plan | integer | Tells if a customer is a loyalty member. | FALSE is a keyword for 0TRUE is a keyword for 1
|
|---|