|
SECTION Volver
a la página Principal
Asignación
#1
Documentación
y referencias Asignación #2
Asignación
#3
|
|
Tabla
Books
|
|
|
ISBN
|
Title
|
Author |
Year |
List
Price |
PublisherID |
| 0-7897-0916-3 |
Using
Microsoft Access 97 |
Roger
Jennings |
1997 |
$40.00 |
01 |
| 0-987-765-7 |
Casino
de Hull |
Dan
Stuart |
2000 |
$10.00 |
02 |
| 9-087-765-6 |
Adolescents |
G.
Isaac |
1995 |
$25.00 |
03 |
Tabla Orders
| OrderID |
Date |
PublisherID |
| 01 |
4/12/99 |
01 |
| 02 |
5/6/00 |
02 |
| 03 |
9/8/00 |
03 |
Tabla
Order Details
|
OrderID
|
ISBN
|
Quantity
|
| 01 |
0-7897-0916-3 |
3 |
| 01 |
9-087-765-6 |
5 |
| 02 |
0-7897-0916-3 |
4 |
| 02 |
0-987-765-7 |
2 |
| 03 |
9-087-765-6 |
7 |
Tabla
Publishers
|
PublisherID
|
Publisher
Name
|
Address |
City |
State |
Zipcode |
Phone |
| 01 |
QUE
Corporation |
201
W.103rd Street |
Indianapolis |
IN |
46290 |
800-428-5331 |
| 02 |
Ambler |
1600
Streeles Ave. W. Unit #18 |
Concord |
NM |
98765 |
(515)987-3452 |
| 03 |
Pro-Ed |
675
14st |
Briggantine |
NJ |
96548 |
(609)486-7654 |
Informe
de Compra
*El
Informe de Compra suma la cantidad total de libros comprados. |
