Step 1: For each of the columns in the tables below, indicate the data type that you will use for that column (aka field or attribute).

Step 2: Fill out the tables in the template with sample data. You need to make up sample data for each table. Indicate the sample data for each table beginning in row 2. Add sample data of four rows for the CUSTOMER table, six rows for CREDIT_CARD_ACCOUNT table, three rows for the MERCHANT table and ten rows for the SALE table.

Name of Table 1: CUSTOMER

CID (PK)	CName	CCity	CState	CZip	CPhone	CAnnualIncome
(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)

Name of Table 2: CREDIT_CARD_ACCOUNT

CreditCardNumber (PK)	CID (FK)	CurrentBalance	ExpirationDate
(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)

Name of Table 3: MERCHANT

MID (PK)	MName	MAddress	MState	MZip	MCity	MType
(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)

Note: MType can only take one of the two values: Online Merchant, Physical Store Merchant

Name of Table 4: SALE

SaleID (PK)	MID(FK)	CreditCardNumber (FK)	SaleDate	TotalSaleAmount	ItemTypeID (FK)
(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	(Indicate Data Type)	Integer

Name of Table 5: ITEM_TYPE

ItemTypeID (PK)	ItemType
Integer	Text
1	Electronics
2	Clothes
3	Perfumes
4	Groceries
5	Furniture