4-53: Βάσεις Δεδομένων


Δεδομένα

 for the BookAuthor table

book

author

earnings

Oliver Twist

Charles Dickens

8.000.000

David Copperfield

Charles Dickens

3.500.000

Great Expectations

Charles Dickens

4.000.000

Hard Times

Charles Dickens

500.000

The crow

Stephen King

120.000.000

Shining

Stephen King

110.000.000

Firestarter

Stephen King

60.000.000

Sphere

Michael Crichton

450.000

Everville

Clive Barker

30.000.000

Books of Blood

Clive Barker

250.000

The Mark

Tim LaHay

250.000

The Mark

Jerry B. Jenkins

950.000

 

 

for the BookReference table

book

referenceBook

times

David Copperfield

Oliver Twist

14

Hard Times

Oliver Twist

7

The crow

Oliver Twist

2

The crow

David Copperfield

1

Shining

Great Expectations

1

Firestarter

Books of Blood

1

Firestarter

Shining

3

Sphere

Hard Times

5

Sphere

Great Expectations

2

Everville

Books of Blood

3

 

for the BookReview table

book

reviewer

score

The crow

Clive Barker

8

Oliver Twist

Michael Crichton

9

Shining

Clive Barker

7

Sphere

Michael Crichton

7

Firestarter

Clive Barker

6

Oliver Twist

Stephen King

8

David Copperfield

Stephen King

9

Great Expectations

Clive Barker

10

Great Expectations

Michael Crichton

8

Books of Blood

Clive Barker

8

Everville

George Brown

10

 

for the BookPublish table

book

year

publisher

price

num

Oliver Twist

1987

Everyman

5.000

100.000

David Copperfield

1987

Everyman

4.500

100.000

Great Expectations

1988

Key

4.000

100.000

Hard Times

1979

Esteban

4.500

50.000

The crow

1990

Key

6.000

250.000

Shining

1989

Key

5.000

200.000

Firestarter

1993

Bell

2.000

1.000.000

Sphere

2000

Libanis

3.000

200.000

Everville

2000

Bell

1.800

800.000

Books of Blood

1983

Starbird

3.000

100.000

The Mark

2000

Tyndale House Pub

13.000

100.000