SQL for Database Construction and Application Processing - Database Processing: Fundamentals, Design, and Implementation - page 302

CustomerID LastName FirstName Street City State ZipPostalCode

1000 Janes Jeffrey 123 W. Elm St Renton WA 98055

1001 Smith David 813 Tumbleweed Lane Durango CO 81201

1015 Twilight Tiffany 88 1st Avenue Langley WA 98260

98110

1033 Smathers Fred 10899 88th Ave Bainbridge Island WA

1034 Frederickson Mary Beth 25 South Lafayette Denver CO 80201

1036 Warning Selma 205 Burnaby Vancouver BC V6Z 1W2

105 Locust Ave Atlanta GA 30322

1037 Wu Susan

1040 Gray Donald 55 Bodega Ave Bodega Bay CA 94923

1041 Johnson Lynda 117 C Street Washington DC 20003

1051 Wilkens Chris 87 Highland Drive Olympia WA 98508

CustomerID LastName FirstName Country AreaCode PhoneNumber Email

1000 Janes Jeffrey USA 425 543-2345 [e-mail]

1001 Smith David USA 970 654-9876 [e-mail]

1015 Twilight Tiffany USA 360 765-5566 [e-mail]

1033 Smathers Fred USA 206 876-9911 [e-mail]

1034 Frederickson Mary Beth USA 303 513-8822 [e-mail]

1036 Warning Selma Canada 604 988-0512 [e-mail]

USA 404 653-3465 [e-mail]

1037 Wu Susan

1040 Gray Donald USA 707 568-4839 [e-mail]

1041 Johnson Lynda USA 202 438-5498 NULL

1051 Wilkens Chris USA 360 765-7766 [e-mail]

(a) CUSTOMER Table Data

Figure 7-16
Sample Data for the View
ridge Gallery Database

This happens because the View Ridge Gallery data shown in Figure 7-16 is sample data,
not the complete data for the database. Therefore, the primary key numbers for CustomerID,
ArtistID, WorkID, and TransactionID in the data set are not sequential.
This, of course, raises the question of how to override DBMS mechanisms that provide
automatic surrogate key numbering. The answer to this question varies among DBMS products
(as does the method for generating the surrogate values). A discussion of this topic and the com-
plete set of SQL INSERT statements needed to enter the data for the DBMS products discussed
in this topic are in Chapters 10A (SQL Server 2012), 10B (Oracle Database 11 g Release 2), and 10C
(MySQL 5.6). At this point, we recommend that you read the appropriate section for the DBMS
product you are using and populate the View Ridge Gallery database in your DBMS.