Banner

 

Tables

All the tables used in the book are available in a variety of formats.

MySQL

All tables in chapters 3-10 and ClassicModels

Spatial and temporal databases (Chapter 11)

Access

All tables in Access format (supplied by Gert Jan Hofstede, Wageningen University, The Netherlands). Before working with the tables, it is a good idea to separate them into their logical databases.

PostgreSQL

Three text files

Oracle

All tables in Oracle format.

CD Library tables

Chapter 3

As SQL statements

insert into track values (1, 1, 'Giant Steps', 4.72);
insert into track values (2, 2, 'Cousin Mary', 5.75);
insert into track values (3, 3, 'Countdown', 2.35);
insert into track values (4, 4, 'Spiral', 5.93);
insert into track values (5, 5, 'Syeeda''s song flute', 7); insert into track values (6, 6, 'Naima', 4.35);
insert into track values (7, 7, 'Mr. P.C.', 6.95);
insert into track values (8, 8, 'Giant Steps', 3.67);
insert into track values (9, 9, 'Naima', 4.45);
insert into track values (10, 10, 'Cousin Mary', 5.9);
insert into track values (11, 11, 'Countdown', 4.55);
insert into track values (12, 12, 'Syeeda''s song flute', 7.03);
insert into track values (13, 1, 'Stomp of King Porter', 3.2); insert into track values (14, 2, 'Sing a Study in Brown', 2.85);
insert into track values (15, 3, 'Sing Moten''s Swing', 3.6); insert into track values (16, 4, 'A-tisket, A-tasket', 2.95); insert into track values (17, 5, 'I Know Why', 3.57);
 insert into track values (18, 6, 'Sing You Sinners', 2.75); insert into track values (19, 7, 'Java Jive', 2.85);
insert into track values (20, 8, 'Down South Camp Meetin''', 3.25);
insert into track values (21, 9, 'Topsy', 3.23);
insert into track values (22, 10, 'Clouds', 7.2);
insert into track values (23, 11, 'Skyliner', 3.18);
insert into track values (24, 12, 'It''s Good Enough to Keep', 3.18);
insert into track values (25, 13, 'Choo Choo Ch'' Boogie', 3);

Copy and paste Web table

You can copy-and-paste tabular Web data into an MS Access table. To give you some experience, the CD tables are presented as Web tables. The suggested procedure is:

Note: If the copy and paste to Access does not work, paste into Excel, and then copy and paste from Excel to Access.

TRACK

Trkid Trknum Trktitle Trklength
1 1 Giant Steps 4.72
2 2 Cousin Mary 5.75
3 3 Countdown 2.35
4 4 Spiral 5.93
5 5 Syeeda's song flute 7
6 6 Naima 4.35
7 7 Mr. P.C. 6.95
8 8 Giant Steps 3.67
9 9 Naima 4.45
10 10 Cousin Mary 5.9
11 11 Countdown 4.55
12 12 Syeeda's song flute 7.03
13 1 Stomp of King Porter 3.2
14 2 Sing a Study in Brown 2.85
15 3 Sing Moten's Swing 3.6
16 4 "A-tisket, A-tasket" 2.95
17 5 I Know Why 3.57
18 6 Sing You Sinners 2.75
19 7 Java Jive 2.85
20 8 Down South Camp Meetin' 3.25
21 9 Topsy 3.23
22 10 Clouds 7.2
23 11 Skyliner 3.18
24 12 It's Good Enough to Keep 3.18
25 13 Choo Choo Ch' Boogie 3

Chapter 4

TRACK

Trkid Trknum Trktitle Trklength CDid
1 1 Giant Steps 4.72 1
2 2 Cousin Mary 5.75 1
3 3 Countdown 2.35 1
4 4 Spiral 5.93 1
5 5 Syeeda's song flute 7 1
6 6 Naima 4.35 1
7 7 Mr. P.C. 6.95 1
8 8 Giant Steps 3.67 1
9 9 Naima 4.45 1
10 10 Cousin Mary 5.9 1
11 11 Countdown 4.55 1
12 12 Syeeda's song flute 7.03 1
13 1 Stomp of King Porter 3.2 2
14 2 Sing a Study in Brown 2.85 2
15 3 Sing Moten's Swing 3.6 2
16 4 "A-tisket, A-tasket" 2.95 2
17 5 I Know Why 3.57 2
18 6 Sing You Sinners 2.75 2
19 7 Java Jive 2.85 2
20 8 Down South Camp Meetin' 3.25 2
21 9 Topsy 3.23 2
22 10 Clouds 7.2 2
23 11 Skyliner 3.18 2
24 12 It's Good Enough to Keep 3.18 2
25 13 Choo Choo Ch' Boogie 3 2

CD

CDid CDlblid CDtitle CDyear Lbltitle
1 A2 1311 1 1960 Atlantic
2 83012-2 Swing 1977 Atlantic

LABEL

Lbltitle Lblstreet Lblcity Lblstate Lblpostcode Lblnation
Atlantic 75 Rockefeller Plaza New York NY 10019 USA

Chapter 5

CD

(see preceding CD table)

LABEL

(see preceding LABEL table)

RECORDING

rcdid comptitle rcdlength rcddate
1 Giant Steps 4.72 1959-May-04
2 Cousin Mary 5.75 1959-May-04
3 Countdown 2.35 1959-May-04
4 Spiral 5.93 1959-May-04
5 Syeeda's Song Flute 7 1959-May-04
6 Naima 4.35 1959-Dec-02
7 Mr. P.C. 2.95 1959-May-04
8 Giant Steps 5.93 1959-Apr-01
9 Naima 7 1959-Apr-01
10 Cousin Mary 6.95 1959-May-04
11 Countdown 3.67 1959-May-04
12 Cousin Mary 4.45 1959-May-04
13 Stomp of King Porter 3.2
14 Sing a Study in Brown 2.85
15 Sing Moten's Swing 3.6
16 "A-Tisket, A-Tasket" 2.95
17 I Know Why 3.57
18 Sing You Sinners 2.75
19 Java Jive 2.85
20 Down South Camp Meetin' 3.25
21 Topsy 3.23
22 Clouds 7.2
23 Skyliner 3.18
24 It's a Good Enough to Keep 3.18
25 Choo Choo Ch' Boogie 3

TRACK

CDid trkid rcdid
1 1 1
1 2 2
1 3 3
1 4 4
1 5 5
1 6 6
1 7 7
1 8 1
1 9 6
1 10 2
1 11 3
1 12 5
2 1 13
2 2 14
2 3 15
2 4 16
2 5 17
2 6 18
2 7 19
2 8 20
2 9 21
2 10 22
2 11 23
2 12 24
2 13 25

COMPOSITION

compid

comptitle

compyear

1

Giant Steps

2

Cousin Mary

3

Countdown

4

Spiral

5

Syeeda's Song Flute

6

Naima

7

Mr. P.C.

8

Stomp of King Porter

1924

9

Sing a Study in Brown

1937

10

Sing Moten's Swing

1997

11

"A-Tisket, A-Tasket"

1938

12

I Know Why

1941

13

Sing You Sinners

1930

14

Java Jive

1940

15

Down South Camp Meetin'

1997

16

Topsy

1936

17

Clouds

18

Skyliner

1944

19

It's a Good Enough to Keep

1997

20

Choo Choo Ch' Boogie

1945

PERSON

psnid psnfname psnlname
1 John Coltrane
2 Tommy Flanagan
3 Paul Chamber
4 Art Taylor

You must create the other tables so you learn how to map relationships in a relational database.

 

 

This page is part of the promotional and support material for Data Management (sixth edition) by Richard T. Watson
For questions and comments please contact the author

Date revised: 19-Oct-2016