INTRODUCTION TO DATABASE MANAGEMENT - Concepts of Database Management - page 19

Copy

19

BookCode BranchNum CopyNum Quality Price

0180 1 1 Excellent

Excellent
Excellent
Good
Excellent
Excellent
Fair
Poor
Excellent
Excellent
Excellent
Excellent
Good
Excellent
Excellent
Good
Excellent
Excellent
Excellent
Excellent
Excellent
Excellent
Good
Good

7.19
7.19
7.99
5.99
8.00
8.00
3.50
2.25
24.50
24.50
25.95
25.95
19.95
25.95
25.95
19.95
7.99
21.95
21.95
21.95
21.95
21.95
13.95
34.50

0180 1 1

1
2
1
1
2
3
1
2
1
1
2

0189 2

0189 2

0200 1

0200 2

0200 2

0200 2

0378 3

0378 3

079X 2

079X 3

079X 3

079X 4 1

079X 4 2

079X 4 3

0808 2 1

1

1351 2

1351 2 2

1351 2 3

1351 2 4

1351 3 1

1351 3 2

1382 2 1

138X
138X
138X
2226
2226
2226
2226
2226
2226
2281
2766
2766

2 1 12.95

Excellent

2 2 12.95

Excellent

2 3 6.95

Good

1 1 14.96

Excellent

1 2 14.96

Excellent

1 3 8.95

Good

3 1 14.95

Excellent

3 2 Excellent 14.95

4 1 Fair 3.95

4 1 Excellent 21.00

3 1 Excellent 7.95

3 2 Good 3.95

FIGURE 1-18 Sample data that relates books to authors and books to branches for Henry Books (continued)