A Gentle Introduction to

SQL


Pick an engine:

ACME Accounts

This tutorial uses an example database which is typical of a simple accounts system. ACME sell products to a number of account customers. These customers regularly place orders. They are not required to pay immediately and so may be in debt to ACME temporarily. (They may even be in credit but this is less common).googleCe cours d'instruction emploie une base de données d'exemple qui est typique d'un système simple de comptes. Produits de vente de POINT CULMINANT à un certain nombre de clients de compte. Ces clients passent régulièrement des commandes. Ils ne sont pas requis de payer immédiatement et ainsi peuvent être dans la dette au POINT CULMINANT temporairement. (ils peuvent même être en crédit mais c'est moins commun).

BADGUY PRODUCT
Customers with accounts at ACME Products stocked by ACME
ID NAME ADDRESS
C001 Wile E Coyote www.warnerbros.com
C002 Sylvester www.warnerbros.com
C003 Tom www.mgm.com
C004 Elmer Fudd www.warnerbros.com
C005 Dick Dastardly www.warnerbros.com
ID DESCRIPTION PRICE
P001 Anvil 75
P002 Portable holes 5
P003 Horseshoe magnet 80
P004 TNT 50
P005 Bomb 50
P006 Elastic band 2
P007 Rocket roller skates 80
P008 Space ship 60000000
P009 Road sign "Diversion Left" 30
P010 Road sign "Diversion Right" 30
RECEIPT SHIPPED
Money received from customers Shipments made to customers
BADGUY RDATE NOTES AMOUNT
C005 1998-02-10 DD 5
C005 1998-03-10 DD 5
C005 1998-04-10 DD 5
C005 1998-05-10 DD 5
C005 1998-06-10 DD 5
C005 1998-07-10 DD 5
C001 1998-07-15 Cheque 100
C001 1998-07-23 Cash 255
BADGUY SDATE PRODUCT QUANTITY
C005 1998-01-01 P008 1
C001 1998-07-10 P003 1
C001 1998-07-22 P004 2
C001 1998-07-22 P005 12
C001 1998-07-23 P005 12
C001 1998-07-23 P006 1
C001 1998-07-23 P007 1

A few points should be noted for such financial systems:googleQuelques points devraient être notés pour de tels systèmes financiers: