Introduction to Structured Query Language - Database Processing: Fundamentals, Design, and Implementation - page 107

CUSTOMER

Column Name Type Key Required Remarks

CustomerID AutoNumber Primary Key Yes Surrogate Key

LastName Text (25) No Yes

FirstName Text (25) No Yes

Address Text (35) No No

City Text (35) No No

State Text (2) No No

ZIP No

Text (10) No

Phone Text (12) No Yes

Email Text (100) No Yes

Figure 2-42
Column Characteristics
for the QACS Database
CUSTOMER Table

SALE

Figure 2-43
Column
Characteristics for
the QACS Database
SALE Table

Column Name Type Key Required Remarks

SaleID AutoNumber Primary Key Yes Surrogate Key

CustomerID Number Foreign Key Yes Long Integer

SaleDate Date No Yes

Currency, 2
decimal places
Currency, 2
decimal places
Currency, 2
decimal places

SubTotal Number No No

Tax Number No No

Total Number No No

SALE_ITEM

Figure 2-44
Column
Characteristics
for the QACS
Database
SALE_ITEM Table

Column Name Type Key Required Remarks

SaleID Number Primary Key,

Foreign Key

Yes Long Integer

Long Integer

SaleItemID Number Primary Key Yes

ItemID Number Number Yes Long Integer

Currency, 2
decimal places

ItemPrice Number No No